Title: Data Warehouse Developer/Lead Data Engineer
Position Type: Contract
Location: Albany, NY
Hybrid work
Description:
Mandatory Qualifications:
1.Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer
2.Five or more years of experience in design and implement analytical data warehouse schemas (star, snowflake, and hybrid models) in cloud platforms
3.Five or more years of experience in translating business reporting requirements into fact and dimension models.
Desirable Qualifications:
1.Seven years or more experience in a Government Regulated setting
2.Five years of demonstrated hands-on experience with design & development of analytics ready data sets optimized for BI consumption
3.Five years or more of demonstrated hands-on experience developing data models, data mappings, data migrations and assisting in data warehouse design
4.Seven years of experience in Delta Lake, Workflows, SQL, PySpark and job orchestrations
5.Seven or more years of experience in enterprise data warehousing and analytics
6.Seven years or more experience in aligning warehouse design with enterprise data governance security and compliance standards
7.Seven years or more experience working with design artifacts, diagrams and implementation, documentation, providing architecture guidance, best practices, and design reviews.
8.Seven years or more experience with advanced SQL and Spark performance tuning.
9.Seven years or more experience in supporting complex data integrations across hybrid solutions
10.Five or more years of experience with Databricks on AWS cloud platform