Business Intelligence Developer

Business Intelligence DeveloperJoin the best in the industry at Nex tech 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, Nex tech 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. Nex tech boasts outstanding review ratings on Indeed and Glassdoor, making it the premier destination for HVAC professionals. Elevate your career by joining Nex tech 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.What Makes Nextech Different?Excellent Health Insurance options including a FREE employee only optionDental, Vision, Accident, Critical Illness, Disability and Supplemental Life Insurance optionsFREE life insurance equal to your annualized pay rate401k with a 50% match up to the first 6% of your contributions7 paid Holidays2 paid Personal days10 paid Vacation daysMin Compensation USD $92,500.00/Yr. Max Compensation USD $110,000.00/Yr. ResponsibilitiesDevelops 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 usabilityDesigns and manages ETL pipelines with Azure Data Factory (ADF) to ingest and transform data from multiple sourcesDevelops and supports on-premises SSRS reports to meet operational reporting requirementsWrites and optimizes complex SQL queries for data extraction, transformation, and performance tuning across Azure SQL and on-premises SQL ServerUtilizes SQL Server Analysis Services (SSAS) and Azure Analysis Services to build and optimize tabular modelsImplements Row-Level Security (RLS) and enforces data governance practices in Power BI and AASCollaborates with business stakeholders to understand reporting needs and deliver scalable, actionable dashboardsMonitors, troubleshoots, and optimizes Power BI, AAS, and SSRS for performance and scalabilityCompletes assigned tasks in a safe, accurate, thorough, and alert mannerUpholds Company policies and proceduresWorks in a professional manner with managers, supervisors, coworkers, customers, and the publicOther related job duties as assignedQualificationsStrong DAX skills for creating complex measures and calculated columnsProficiency in SQL, including query optimization, stored procedures, and indexing strategiesKnowledge of Azure Synapse Analytics and Data LakesFamiliarity with ETL processes, data warehousing, and dimensional modeling best practicesUnderstanding of data modeling principles: star schema, fact and dimension tablesFamiliarity with Python or R for advanced data analyticsExposure to DevOps practices for Power BI and SQL deploymentsAbility to proactively identify and implement process improvements and new Power BI featuresStrong analytical and problem-solving skillsExcellent communication skills to interact with both technical and non-technical stakeholdersAbility to thrive in a dynamic and fast-paced environmentAble to prioritize duties and manage multiple projects from start to finish with minimal supervisionAbility to coordinate, contribute to, and work within a cross-functional teamMust possess the ability to take initiative to complete assignments and job responsibilities with minimal supervisionExceptional attention to detail and excellent organizational skillsWhat We're Looking ForBS/BA degree in Computer Science, Electronics Engineering, or a related technical discipline from an accredited university, or five (5) years of relevant experience3+ years of experience developing Power BI dashboards with Azure Analysis Services (AAS) as the backend2+ years of experience using Azure Data Factory (ADF) to build and manage ETL pipelines2+ years of experience developing and maintaining on-premises SSRS reportsExperience with SQL Server Analysis Services (SSAS) and tabular modelsExperience in authoring, editing, and processing Azure Analysis Services models for report consumptionPrevious experience in HVAC Industry or other service business preferredPhysical RequirementsContinuously able to work in office environmentContinuously able to operate a computer and other office productivity machinery, such as a copy machine, telephone, and computer printerContinuously able to sit at a computer for up to 8 hoursAble to alternate between sitting and standing, as needed throughout the dayOccasionally able to lift up to 15 lbs.Continuously requires vision, hearing, twisting, and talkingOccasionally requires walking, lifting, carrying, reaching, kneeling, pushing/pulling, bending, and crouchingRarely requires climbingAbility to travel on occasionOther requirements:May be required to use personal smartphone with a camera capable of reading a QR code for 2 factor authentication