Lead BI Developer
Core
Design, develop, and maintain scalable enterprise data warehouse solutions and business intelligence environments for property and casualty insurance affiliates.
Role type
Lead Business Intelligence Developer (Data Engineering & Analytics)
Builds
Enterprise data warehouses, ETL/ELT pipelines, Power BI semantic models, reports, and dashboards
Domain
Insurance / Data Engineering & Business Intelligence
Required skills
SQL Server, T-SQL, Dimensional Modeling (Star/Snowflake), Microsoft Fabric (Data Factory, Pipelines, Dataflows Gen2, Notebooks, Lakehouses, Warehouses), Python, PySpark, Power BI (DAX, Semantic Models), ETL/ELT, Data Governance
Preferred skills
Azure Data Engineering, Metadata-driven ingestion, Audit/Logging solutions, CI/CD/DevOps, Agile/Scrum
Technologies
SQL Server, Microsoft Fabric, Power BI, Python, PySpark, Spark
Responsibilities
Design and implement dimensional models; Develop complex T-SQL code and stored procedures; Build and maintain Power BI reports and dashboards; Develop data engineering solutions using Python and PySpark; Monitor data quality and implement governance best practices; Collaborate with stakeholders to translate requirements into scalable solutions; Support operational activities including deployment and performance tuning.
Seniority
Senior, hands-on IC with leadership responsibilities