Developer, Special Projects (MPact)

McLeod Software; Birmingham, Northern (AL, KY); Hybrid; USD 95,000 - 120,000; Full time

Job summary

McLeod Software seeks a Developer, MPact to translate business needs into scalable analytics by building Power BI dashboards, data models, and SQL solutions.

The role focuses on delivering reliable analytics within .NET and Azure environments, collaborating with stakeholders and engineering teams to ensure intuitive reporting and robust data governance.

Qualifications

• Bachelor's degree in data analytics or related field; 4+ years of experience required; 8+ years preferred.
• Strong Power BI, data modeling, and DAX experience.
• Strong SQL skills and database design knowledge.
• Experience with DevOps practices and version control (Git).
• Familiarity with Azure data services (Azure SQL, Synapse, Key Vault) preferred.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and datasets for operational and strategic decision-making.
• Translate business requirements into analytical solutions with intuitive visualizations and scalable data models.
• Develop, test, and optimize DAX measures, SQL queries, views, and stored procedures for accuracy and performance.
• Build analytical data models with fact and dimension tables, relationships, hierarchies, and security.
• Manage Power BI Service functions: dataset publishing, refresh schedules, security, and workspace administration.
• Monitor performance and improve report and query speed and reliability.
• Ensure data quality and integrity through validation, cleansing, and reconciliation processes.
• Collaborate with cross-functional teams to gather requirements and deliver scalable data solutions.
• Support deployment, version control, and DevOps processes; maintain documentation on data models and logic.

Skills

Power BI

DAX

SQL

Data modeling

Azure

Git/DevOps

Communication

Team collaboration

Problem solving

Education

Bachelor’s degree in data analytics or related field

Tools

Power BI Service

.NET

Azure Synapse

Git

SQL Server

Job description

McLeod Software Headquarters
100 Corporate Dr
Birmingham, AL 35242, USA

Description

Purpose of the Position:The Developer, MPact delivers and supports data-driven solutions that enhance MPact applications and enable informed business decision-making. This role translates business requirements into scalable analytics by building and optimizing Power BI dashboards, data models, and SQL solutions, while leveraging DAX for accurate, high-performing insights. The Developer collaborates with stakeholders and engineering teams to ensure solutions are reliable, intuitive, and aligned with business needs, while supporting database design, DevOps practices, and integration within .NET and Azure environments.

Essential Duties and Responsibilities:

• Design, develop, and maintain Power BI dashboards, reports, and datasets that support operational and strategic decision-making.
• Translate business requirements into effective analytical solutions, including intuitive visualizations, scalable data models, and actionable reporting outputs.
• Develop, test, and optimize DAX measures, calculated columns, SQL queries, views, and stored procedures to ensure accuracy, usability, and performance.
• Build and maintain analytical data models, including fact and dimension tables, relationships, hierarchies, and security structures aligned with reporting needs.
• Manage and support Power BI Service functions such as dataset publishing, refresh schedules, row-level security, workspace administration, and access management.
• Monitor and improve report, dataset, and query performance, identifying opportunities to enhance speed, reliability, and user experience.
• Ensure data quality and integrity through validation, cleansing, transformation, and reconciliation processes across reporting and analytics solutions.
• Collaborate with cross-functional business and technical teams to gather requirements, troubleshoot issues, and deliver scalable data and reporting solutions.
• Support deployment, version control, and environment promotion processes using established development and DevOps practices.
• Maintain documentation related to data models, calculations, report logic, security, and technical processes to support ongoing maintenance and knowledge sharing.
• Ability to learn internal software and systems
• Ability to collaborate and communicate across varying organizational levels
• Ability to communicate technical information effectively
• Ability to manage competing projects and priorities
• Ability to multi-task
• Resourceful and Independent

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education/Experience:

• Bachelor’s degree with 4+ years of experience in data analytics in transportation and/or software-related roles, required; 8+ years of experience in data analytics in transportation and/or software-related roles.
• Experience providing technical support for software or data solutions, preferred.
• Experience working with data related to customer orders, shipments, or invoicing, a plus.
• Experience training or supporting end users in the use of reporting, analytics, or software tools, preferred.
• Intermediate knowledge of Microsoft Office required.
• Intermediate to expert experience with Power BI, including dashboard development, data modeling, and Power BI Service management, required.
• Intermediate experience with data modeling concepts such as star and snowflake schemas, fact and dimension tables, required.
• Intermediate to advanced proficiency in DAX, including complex measures, time intelligence, and performance optimization, required.
• Strong SQL skills, including complex queries and performance tuning, required.
• Foundational knowledge of database design and data integrity, required.
• Experience with version control (e.g., Git) and familiarity with DevOps practices, including CI/CD, preferred.
• Basic knowledge of .NET and API integration, preferred.
• Familiarity with Azure data services such as Azure SQL, Synapse/SQL Pools, and Key Vault, preferred.

Why McLeod?

At McLeod Software, we believe that our employees are our greatest competitive advantage. Each employee contributes directly to McLeod Software’s growth and success. With over 550 full-time team members, we’re still growing while staying true to who we are. Our priorities stay where they belong: with our employees, our customers, and the continued growth of our business. When you join McLeod, you’re joining a company that’s built for the long haul—with a clear vision, strong leadership, and a commitment to investing in our people.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.