Crash Champions is home to a collection of team members driven by a deeply rooted purpose and guided by a powerful principle: Here, We Do More.
It is the Crash Champions DNA and it is the mark of who we are. Above everything, we believe in what we do; and we hold fast to the conviction of why we do it. As the largest founder-led collision repair service provider in the U.S., we serve our customers and business partners with an unexpected level of personal and professional service to build trust at every touch point.
Responsibilities
Crash Champions is seeking a Senior Database Engineer to join our IT Data Analytics team which supports Data andReportinginitiatives across the organization. The primary responsibility of this role is to design, implement, and support reporting and our data warehousesolutions.The candidatemusthave strong experience using the Microsoft SQL Server Platform with an emphasis in T-SQL and SSIS development. As a member of our Data Analytics team, the role will work closely with ourData Architect and IT Directorand 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.
- Experience with SQL Server 2012 and higher (SQL Server 2016 and higher is a plus), including SQL Server Master Data Management Services
- Experience with Snowflake, Azure SQL Server, Data Warehouse, Power App and Data Factory a plus
- 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 validationand 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) skillsusing Azure DevOps, GIT, and SmartSheetto work and roadmap in a fast paced, dynamic environment with changing deadlines and requirements
- 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
- Must be U.S. Citizen or Permanent Resident
- 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
Job Post Information* : Posted Date 2 months ago (12/21/2023 5:22 PM)
Job ID 2023-2461
# of Openings 1
Prioritization Tier 2 - Staffing Needs