Power BI Technical Lead

Holman Enterprises; Paola (KS); On-site; USD 81,000 - 118,000; Full time

Job summary

Join a family-owned global automotive services organization as a Technical Lead in Power BI. This role is pivotal in shaping the future of data analytics, focusing on developing a comprehensive roadmap for Power BI adoption and creating best practices. As a hands-on expert, you will lead the design and implementation of BI architecture, ensuring optimal performance and security standards. Collaborate with data engineering teams to enhance reporting and dashboard capabilities while guiding the development of advanced analytics solutions. This is an exciting opportunity to make a significant impact in a supportive and growth-oriented environment.

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.
• Deep expertise in Power BI architecture and best practices.

Responsibilities

• Lead the design and implementation of the company's BI architecture.
• Serve as the technical authority for Power BI development.
• Develop complex semantic models and optimize existing solutions.

Skills

Power BI

DAX programming

Data warehousing concepts

Dimensional modeling

ETL/ELT processes

Data Security implementation

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.

• 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.