Senior Data Engineer

Brooksource; Detroit (MI); On-site; USD 150,000 - 210,000; Full time

Benefits offered by this job

401(k) Matching Plan

Paid Holidays

Health, Dental, Vision Insurance

Job summary

You will design and implement ingestion, transformation, and quality processes for structured and unstructured data, guiding teams across data architecture, APIs, and large-scale integration. The role emphasizes leadership, robust engineering standards, and a focus on Insurance data capabilities.

Qualifications

• 8+ years of data engineering experience, including analytics-focused data warehouse environments such as Snowflake.
• Experience delivering cloud-based data platforms and scalable data pipelines in enterprise settings.
• Strong data modeling skills, including Data Vault, and data governance practices.

Responsibilities

• Lead and manage the Data Engineering squad, setting scalable platform standards.
• Design, build, and optimize modern data pipelines and enterprise data solutions.
• Develop cloud-based data engineering solutions (data lakes, data warehouses, data platforms).
• Design scalable data structures and Data Vault modeling for auditable data assets.
• Build data ingestion, transformation, preparation, and quality processes across data sources.
• Develop large-scale data integration, API-based services, and NoSQL/SQL processing.
• Enable trusted data for analytics, ML, and AI use cases across Insurance data domains.
• Partner with business and IT to align data requirements with enterprise priorities.
• Advance Insurance Data and Analytics platform capabilities through governance-aligned engineering.

Skills

Cloud data platforms

Data engineering leadership

Snowflake

AWS S3

dbt

Data Vault

APIs

Python

DevOps

Git

Education

Bachelor’s degree in CS/IS

Advanced degree preferred

Tools

InfoSphere DataStage

Qlik Replicate

CP4D

AWS CLI

Lambda

DynamoDB

Job description

Are you passionate about data, architecture, software development, and analytics? Do you bring deep experience with cloud technologies, data warehousing, data integration, data modeling, and API development? Do you believe in modern engineering practices, collaboration, and innovation to build the next generation of enterprise data and AI platforms? If so, we’d like to talk with you.

We are seeking a Manager Data Engineer / Principal Data Engineer to help design, build, and evolve modern data solutions within our Enterprise Data and AI organization. This role is ideal for a strong technical leader with hands‑on experience delivering cloud‑based data platforms, scalable data pipelines, and enterprise data solutions that support analytics, reporting, data science, and AI use cases.

The ideal candidate will bring experience implementing data lakes, cloud data warehouses, and modern data engineering solutions, including data ingestion, transformation, standardization, preparation, data quality management, and structured and unstructured data processing. This role also requires experience with relational and NoSQL data technologies, large‑scale data integration, API development, and enterprise data modeling, including Data Vault.

Experience with modern cloud data platform technologies, data architecture, and software engineering practices is essential. Knowledge of AI/ML, data science, and LLM‑related use cases is also a plus. Knowledge of the insurance business data domain is a significant advantage, particularly in supporting solutions that enable Insurance Data and Analytics capabilities. This role will be responsible for creating, maintaining, and optimizing enterprise data pipelines and related processes that support strategic analytics, machine learning, and AI‑driven business capabilities across Insurance line of business.

The selected candidate will help build and advance critical platform capabilities, including Insurance Data and Analytics solutions, data ingestion and transformation frameworks, governance‑aligned data engineering processes, and trusted data foundations for analytics and AI. The ideal candidate will bring proven experience leading cloud data engineering initiatives, driving scalable solution design, and establishing strong engineering standards across complex enterprise environments.

The Work Itself

• Lead and manage the Data Engineering squad, focusing on scalable platforms and engineer growth.
• Design, build, and optimize modern data pipelines and enterprise data solutions that support analytics, reporting, data science, and AI use cases.
• Develop and implement cloud‑based data engineering solutions, including data lakes, cloud data warehouses, and enterprise data platforms.
• Design scalable data structures and support enterprise data storage using Data Vault modeling to enable flexible, auditable, and resilient data solutions.
• Build and support data ingestion, transformation, preparation, and quality processes across structured and unstructured data sources.
• Develop robust solutions for large‑scale data integration, relational and NoSQL data processing, and API‑based data services.
• Enable trusted, high‑quality, and accessible data for analytics, machine learning, and AI‑driven business capabilities.
• Partner with business and technology teams to define data requirements, transformation rules, integration needs, and solution designs that align to enterprise and line‑of‑business priorities.
• Help advance Insurance Data and Analytics platform capabilities through scalable engineering, strong data foundations, and governance‑aligned practices.
• Establish and maintain data quality, validation, monitoring, metadata, and lineage processes to support reliable and well‑managed enterprise data assets.
• Apply modern software engineering methods and Agile practices to deliver scalable, reliable, and maintainable data solutions.
• Promote engineering, operational, and design standards across data platforms and services.
• Evaluate and recommend tools, technologies, and approaches that improve performance, delivery, and long‑term supportability.
• Collaborate across business and IT teams to solve complex technical challenges and deliver practical, scalable solutions.
• Support enterprise data governance, data management, and data security requirements.
• Provide technical leadership, mentor team members, and contribute to strong delivery outcomes through effective collaboration and sound engineering practices.

The Skills You Bring

• Strong technical expertise in cloud data platforms and modern data engineering tools, combined with team leadership, strategic thinking, and cross‑functional collaboration.
• Bachelor’s degree in computer science, Information Systems, or a related field; advanced degree preferred.
• 8+ years of progressive experience in data engineering, including deep expertise in analytics‑focused data warehouse environments such as Snowflake.
• Extensive hands‑on experience designing and delivering cloud‑based data solutions on AWS, including services such as S3, AWS CLI, Lambda, and DynamoDB.
• Strong experience with modern data engineering and integration tools such as dbt, Qlik Replicate, InfoSphere DataStage, and CP4D.
• Deep expertise in data modeling, including Data Vault, and in designing scalable, auditable, and resilient data structures that support enterprise analytics, reporting, and AI use cases.
• Proven experience architecting and optimizing large‑scale data ingestion, transformation, cleansing, standardization, and deduplication processes across complex data environments.
• Strong programming and automation skills in Python and other scripting languages used to support enterprise data engineering solutions.
• Demonstrated experience leading the design and implementation of enterprise data pipelines using Git, DevOps practices, and modern software engineering approaches.
• Strong background in large‑scale data integration, API development, and data migration across distributed systems and platforms.
• Deep understanding of data governance, data management, metadata, lineage, and data security, with the ability to embed these practices into engineering solutions.
• Proven ability to lead end‑to‑end solution delivery, working independently while providing technical direction across multiple initiatives and technologies.
• Demonstrated success establishing and enforcing engineering, design, and operational standards across teams and platforms.
• Ability to evaluate emerging tools, technologies, and architectural approaches, and recommend scalable solutions that improve performance, maintainability, and long‑term supportability.
• Proven ability to influence, advise, and partner effectively with senior business and technology stakeholders to identify strategic challenges, assess options, and recommend solutions.
• Strong track record of mentoring engineers, promoting engineering excellence, and contributing to high‑performing teams.
• Extensive experience across the full software development lifecycle, including architecture, design, implementation, testing, deployment, and operational support.
• Knowledge of the insurance business data domain is a major plus, including familiarity with insurance data concepts, business processes, and analytics use cases.
• Ability to design trusted, high‑quality data foundations that enable advanced analytics, machine learning, and AI‑driven business capabilities.
• Strong problem‑solving, communication, and leadership skills, with the ability to translate complex technical concepts into practical business solutions.
• Insurance Business data domain knowledge.

Why Join Us?

• 401(k) Matching Plan
• Relationship Driven Process to Find Your Best Fit
• 6 Paid Holidays
• Regular Meetings to Ensure Quality in Your Engagement

EEO Statement:

Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances.

Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.

Pay Disclaimer:

The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.