Power BI Technical Lead

Holman Enterprises; United States; Remote; USD 81,000 - 118,000; Full time

Job summary

Join a forward-thinking organization that values innovation and collaboration! As a Technical Lead specializing in Power BI, you will play a crucial role in shaping the future of data analytics. Your expertise will guide the development of scalable solutions, establish best practices, and lead a team dedicated to delivering high-impact analytical solutions. This is not just a job; it's an opportunity to make a significant impact in a company that prioritizes employee growth and well-being. With competitive compensation and a comprehensive benefits package, you will thrive in a supportive environment that encourages continuous learning and improvement.

Benefits

Health Insurance

Vision Insurance

Dental Insurance

Life and Disability Insurance

401(k) plan with Company Match

Paid Time Off (PTO)

Tuition Reimbursement

Employee Assistance Program

Qualifications

• 7+ years of BI development experience with 4+ years in Power BI.
• Deep expertise in Power BI architecture and performance optimization.

Responsibilities

• Lead design and implementation of BI architecture and strategy.
• Provide technical guidance for Power BI reports and dashboards.

Skills

Power BI

DAX programming

Dimensional modeling

Data warehousing concepts

ETL/ELT processes

Data Security implementation

Power BI performance optimization

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Technology

Tools

Azure Data Lake

Azure SQL

SQL Server

Oracle databases

Azure DevOps

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.

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

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.