Developer, Special Projects MPact - MCLEOD SOFTWARE

OpenTalent; Birmingham (AL); On-site; USD 80,000 - 105,000; Full time

Job summary

MPact-focused analytics developer sought to translate business needs into scalable Power BI solutions, data models, and SQL-based optimizations. The role collaborates with stakeholders and engineering teams to deliver reliable, intuitive analytics within .NET and Azure environments.

The position emphasizes data quality, performance tuning, and secure reporting. You will work across Power BI Service, SQL Server, and Azure resources to empower informed business decisions.

Qualifications

• Experience designing and maintaining Power BI dashboards and datasets.
• Ability to translate business requirements into analytical solutions and visualizations.
• Experience building data models with fact/dimension tables and appropriate security.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and datasets.
• Translate business requirements into analytical solutions with visualizations and data models.
• Develop, test, and optimize DAX measures, SQL queries, views, and procedures.
• Build analytical data models including fact/dimension tables and hierarchies.
• Support dataset publishing, refresh schedules, and access management in Power BI Service.
• Monitor and improve report and query performance for speed and reliability.
• Ensure data quality through validation and reconciliation processes.
• Collaborate with cross-functional teams to gather requirements and troubleshoot.
• Support DevOps practices and environment promotion for analytics assets.
• Maintain documentation for data models and reporting logic.

Skills

Power BI

DAX

SQL

Data modeling

Azure

.NET

ETL

Stored procedures

Security

DevOps

Tools

Power BI Service

SQL Server

Azure SQL

.NET tooling

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

Competencies:

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