Database Engineer, Information Systems Specialist 7
Core
Design, develop, and maintain enterprise data warehouse solutions and semantic models to support agency-wide reporting, analytics, and self-service BI.
Role type
Senior Database Engineer (Data Warehouse & Cloud Migration)
Builds
Data warehouse models (star schemas), Power BI semantic layers, and cloud data platform solutions (Snowflake)
Domain
Public Sector / Government / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Data modeling (conceptual, logical, physical), SQL Server, Snowflake, Power BI semantic modeling, ETL/ELT workflows, Data governance, RBAC, Performance tuning
Preferred skills
Azure Data Factory, Python, Dimensional modeling, DevOps practices
Technologies
SQL Server, Snowflake, Power BI, Azure Data Factory, Python
Responsibilities
Translate business requirements into data models; Design and implement Power BI semantic models; Migrate on-premises data warehouses to Snowflake; Establish data governance and security standards; Troubleshoot complex database issues
Seniority
Senior, hands-on IC