Lead BI Developer

• Design, develop, and maintain scalable enterprise data warehouse solutions
• Build, optimize, and support ETL/ELT pipelines using modern data integration tools and frameworks
• Develop and maintain data ingestion, transformation, and orchestration processes in Microsoft Fabric
• Create and manage Fabric Data Engineering workloads, including Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, and Warehouses
• Design and implement dimensional models using Star and Snowflake Schemas
• Develop complex T-SQL code, including stored procedures, views, functions, and performance optimization
• Build and maintain Power BI semantic models, reports, dashboards, and DAX measures
• Develop data engineering solutions using Python and PySpark for large-scale data processing
• Monitor data quality, troubleshoot issues, and implement data governance best practices
• Collaborate with business users and technical teams to gather requirements and translate them into scalable data solutions
• Participate in architecture reviews, code reviews, and technical design discussions
• Support deployment, monitoring, performance tuning, and production support activities

• 5+ years of experience in Data Engineering, Data Warehousing, or Business Intelligence
• Extensive experience with SQL Server, T-SQL Development, SSIS, and enterprise data warehousing
• Strong experience with dimensional modeling, including Star Schemas, Snowflake Schemas, Fact and Dimension Tables, and Slowly Changing Dimensions (SCD)
• Hands-on experience with Microsoft Fabric, including Data Factory, Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, Data Warehouses, and OneLake
• Strong experience using Python, PySpark, and Spark-based data processing
• Advanced Power BI skills, including semantic models, dataset design, DAX development, dashboard development, and performance optimization
• Experience with data integration, ETL/ELT frameworks, data quality processes, and data governance practices
• Ability to work independently with minimal supervision
• Strong analytical and problem-solving abilities
• Excellent communication and stakeholder management skills
• Strong documentation and organizational skills
• Team-oriented mindset and willingness to mentor and share knowledge
• Ability to manage multiple priorities in a fast-paced environment
• Valid photo identification required at the start of virtual interviews, except for internal candidates
• Microsoft Fabric Certifications preferred
• Azure Data Engineering experience preferred
• Experience implementing metadata-driven ingestion frameworks preferred
• Experience building audit, logging, and monitoring solutions preferred
• Knowledge of CI/CD processes and DevOps practices preferred
• Experience supporting large-scale enterprise analytics platforms preferred
• Experience with Agile/Scrum methodologies preferred

• Opportunity to develop skills and advance professionally
• Opportunity to challenge the status quo and shape the future of protection
• Opportunity to support causes that matter to employees
• Camera-on virtual interview process
• Interview accommodations available upon request