Business Intelligence Engineer

Position Details
Location: Dearborn, MI

Department: Information Technology
Reports to: Manager, Business Intelligence
Job Classification: Remote

FLSA: Exempt
Job Band: Professional

Job Summary
The primary responsibility of this position is to work with the Business Intelligence Team to create innovative data solutions to strengthen Carhartt’s competitive advantage.  The BI engineer will work on a dynamic and exciting team to create data visualizations, data applications and analytic components for the entire enterprise.

We Are All Leaders at Carhartt
In our words and by our actions, we strive to emulate the hardworking example set forth by our founder, Hamilton Carhartt. We Lead Business by creating value, delivering on results, and making changes along the way. We Lead Self by being inclusive, recognizing that our differences make us stronger as we strive to build a better world, together, for all hardworking people. We Lead Others by communicating and clearly defining the path as we walk bravely into the future. Working at Carhartt, we are all given a seat at the table and the honor of continuing the legacy.

Representative Responsibilities 

• Develop and maintain star schema semantic models supporting BIE production content and a broad self-service community.
• Design and develop reports utilizing Microsoft Power BI and Report Builder.
• Write T-SQL to support the creation of new dashboards and to audit data accuracy.
• Collaborate with the entire BI team to manage the standards BI adheres to in building cohesive and consistent deliverables.
• Collaborate with Data Team Business Analysts and business users to clarify the requirements needed to develop well architected and performant semantic models and reports.
• Collaborate with Data Engineering team to gain an understanding of the EDW and Lakehouse data to properly define updates or new tables needed to support performant semantic models.
• Participate in the BI team’s agile process writing stories, managing tasks, and committing to the completion of assigned deliverables.
• Provide support for access, training, and usage of Power BI dashboards.
• Ensure quality and data integrity across the entire reporting domain, and ensure that proper integration testing is performed before introducing reports to the production environment.
• Perform a wide variety of technical and clerical tasks; including but not limited to, defining or documenting processes, procedures, or system, ongoing support work, or department functions requiring daily or weekly routine maintenance, as assigned.

Required Education

• Bachelor’s degree in computer science or related field, or equivalent years of experience

Required Skills & Experience 

• Minimum of 5-6 years of experience, including working knowledge with Power BI and the following:
  • Minimum of 3 years of experience with Power Query and DAX.
  • Minimum of 3 years of experience with T-SQL and SQL Server Management Studio.
• Experience with Tabular Editor 3, DAX Studio and ALM Toolkit is preferred.
• Experience with Microsoft Fabric, CI/CD and Git is preferred.
• Demonstrated knowledge in the use of business tools, as related to work tasks (Word, Visio, Net Meeting, Power Point, Excel, MS Project, etc.).
• Microsoft-related certifications are a plus.
• Excellent written and oral communication skills with the proven ability to communicate with all levels, including management and retail partners.
• Strong organizational skills with demonstrated ability to prioritize workload, own and plan project work with a strong attention to detail.
• Demonstrated ability to carry out projects and/or assigned work duties. 
• Ability to work both independently and collaboratively as part of a team.
• Open to feedback.

Physical Requirements and Working Conditions 

• Extended periods of time sitting, standing, typing on a computer are required. 
• Willing to work some weekends if necessary. 
• National travel required (up to 10%).
• This position has a Remote location: Associate will have no regular requirement to be on-site. Travel on-site is limited to special events.
• Carhartt is a tobacco free workplace.

#LI-Remote