Senior Data Engineer

Mission Underwriting Services is a company that provides capital and reinsurance access for launching Program Administrator businesses. The Senior Data Engineer will design, implement, and optimize data infrastructure as part of a modern data platform initiative, focusing on building scalable data pipelines and supporting business reporting needs.

Responsibilities:

• Design and implement scalable data pipelines to ingest, transform, and store data from third-party vendors and internal systems using APIs, files, and databases
• Build and maintain a cloud-based data warehouse solution in partnership with architects, ensuring clean, normalized, and performant data models
• Establish and monitor reliable data ingestion processes across systems with varying grain and cadence, ensuring data quality and completeness
• Collaborate with API and integration teams to develop secure, robust data exchange processes with external vendors and internal services
• Set up and manage data connections from the warehouse to BI tools (e.g., Power BI, Looker, Tableau) to enable self-service analytics and dashboarding
• Document data flows, schemas, and definitions, and help drive data governance and standardization efforts across the organization
• Implement data validation, cleansing, and enrichment processes to ensure high-quality data for financial reporting and analytics
• Ensure compliance with data standards, regulatory requirements (e.g., NAIC, SOX), and data security best practices
• Provide technical leadership in data engineering best practices, including version control, CI/CD for data pipelines, testing, and observability
• Build initial dashboards in BI tools
• Give directions to data engineers to ensure that projects are completed on time and to a high standard

Requirements:

• 5+ years of experience in data engineering, data warehousing, or a related field with at least 1-2 years leading implementation projects
• 3+ years of experience in the commercial insurance industry
• Hands on experience with Azure data services
• Strong SQL and performance tuning skills in Microsoft SQL Server environments
• Experience designing data warehouses or data marts with a focus on dimensional modeling and analytics-ready schemas
• Fluent in range of data ingestion: RESTful APIs, JSON/XML ingestion, flat files, message queues, and CDC patterns
• Understanding of data governance, metadata management, and access control
• Familiarity with version control (GitLab) and CI/CD pipelines for data workflows
• Experience working with BI tools like Power BI, Looker, or Tableau, including building dashboards or semantic layers
• Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent experience
• Demonstrated ability to translate business needs into scalable data systems and design
• Experience with data cleanup, fuzzy matching, or AI-driven normalization
• Familiarity with Python, dbt, or Azure Functions is a plus
• Strong communication skills and ability to work cross-functionally with product, engineering, and analytics teams
• Ability to travel up to 10% of the year