Data Warehouse / Databricks / Delta Lake Developer (Level III)

📍 Location: Albany, NY (Local Candidates Only)
(State client experience required)
📅 Duration: Long Term
💼 Experience Level: Level III (Lead)

Position Overview

We are seeking a highly experienced Level III Data Warehouse / Databricks / Delta Lake Developer to support a client in Albany, NY. The ideal candidate will have extensive experience designing and implementing enterprise data warehouse solutions in cloud environments, particularly using Databricks on AWS, Delta Lake, SQL, and PySpark.

This role requires strong leadership capabilities, deep expertise in enterprise data warehousing, and experience working in government-regulated environments.

Required Qualifications

• 7+ years of experience working on complex IT projects

• 2+ years in a leadership role as a Developer

• 5+ years designing and implementing analytical data warehouse schemas (star, snowflake, hybrid models) in cloud platforms

• 5+ years translating business reporting requirements into fact and dimension models

• 7+ years hands-on experience with:

  • Delta Lake

  • Databricks Workflows

  • SQL & Advanced SQL tuning

  • PySpark

  • Job orchestration frameworks

• 7+ years enterprise data warehousing & analytics experience

• 5+ years hands-on experience with Databricks on AWS

• Experience aligning warehouse design with enterprise data governance, security, and compliance standards

• Experience creating design artifacts, diagrams, documentation, and conducting design reviews

• Experience supporting complex hybrid data integrations

• Strong Spark performance tuning experience

Preferred / Desirable Qualifications

• 7+ years experience in a Government regulated environment

• 5+ years developing analytics-ready datasets optimized for BI consumption

• 5+ years experience in data modeling, mappings, migrations, and warehouse design support

Responsibilities

• Design, develop, and deploy multi-dimensional reports using Cognos BI Suite

• Analyze, design, develop, test, and implement BI and operational reporting solutions

• Maintain a centralized repository of enterprise BI assets (dashboards, visualizations, interactive reports)

• Monitor daily reports to identify data inconsistencies and resolve operational issues

• Enable BI capabilities including:

  • Drill-through reporting

  • KPI and scorecards

  • Advanced visualizations (geospatial & mapping)

  • Predictive analytics

• Collaborate with development teams to support multiple concurrent projects

• Support new technology initiatives

• Troubleshoot and resolve technical issues

• Perform additional duties as assigned