Data Engineer

We’re supporting a specialty insurance organization that’s expanding its Data & Analytics team and looking to add a Senior Data & Analytics Engineer with strong Azure and SQL engineering experience. This is a high-impact role focused on building data marts, developing scalable pipelines, and enabling analytics across critical business domains. This team is modernizing the entire data ecosystem — great chance to step into a growing function and shape the data strategy moving forward. What You’ll Do • Design, develop, and support data marts that serve underwriting, claims, actuarial, and operational analytics. • Build and orchestrate Azure Data Factory (ADF) pipelines to ingest and transform large datasets from the enterprise warehouse. • Develop T-SQL stored procedures, views, and transformations for high-performance data processing. • Partner closely with Data Analytics teams to build and maintain Power BI semantic models and DAX-based KPIs. • Ensure data quality, lineage, and consistency across large-scale environments. • Improve performance, optimize cloud data workloads, and strengthen governance. • Produce clear documentation for data models, logic, and technical processes. • Stay current with Azure and data engineering best practices to support continuous improvement. What We’re Looking For • 5+ years in data engineering, BI development, or analytics engineering roles. • Deep hands-on expertise with: • Microsoft T-SQL • Azure Synapse Analytics • Azure Data Factory • Power BI (semantic modeling a plus) • Strong understanding of data warehousing, dimensional modeling, and data mart architecture. • Experience building pipelines, optimizing SQL, and supporting analytics teams. • Ability to work cross-functionally with business, data, and technical stakeholders. • Background in P&C insurance data (policy, claims, underwriting, actuarial) is highly preferred, but not mandatory for strong technical candidates. • Experience working with enterprise insurance data models (ACORD, IBM, etc.) is a plus.