The Senior Data Engineer plays a critical role in advancing Crash Champions’ enterprise data strategy by designing, developing, and maintaining scalable data solutions that support business intelligence, analytics, and operational reporting.
This role is responsible for building and optimizing data pipelines, integrating data from diverse sources, and modernizing legacy systems to ensure the delivery of high-quality, reliable, and accessible data.
The Senior Data Engineer will work closely with the Data Manager, Director of Data Analytics, and key business stakeholders to translate complex business requirements into efficient technical solutions that drive informed decision-making across the organization.
Design and engineer robust data solutions by collaborating with the Data and Reporting teams to gather business requirements, define use cases, create technical designs, and implement scalable solutions for data analysis, reporting, and system integration.
Serve as a technical liaison in cross-functional environments, effectively communicating complex data concepts and delivering actionable insights to business and functional leaders.
Develop complex SQL queries, data transformations, aggregations, stored procedures, and triggers to support enterprise data needs.
Design and implement technical/data architecture for Operational Data Stores (ODS) and Data Warehouses using the Kimball methodology.
Build and maintain SSIS ETL packages within SQL Server Data Tools (SSDT), ensuring performance and scalability.
Manage individual workload and task prioritization using Agile Scrum practices, participating in sprint planning and daily standups.
Conduct unit, system, and integration testing to validate the accuracy and performance of all developed code and database objects.
Create and maintain comprehensive documentation for data integration solutions, including data dictionaries, process/data flow diagrams, and runbooks to support ongoing operations and future development.

Requirements

7+ years of hands-on experience with Microsoft SQL Server; experience with Microsoft Fabric and Python is a plus.
7+ years of experience with Azure SQL Server, Azure Data Warehouse, and Azure Data Factory; Azure Synapse experience is a plus.
Proficient in ETL design patterns for data warehousing, including implementation of Kimball methodology.
Demonstrated experience integrating data from multiple sources (e.g., SQL Server, Excel, Access, flat files, on-prem/cloud systems, RESTful APIs, Smartsheet) using SSIS or other ETL tools.
Skilled in developing complex T-SQL queries, stored procedures, triggers, and handling error resolution.
Strong analytical, problem-solving, and critical thinking skills with the ability to troubleshoot complex issues and determine scalable solutions.
High attention to detail with a strong focus on data validation and thorough documentation of processes, standards, and procedures.
Excellent written and verbal communication skills, with the ability to translate technical concepts into clear, actionable insights for both technical and non-technical stakeholders.
Effective interpersonal skills; able to build positive relationships across teams and collaborate in cross-functional environments.
Ability to multi-task and manage competing priorities in a fast-paced, dynamic setting.
Demonstrated stress management capabilities; able to remain focused and perform well under pressure.
Experience with full software development lifecycle (SDLC) using tools such as Azure DevOps, GIT, and Smartsheet.
Bachelor’s degree in Management Information Systems, Engineering, Mathematics, Economics, Computer Science, or a related field.

Benefits

Medical Insurance
Dental Insurance
Vision Insurance
Group Life Insurance
Disability Insurance
401k Retirement Plan with match
Referral Bonus (“Crash From Crash”)
5 Paid Holidays

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Microsoft SQL ServerAzure SQL ServerAzure Data WarehouseAzure Data FactoryETL design patternsKimball methodologyT-SQLSSISdata integrationdata validation

Soft Skills

analytical skillsproblem-solvingcritical thinkingattention to detailwritten communicationverbal communicationinterpersonal skillsmulti-taskingstress managementcollaboration