Location: Indianapolis, IN (Onsite)

Pay Range: $80,000 to $90,000

Overview

Come grow with us by joining our team as a Power BI Developer! In this role, you will play a critical role for the company and will work alongside other professionals within the team and other departments. The Power BI Developer will be responsible for overseeing and managing our Business Intelligence Systems, including data visualizations and analytics. This role will be focused developing, maintaining, and enhancing the company’s Business Intelligence program for users at all levels of the organization.

Who is Model 1, formerly known as Creative Bus Sales?

Since we got our start in 1980, Model 1 Commercial Vehicles has grown to become the nation’s largest dealership, representing more than 20 top manufacturers across the U.S. And we did it all by listening to and investing in customers like you. Customers who want more than a dealer. Customers who want a partner in creative solutions to the challenges you face today, and visionary thinking for what’s next.

It’s the strength of our relationships – both with customers and manufacturers – that allows us to keep a finger on the pulse of what you need and what’s possible to not just source but create together. Whether it’s custom-built vehicles or alternative fuel and electric vehicle (EV) options, you’ll have a partner from challenge all the way through solution and beyond.

Our Core Values: At Model 1, we are committed to living our core values:

• Solving Problems: Trust what you know. Work together to find solutions. See every angle and figure it out.
• Setting the Tone: Establish the mood that puts others at ease. Be the person that you’d want to interact with – approachable and transparent.
• Drive Forward: Keep your eyes up to see what’s ahead. Imagine better methods. Seize opportunities. Move the business and the market, meaningfully.
• Find Balance: Match your energy at work to your energy with family, friends, and community. Decide and align your priorities. Pour into yourself and those around you.
• Own It: Take the extra step. Fix issues when they come up. Care from start to finish. Do the right thing, every time.

Responsibilities

Below is an overview of the duties and responsibilities you would take on in this role:

• Design, develop, and maintain modern reports and dashboards to support business decision making across the organization.
• Gather requirements and understand business needs from internal stakeholders to build useful and successful reports and visualizations.
• Validate reporting accuracy by testing outputs and analyzing data in the SQL database and front-end applications.
• Document and maintain a data warehouse and data models to aggregate business data from multiple sources.
• Present information in an easily accessible manner to company leadership
• Understand the data sources and manage risk of incorrect/incomplete data as it relates to the way data is stored or collected.
• Prioritize requests according to business needs, urgency, and scope.

What You Will Gain

• Competitive benefits including health insurance, paid holidays, and vacation pay
• Continuous training to provide you the opportunity to develop your full potential and be a true business partner
• Access to an expansive network of mentors and networking opportunities
• Top quality technology to assist in your daily responsibilities to allow for more efficiencies to deliver outstanding customer service

Minimum Job Requirements:

• 2 years Business Intelligence (BI) experience developing reports and dashboards using Power BI and industry best practices.
• Demonstrated experience using Power Query and DAX in Power BI.
• Experience working with Microsoft SQL and creating views, queries, stored procedures, and otherwise extracting data from enterprise databases.
• Strong interpersonal, customer service, and communication skills.
• Excellent presentation skills to Management and Executive level.
• Ability to manage multiple concurrent tasks.

Preferred Qualifications

• Experience building and managing Microsoft SSRS or similar tabular reporting platform.
• Strong SQL skills including ETLs, SQL replication, and other methods of database management.
• Familiarity with Azure SQL or other cloud-based database platforms.
• Demonstrated experience using Python, R, SAS, or other data science languages.
• Professional Certification or relevant training in Business Intelligence or Data Analytics
• General knowledge of accounting and other business functions

Physical Requirements

• Work will be performed in an office setting.
• May be required to sit in long intervals and climb stairs

Company retains the sole discretion to change the duties of the position at any time.