1 ncdpi snowflake tableau developer expert jobs found
Job Description
Job Description
The Expert SQL, Snowflake Tableau School Business Data Developer will provide analysis and leadership on data analysis projects across the DPI enterprise focusing on School Business Data.
***This is an onsite position in Raleigh, NC.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience w/ SQL databases and related ETL and advanced data validations in Snowflake (and also Azure) and data visualization using Tableau/Power BIRequired7YearsUnderstanding of different database platforms: Oracle, SQL Server, DB2, and MS Access.Required7YearsUnderstanding of Data Warehousing (AWS/Snowflake and Azure) and data mining for reporting and analysis.Required7YearsUnderstanding of modeling strategies (dimensional, Snowflake, relational, unstructured).Required7YearsExperience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logicRequired7YearsDemonstrated experience in writing ad-hoc SQL statementsRequired7YearsProven experience with ERD/Data Modelling tools (Toad or others)Required7YearsExperience with data reporting tools especially Tableau (and preferrable also Power BI, Viya, others).Required7Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2All work must be completed on-site. Do you accept this requirement?Question3Candidate must be able to attend an in-person interview. Do you accept this requirement?Question4Please list candidate s email address. Question5Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.Question6Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?Question7Vendor must notify the agency if any portion of the requirements listed in this task order is to be outsourced to other countries. Do you accept this requirement?Question8Candidates submitted above the rate of - will not be considered. Do you accept this requirement? Question9Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement?Question10Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm?
***This is an onsite position in Raleigh, NC.
Currently, the enterprise is acomplex, multi-platform data environment (including some legacy Mainframe) consistingof Amazon AWS/Snowflake and Microsoft Azure, along with Tableau and Power BI.Technologies in use include Oracle, DB2, MySQL, and SQL Server, Tableau andPower BI, as well as desktop-based applications such as MS Access and MS Excel.DPI aims to establish an enterprise data model with a primary goal ofstandardizing shared data entities and attributes and a secondary goal ofstandardizing database management systems and tools. School Business andHR/other data will be hosted in Snowflake running in AWS, generally using SQLServer. The Expert Snowflake Tableau School Business Data Developer willprovide analysis and leadership on data analysis projects across the DPIenterprise focusing on School Business Data. You will provide insight to otherdata analysts, data architects, and application developers related to creatingan enterprise data reporting model that meets DPI's school business andtechnical requirements. You will also provide subject matter expertise andtraining to other SQL/Snowflake and Tableau developers and analysts.
Skills:
Experience with SQL databases and related ETL and advanceddata validations in Snowflake (and also Azure) and data visualization usingTableau (and also Power BI).
Bachelor s Degree or equivalent in a technology relatedfield (e.g. Computer Science, Engineering, etc.) with a focus on programming, datastructure, data visualization.
Proven track record of solving real world problems usingdata. Excellent critical thinking skills is a must have for this role.
Understanding of different database platforms: Oracle, SQLServer, DB2, and MS Access.
Understanding of Data Warehousing (AWS/Snowflake and Azure) and data mining for reporting and analysis.
Understanding of modeling strategies (dimensional, Snowflake,relational, unstructured).
Experience designing and delivering data mappingspecifications for large reporting platforms. Writing and maintaining businessrules using SQL logic
Demonstrated experience in writing ad-hoc SQL statements
Strong interest in playing a technical data steward roleacross our business and technology partners to understand and detail our data,appropriate
Proven experience with ERD/Data Modelling tools (Toad orothers).
Experience in executing projects in an Agile / Hybridenvironment
Demonstrated technical ability in learning new technologiesand adapting to frequent changes in the technical environment
Experience with data reporting tools especially Tableau (andpreferrable also Power BI, Viya, others).
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience w/ SQL databases and related ETL and advanced data validations in Snowflake (and also Azure) and data visualization using Tableau/Power BIRequired7YearsUnderstanding of different database platforms: Oracle, SQL Server, DB2, and MS Access.Required7YearsUnderstanding of Data Warehousing (AWS/Snowflake and Azure) and data mining for reporting and analysis.Required7YearsUnderstanding of modeling strategies (dimensional, Snowflake, relational, unstructured).Required7YearsExperience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logicRequired7YearsDemonstrated experience in writing ad-hoc SQL statementsRequired7YearsProven experience with ERD/Data Modelling tools (Toad or others)Required7YearsExperience with data reporting tools especially Tableau (and preferrable also Power BI, Viya, others).Required7Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2All work must be completed on-site. Do you accept this requirement?Question3Candidate must be able to attend an in-person interview. Do you accept this requirement?Question4Please list candidate s email address. Question5Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.Question6Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?Question7Vendor must notify the agency if any portion of the requirements listed in this task order is to be outsourced to other countries. Do you accept this requirement?Question8Candidates submitted above the rate of - will not be considered. Do you accept this requirement? Question9Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement?Question10Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm?
About Buzzclan