Champions Do More
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 on Microsoft Fabric platform.The candidatemusthave 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 ourData Architect and IT Directorand business stakeholders across the organization.
Responsibilities
- Responsible for developing and engineering data solutions with Data team and Reporting team and to gather business requirements, use cases, technical design, and implement solutions for data analysis, reporting, and data interfaces
- Communicates well in cross-functional team environment and has a strong track record in insights and technical solutions to business functional leaders
- Create complex queries, data transformation, aggregation, stored procedures, and triggers.
- Build technical / data architecture for ODS / DW using Kimball methodology
- Develop and test SSIS ETL packages using SSDT
- Managing own timelines and task priorities utilizing Agile Scrum methodology
- 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.
Core Competencies :
Teamwork - Builds strong relationships and works collaboratively with others to meet shared goals; Strengthens relationships by promoting mutual trust and supporting teammates.Accountability - Holds self and others accountable to meet and exceed commitments; Focuses on quality results, monitors progress, learns from mistakes, and strives for improvement.Results Driven - Can be counted on to drive pace to achieve results and consistently meet or exceed expectations; Executes priorities with a focus on critical work to achieve targeted goals.Sound Judgment - Makes good decisions by analyzing the situation, leveraging experience, and using available information; Objectively evaluates problems, discovers root causes, and works toward timely resolution.Customer Focus - Maintains a relentless focus on customers and is committed to the continuous improvement of services; Keeps internal and external customers in mind at all times and strives to proactively address customer concerns and needs.Specialized Competencies :
Interpersonal Skills - Ability to create positive interactions with customersMulti-Tasking - Ability to work on and successfully complete many different task or projects at the same timeProblem-Solving - Ability to determine solutions to customer problems quickly and effectivelyStress Management - Ability to perform under pressure and in adversityExcellent Written and Verbal Communication - Ability to provide clear, concise information in writing, via phone or in-personQualifications
Experience with Microsoft Fabric and SQL ServerExperience with Azure SQL Server, Data Warehouse, and Azure Data Factory, Azure Synapse a plusKnowledge and experience implementing ETL design patterns for data warehousing including Kimball methodologyExperience 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 moreDemonstrate understanding of error handling techniques in MS SQL code and Microsoft SSIS solutions.Strong analytical ability, problem-solving, and critical thinking skillsStrong attention to detail and data validationand in documentation of methods, procedures, standardsExcellent communication and presentation skills to effectively collaborate with multiple business functions across our organization; and works effectively in a team environmentFull lifecycle development (SDLC) skillsusing Azure DevOps, GIT, and SmartSheetto work and roadmap in a fast paced, dynamic environment with changing deadlines and requirementsBachelor’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 developmentMust be U.S. Citizen or Permanent ResidentTechnologies
Microsoft SQL Server 2012+ JSON / XMLT-SQLMaster Data ServicesMS BI Stack (SSRS, SSIS, SSAS)Power BI preferred but not requiredSnowflake, Microsoft Azure SQL Server, Data Warehouse and Data FactoryTFS / VSTS / GIT Source ControlBenefits
Crash Champions provides equal employment and affirmative action opportunities to applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability.
Crash Champions offers the comprehensive benefits, including :
Competitive payWeekly Paychecks401K with company matchMedical / Vision / Dental InsuranceAdditional elective benefits