Senior Data Engineer - Remote

Champions Do More

At Crash Champions, We Believe the Difference is Trust. Crash Champions is the one of the fastest growing and most exciting brands in the collision repair industry. The company is the largest founder-led multi-shop operator (MSO) of high-quality collision repair service in the U.S., serving customers and business partners at more than 600 state-of-the-art repair centers in 36 states across the U.S. Crash Champions was founded in 1999 as a single Chicago repair center by industry veteran and 2022 MSO Executive of the Year, Matt Ebert. For more information, and to locate a local repair center, visit www.crashchampions.com.

Responsibilities

Crash Champions is seeking a Senior Database Engineer to join our IT Data Analytics team which supports Data and Reporting initiatives across the organization. The primary responsibility of this role is to design, implement, and support reporting and our data warehouse solutions. The candidate must have strong experience using Microsoft Fabric and Microsoft SQL Server with an emphasis in T-SQL and SSIS development. As a member of our Data Analytics team, the role will be to work closely with our Data Architect and IT Director and business stakeholders across the organization.

Responsible for working with business leaderships and IT Data Analytics team to gather business requirements, use cases, technical design, and implement solutions for data analysis, reporting, and data interfaces

Works in cross-functional team environment and has a strong track record to communicating insights and technical solutions to business functional leaders

SQL performance tuning and optimization

Build technical/data architecture for ODS/DW using Kimball methodology

Develop and test SSIS ETL packages using SSDT

Managing Timelines and task priorities utilizing Agile Scrum methodology

Create complex queries, data transformation, aggregation, stored procedures, and triggers.

Implement and administer SQL Server Master Data Management Services.

Perform unit, system, and integration testing of all developed code and DB objects.

Fully support the documentation of the data integration solutions, provide data dictionaries, Data Flow/Process Flow diagrams and update runbooks.

Automate DB deployments using DevOps Pipelines

Qualifications

Experience with Microsoft Fabric and SQL Server

Experience with Azure SQL Server, Data Warehouse, and Azure Data Factory, Azure Synapse a plus

Bachelor’s Degree in Management Systems, Engineering, Mathematics, Economics, Computer Science or related field with 7+ years of daily experience with Microsoft SQL Server administration and development

Knowledge and experience implementing ETL design patterns for data warehousing including Kimball methodology

Experience working with different source data such as SQL Server, Excel, Access, Flat Files, On-Prem, Cloud, APIs, RESTful API calls within SSIS/ETL , and many more

Demonstrate understanding of error handling techniques in MS SQL code and Microsoft SSIS solutions.

Strong analytical ability, problem-solving, and critical thinking skills

Strong attention to detail and data validation and in documentation of methods, procedures, standards

Excellent communication and presentation skills to effectively collaborate with multiple business functions across our organization; and works effectively in a team environment

Full lifecycle development (SDLC) skills using Azure DevOps, GIT, and SmartSheet to work and roadmap in a fast paced, dynamic environment with changing deadlines and requirements

TECHNOLOGIES

Microsoft SQL Server 2012+ JSON/XML

T-SQL

Master Data Services

MS BI Stack (SSRS, SSIS, SSAS)

Power BI preferred but not required

Snowflake, Microsoft Azure SQL Server, Data Warehouse and Data Factory

TFS/VSTS/GIT Source Control

Submit a Referral

Job Post Information

: Posted Date *

2 months ago

(5/8/2024 3:34 PM)

Job ID

2024-6432

# of Openings

1

Category

Information Technology

Prioritization

Tier 2 – Staffing Needs

Location : Address

808 South Central Expy

Posting Location : City

Richardson

Posting Location : State/Province

TX

Location : Postal Code

75080

Days Per Week

5