NCDPI - Snowflake - Tableau Developer - Expert

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.

Currently, the enterprise is acomplex, multi-platform data environment (including some legacy Mainframe) consisting of Amazon AWS/Snowflake and Microsoft Azure, along with Tableau and Power BI.Technologies in use include Oracle, DB2, MySQL, and SQL Server, Tableau and Power 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 will provide 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 creating an enterprise data reporting model that meets DPI's school business and technical requirements. You will also provide subject matter expertise and training to other SQL/Snowflake and Tableau developers and analysts.

Experience with SQL databases and related ETL and advanceddata validations in Snowflake (and also Azure) and data visualization using

Tableau (and also Power BI).

Bachelor s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on programming, data structure, 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 role across 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 technologies and adapting to frequent changes in the technical environment

Experience with data reporting tools especially Tableau (andpreferrable also Power BI, Viya, others).

Skill Required /Desired Amountof Experience Experience w/ SQL databases and related ETL and advanced data validations in Snowflake (and also Azure) and data visualization using Tableau/Power BIRequired7

Years Understanding of different database platforms:
Oracle, SQL Server, DB2, and MS Access.

Required7

Years Understanding of Data Warehousing (AWS/Snowflake and Azure) and data mining for reporting and analysis.

Required7

Years Understanding of modeling strategies (dimensional, Snowflake, relational, unstructured).Required7

Years Experience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logicRequired7

Years Demonstrated experience in writing ad-hoc SQL statementsRequired7

Years Proven experience with ERD/Data Modelling tools (Toad or others).Required7

Years

Experience with data reporting tools especially Tableau (and preferrable also Power BI, Viya, others).Required7

Years

No.Question Question1

Absences 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?

Question2

All work must be completed on-site. Do you accept this requirement?

Question3

Candidate must be able to attend an in-person interview. Do you accept this requirement?

Question4

Please list candidate s email address. Question5

Please 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.

Question6

Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?

Question7

Vendor 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?

Question8

Candidates submitted above the rate of - will not be considered. Do you accept this…