Who are we? Chemical Guys is more than a brand. It's a lifestyle with a worldwide following driven by adventure, a passion for shine, and a love for the road ahead. We welcome Any and All who share this passion to become part of our family!

Chemical Guys has become a true omnichannel leader in the automotive appearance industry with a massive social media following and product distribution around the world. But this is still just the beginning. We want to win in the long run, drive innovation, and refine the industry while having fun along with you. So, grab a wash mitt, and some soap, put that great smile on your face, and don’t look back… it’s going to be an unforgettable ride!

We are seeking a highly skilled and experienced Business Intelligence Developer to join our team. This individual will play a crucial role in leveraging data and analytics to drive strategic decision-making and enhance business performance. This position will be responsible for overseeing the design, development, and implementation of business intelligence solutions, with a strong focus on Microsoft Power BI, data warehouse management, ETL processes, and statistical data analysis.

What's in it for you?

• $115,000 to $130,000 annually
• Medical, Dental, Vision, Life Insurance,
• 401k with company match
• FSA and short & long term disability
• bonus incentive plan
• flexible hours, generous PTO
• an associate discount

This role is 3 days a week in Torrance and does NOT offer relocation assistance.

*No third parties and we do NOT have the ability to sponsor now or in the future.

What will you do?

• Design and create interactive and visually appealing dashboards, reports, and data visualizations using Power BI.
• Connect and integrate data from various sources, such as databases, spreadsheets, and cloud services, into Power BI datasets.
• Clean, transform, and model data to ensure it is suitable for reporting and analysis.
• Develop and maintain reports and dashboards that provide valuable insights and support data-driven decision-making.
• Optimize Power BI reports and queries for performance and responsiveness.
• Implement security measures to ensure data confidentiality and compliance with data protection regulations.
• Collaborate with business analysts, data engineers, and other stakeholders to understand requirements and deliver solutions that meet business needs.
• Create and maintain documentation for data models, report specifications, and best practices.
• Provide training and support to end-users to enable them to effectively use Power BI reports and dashboards.

What will you need?

• Bachelor’s degree in computer science, Information Technology, Data Science, or a related field (or equivalent work experience).
• Excellent time management skills – multitasking is critical.
• Proven experience as a Power BI Developer for at least 5 years, with a strong portfolio of Power BI projects.
• Proficiency in Microsoft Power BI, including data modeling, DAX (Data Analysis Expressions), and MQuery.
• Strong data analysis and visualization skills.
• Experience with data integration from various sources.
• Knowledge of data warehousing concepts and T-SQL.
• Familiarity with data governance and security best practices.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.
• Attention to detail and a commitment to delivering high-quality reports and dashboards.

Bonus Points for:

• Experience working in retail domain.
• Hands on experience with dbt and Fivetran.

First Year Deliverables (What to expect your first year)

3 months:

• In-depth understanding of the technology stack used in the organization.
• Develop personal and professional relationships with the user community.
• Take ownership of reporting objects to support operational needs.

6 months:

• Analyze the tactical and strategic business requirements for BI.
• Be a champion on Power BI and provide training to users to develop ad-hoc reports.
• Collaborate with business and functional team members to develop business critical reports and visualizations.

12 months:

• Established and recognized as the in-house expert on BI.
• Lead future BI development projects and on-going production support.
• Expert level contribution and guidance with respect to current and future use of BI technologies.

Job Type: Full-time

Pay: $115,000.00 - $130,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible schedule
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Professional development assistance
• Vision insurance

Experience level:

• 10 years
• 11 years
• 5 years
• 6 years
• 7 years
• 8 years
• 9 years

Schedule:

• 10 hour shift
• 8 hour shift
• Monday to Friday
• No weekends

Application Question(s):

• Do you have any experience in retail or finance?
• Do you have a portfolio of Power BI projects?
• Are you able to be onsite in the Torrance office 3 days a week without relocation assistance?

Experience:

• data warehousing concepts: 5 years (Required)
• T-SQL: 5 years (Required)
• retail domain: 1 year (Preferred)
• Hands on with dbt: 1 year (Preferred)
• Hands on with Fivetran.: 1 year (Preferred)
• data modeling: 5 years (Preferred)
• DAX (data analysis expressions): 5 years (Preferred)
• MQuery: 5 years (Preferred)
• Power BI reports development: 5 years (Required)

Ability to Relocate:

• Torrance, CA 90505: Relocate before starting work (Required)

Work Location: In person