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!

 

 

Role

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.

Company Benefits

 

• 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

Min Compensation

USD $110,000.00/Yr.

Max Compensation

USD $130,000.00/Yr.

Responsibilities

• 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

Qualifications

• 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 DevOps 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 non-technical stakeholders
• Ability to thrive in a dynamic and fast-paced environment
• Able to prioritize duties and manage multiple projects from start to finish with minimal supervision
• Ability to coordinate, contribute to, and work within a cross-functional team
• Must possess the ability to take initiative to complete assignments and job responsibilities with minimal supervision
• Exceptional attention to detail and excellent organizational skills

 

Education and Experience

• BS/BA degree in Computer Science, Electronics Engineering, or a related technical discipline from an accredited university, or five (5) years of relevant experience
• 3+ years of experience developing Power BI dashboards with Azure Analysis Services (AAS) as the backend
• 2+ years of experience using Azure Data Factory (ADF) to build and manage ETL pipelines
• 2+ years of experience developing and maintaining on-premises SSRS reports
• Experience with SQL Server Analysis Services (SSAS) and tabular models
• Experience in authoring, editing, and processing Azure Analysis Services models for report consumption
• Previous experience in HVAC Industry or other service business preferred

Physical Requirements

• Continuously able to work in office environment
• Continuously able to operate a computer and other office productivity machinery, such as a copy machine, telephone, and computer printer
• Continuously able to sit at a computer for up to 8 hours
• Able to alternate between sitting and standing, as needed throughout the day
• Occasionally able to lift up to 15 lbs.
• Continuously requires vision, hearing, twisting, and talking
• Occasionally requires walking, lifting, carrying, reaching, kneeling,pushing/pulling, bending, and crouching
•  Rarely requires climbing
• Ability to travel on occasion

Other requirements:

• May be required to use personal smartphone with a camera capable of reading a QR code for 2 factor authentication