Business Intelligence Developer

Overview

Join the best in the industry at Nextech and embark on a rewarding career journey! For over 30 years, we've built our success on a foundation of Quality, Value, and Integrity, fostering enduring partnerships with thousands of satisfied customers. With over 2,000 team members nationwide,
Nextech sets itself apart from other companies by being America’s largest HVAC/R service provider.

As we continue to grow, we're committed to offering an exceptional work experience for our employees with numerous opportunities for development and advancement. If you pride yourself on quality work, integrity, and dedication, we want you on our team.
Nextech boasts outstanding review ratings on Indeed and Glassdoor, making it the premier destination for HVAC professionals. Elevate your career by joining Nextech today!

The Business Intelligence Developer is responsible for designing, developing, and maintaining Power BI dashboards and reports (80%) while providing support for on-premises SSRS reporting (20%). This role requires expertise in Azure Analysis Services (AAS), SQL Server, Azure Data Factory (ADF), SSRS, and DAX for data modeling and visualization. Strong skills in data integration, transformation, and report development are essential, with a focus on working across Azure cloud environments, data warehouse architecture, and on-premises SQL Server systems.

• Excellent Health Insurance options including a FREE employee only option
• Dental, Vision, Accident, Critical Illness, Disability and Supplemental Life Insurance options
• FREE life insurance equal to your annualized pay rate
• 401k with a 50% match up to the first 6% of your contributions
• 7 paid Holidays
• 2 paid Personal days
• 10 paid Vacation days

• Develops and maintains Power BI dashboards and reports utilizing Azure Analysis Services (AAS)
• Creates and optimizes DAX calculations and tabular models to enhance Power BI performance and usability
• Designs and manages ETL pipelines with Azure Data Factory (ADF) to ingest and transform data from multiple sources
• Develops and supports on-premises SSRS reports to meet operational reporting requirements
• Writes and optimizes complex SQL queries for data extraction, transformation, and performance tuning across Azure SQL and on-premises SQL Server
• Utilizes SQL Server Analysis Services (SSAS) and Azure Analysis Services to build and optimize tabular models
• Implements Row-Level Security (RLS) and enforces data governance practices in Power BI and AAS
• Collaborates with business stakeholders to understand reporting needs and deliver scalable, actionable dashboards
• Monitors, troubleshoots, and optimizes Power BI, AAS, and SSRS for performance and scalability
• Completes assigned tasks in a safe, accurate, thorough, and alert manner
• Upholds Company policies and procedures
• Works in a professional manner with managers, supervisors, coworkers, customers, and the public
• Other related job duties as assigned

• Strong DAX skills for creating complex measures and calculated columns
• Proficiency in SQL, including query optimization, stored procedures, and indexing strategies
• Knowledge of Azure Synapse Analytics and Data Lakes
• Familiarity with ETL processes, data warehousing, and dimensional modeling best practices
• Understanding of data modeling principles: star schema, fact and dimension tables
• Familiarity with Python or R for advanced data analytics
• Exposure to Dev Ops practices for Power BI and SQL deployments
• Ability to proactively identify and implement process improvements and new Power BI features
• Strong analytical and problem-solving skills
• Excellent communication skills to interact with both technical and…