Power BI Technical Lead

Holman; Iowa (LA); Remote; USD 81,000 - 118,000; Full time

Job summary

A leading global automotive services organization is seeking a Technical Lead with expertise in Power BI. The role involves designing scalable BI solutions, providing technical leadership, and optimizing Power BI implementations. Join a company that values diversity and offers comprehensive benefits.

Benefits

Health Insurance

Vision Insurance

Dental Insurance

Life and Disability Insurance

401(k) plan with Company Match

Paid Time Off (PTO)

Tuition Reimbursement

Qualifications

• 7+ years of experience in Business Intelligence development.
• 4+ years of hands-on Power BI development experience.

Responsibilities

• Lead the design and implementation of the company’s BI architecture.
• Provide technical guidance in developing Power BI reports and dashboards.

Skills

Power BI

DAX

Data Security

Data Warehousing

ETL/ELT

Education

Bachelor's degree in Computer Science

Tools

Azure SQL

SQL Server

Oracle

Azure Data Lake

Job description

Holman is a family-owned, global automotive services organization anchored by our deeply rooted core values and principles that have enabled us to continue Driving What’s Right throughout the last century. Our teams deliver the Holman Experience by treating our customers and each other as we would like to be treated, and creating positive, rewarding relationships all around.

The automotive markets Holman serves include fleet management and leasing; vehicle fabrication and upfitting; component manufacturing and productivity solutions; powertrain distribution and logistics services; commercial and personal insurance and risk management; and retail automotive sales as one of the largest privately owned dealership groups in the United States.

Position Overview:

Holman, a Computerworld 2024 “Best Places to Work in IT” company is hiring an experienced technical lead with strong knowledge of Power BI to shape the future of data analytics by developing a comprehensive roadmap for Power BI adoption, creating best practices and architectural standards, and resolving any technical challenges related to Power BI. The ideal candidate will be a hands-on technical expert who can design scalable and efficient solutions aligned with business needs and serve as the technical authority for Power BI development across the organization. This is a hands-on role that will work closely with the data engineering team (without performing data engineering tasks) and provide leadership on the technical side of report/dashboard creation, data modeling, and semantic layer development.

Key Responsibilities:

Architecture & Design

• Lead the design, development, and implementation of the company’s BI architecture and strategy.
• Develop and maintain the technical roadmap for Power BI implementation.
• Design scalable and performant semantic models to support current and future business needs.
• Establish architectural patterns and best practices for Power BI development.
• Create and maintain documentation for Power BI architecture standards.
• Design robust testing frameworks for Power BI solutions.
• Collaborate with data governance team in developing data modeling standards and governance frameworks.

Technical Leadership

• Serve as the technical authority for Power BI development.
• Provide technical guidance in developing Power BI reports, dashboards, and advanced analytics solutions.
• Guide the use of advanced Power BI features such as DAX, custom visuals, and Power Query to deliver high-impact analytical solutions.
• Ensure the Power BI environment is optimized for performance, including query performance, report rendering, and dashboard responsiveness.
• Guide optimization of DAX queries and data models
• Collaborate with data engineering team to ensure data models and data flows are optimized for Power BI consumption.
• Ensure proper implementation of security standards
• Evaluate and recommend new Power BI features and capabilities

Development & Implementation

• Develop complex semantic models using best practices.
• Create reusable components and templates for Power BI development.
• Build proof-of-concept solutions for new requirements.
• Optimize existing solutions for better performance.
• Design and implement automated testing solutions.
• Create development standards and patterns.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field
• 7+ years of experience in Business Intelligence development
• 4+ years of hands-on Power BI development experience
• Deep expertise in:
  • Power BI semantic model development
  • DAX programming
  • Dimensional modeling
  • Power BI performance optimization techniques
  • Power BI architecture and best practices related to dashboard/report development
  • Power BI paginated report development
• Strong understanding of:
  • Data warehousing concepts
  • ETL/ELT processes
  • Data Security implementation
  • Azure Data Lake, Azure SQL, SQL Server, and Oracle databases
  • Azure DevOps practices

#LI-BS1

#LI-REMOTE

At Holman, we exist to provide rewarding careers and better lives for employees and their families. We hire, train, empower, and reward exceptional people. Our journey is guided by our desire to get it right every time and the acknowledgement that we have an opportunity to be better. To be better, we have to do better, and to do better we must know better. That’s why we are listening, open to learning new things – about ourselves and each other. We will never stop striving for improved diversity, equity, and inclusion because we are successful together when we feel trusted and supported. It’s The Holman Way.

At Holman, your total compensation goes beyond your paycheck. To position you for success and provide a rewarding career and better life for you and your family, Holman is proud to offer you the benefits you deserve; including protection against illness, disability, loss of work, or preparation for retirement. Below is a brief overview of the programs available to full-time employees (programs may vary by country or worker type):

• Health Insurance
• Vision Insurance
• Dental Insurance
• Life and Disability Insurance
• Flexible Spending and Health Savings Accounts
• Employee Assistance Program
• 401(k) plan with Company Match
• Paid Time Off (PTO)
• Paid Holidays, Bereavement, and Jury Duty
• Paid Pregnancy/Parental leave
• Paid Military Leave
• Tuition Reimbursement

Benefits:

Regular Full-Time

We offer excellent benefits including health, vision, dental, life and disability insurance, and 401(k) with company match. Our time off benefits include Paid Time Off (PTO), paid holidays, bereavement, and jury duty. In addition, we offer paid pregnancy and parental leave, and supplemental paid military leave to eligible employees.

Click here for Washington State benefit information.

Temporary or Part-Time

In geographic areas with statutory paid sick leave, part-time and temporary employees will receive a paid sick leave benefit that meets the mandated requirements.

Click here for Washington State benefit information.

Pay:

We offer competitive wages that are commensurate with job-related skills, experience, relevant education or training, and geographic location, starting in the range of $81,210.00 - $117,760.00 USD annually for full time employees. The annual compensation range is comprised of base pay earnings.

Equal Opportunity Employment and Accommodations:

Holman provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

If you are a person with a disability needing assistance with the application process, please contact [e-mail]

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.