Champions Do More

　　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 Data Architect to lead the data architecture, design, implement, and maintain data solutions that support the data and reporting strategy of the enterprise. You will work with the data team and reporting team members and the IT leadership to ensure that the data architecture meets the business needs and aligns with the best practices. You will also develop and oversee data developers and Data Warehouse over the SQL Server architecture, especially Stored Procedures and SSIS, to create data solutions. You should have extensive experience with this platform and be able to demonstrate your skills and knowledge. As part of the Data Analytics team, you will play a key role in driving data-driven decisions and insights across the organization.

　　Manages existing architecture

　　Develops and maintains new data solutions, data models and ETL processes, using SQL skills to optimize, tune, and ensure data quality and consistency. Tests, documents, automates, and deploys all code and database objects.

　　Ensures the quality of the data development team and the data solutions

　　Mentors and guides data developers in a cross-functional team with the reporting developers and communicates insights and technical solutions to business functional leaders.

　　Communicates and collaborates with business and IT stakeholders to design and implement data solutions for analysis, reporting, and interfaces, aligning with the organization’s goals and strategies.

　　Qualifications

　　Experience as a technical lead of a data warehouse team with excellent communication and presentation skills to effectively collaborate with multiple business functions.

　　Experience with Microsoft SQL Server and Microsoft Azure SQL Server, Data Warehouse and T-SQL scripting and query optimization.

　　Familiar with Master Data Services and data governance principles

　　Skilled in MS BI Stack (SSRS, SSIS, SSAS) and data visualization tools

　　Power BI

　　Knowledge of GIT Source Control and best practices

　　Extensive knowledge and experience implementing ETL design patterns for data warehousing, including Kimball methodology and different source data types like SQL Server, Excel, Flat Files, APIs, etc.

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

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

　　Full lifecycle development (SDLC) skills using Azure DevOps, GIT 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

　　Benefits

　　Competitive pay

　　Weekly Paychecks

　　401K with company match

　　Medical/Vision/Dental Insurance

　　Additional elective benefits

　　Submit a Referral

　　Job Post Information* : Posted Date 1 month ago (1/10/2024 3:27 PM)

　　Job ID 2024-3625

　　# of Openings 1

　　Category Information Technology

　　Prioritization Tier 2 – Staffing Needs

　　Days Per Week 5