Location: Indianapolis, IN

Pay Range: $75,000 to $85,000

Overview

Come grow with us by joining our team as a SQL Developer to support our Business Intelligence team in our Indianapolis office In this role, you will play a critical role for the company and will work alongside other professionals within the team and other departments. You'll be creating and maintaining datasets to support the data needs of all departments, as well as the BI team. Excellent Microsoft SQL skills is the core competency for this role. You'll be dealing with data warehousing and will help drive our overall data strategy to ensure reliable, robust, and accurate access to our business data from multiple data sources.

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:

• Develop, implement, and optimize stored procedures and functions using T-SQL
• Review and understand ongoing business reporting requirements
• Analyze and optimize existing SQL queries for performance improvements
• Suggest new queries, views, and stored procedures to handle business data requirements
• Develop procedures and scripts for any required data transformation or migrations
• Aid in data integrity and cleansing efforts
• All other duties as assigned.

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' experience as a Microsoft SQL Developer or similar role
• Excellent understanding of T-SQL programming and Microsoft SQL Server and database architecture
• Demonstrated experience with complicated joins, nested queries, stored procedures, and views in Microsoft SQL
• SQL Server Reporting Services (SSRS) experience
• Bachelor's degree with a business or data focus, or equivalent work experience
• Solid foundation of organizational and communication skills needed to manage multiple concurrent projects and priorities

Preferred Qualifications

• Experience with ETL processes and/or data modeling
• Experience supporting Business Intelligence, reporting, and dashboarding data requests and requirements
• Data Warehouse development/management experience
• Relevant industry certifications

Physical Requirements

• Work will be performed in an office setting
• May be required to sit in long intervals and climb stairs
• Must have good manual dexterity

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