Job Summary:
McLeod Software is a company that values its employees and focuses on growth and success. They are seeking a Developer for Special Projects who will deliver and support data-driven solutions by building and optimizing Power BI dashboards and SQL solutions to enhance business decision-making.
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.
Qualifications:
Required:
โข 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.
โข 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.
Preferred:
โข 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.
โข 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.
Company:
McLeod Software is a provider of trucking software, transportation dispatch, accounting, operations & brokerage management software. Founded in 1985, the company is headquartered in Birmingham, USA, with a team of 501-1000 employees. The company is currently Late Stage.