Senior BI Engineer

We are looking for a Senior BI Engineer to join our team.

About the project:

Our customer is the leading school transportation provider in North America, being the owner of more than a half of all yellow school buses in the United States. Every day, the company completes 5 million student journeys, moving more passengers than all U.S. airlines combined and delivers reliable, quality services for 1,100 school districts. 

N-iX has built a successful cooperation with the client delivering a range of complex initiatives. As a result, N-iX has been selected as a strategic long-term partner to drive digital transformation on an enterprise level, fully remodeling the technology landscape for 55,000 employees and millions of people across North America. 

Responsibilities:

• Design, develop, and maintain optimized business intelligence solutions with a focus on performance
• Present information through high-performance reports and complex visualizations tailored to business needs
• Translate business requirements into advanced technical specifications and scalable data models
• Design, build, and deploy BI solutions with a focus on efficiency and scalability for large datasets
• Maintain and support data analytics platforms, ensuring optimized query performance
• Assist QA Engineers with testing, troubleshooting, and performance tuning of BI solutions
• Evaluate and improve existing BI solutions for performance, reusability, and scalability
• Conduct analyses with a strong focus on query optimization and data efficiency
• Create technical documentation to support scalable Power BI solutions
• Work with complex Power BI datasets, ensuring robust performance and scalability for large data volumes

Requirements: 

• 5+ years of experience as a BI Engineer or Microsoft Power BI Specialist
• Advanced DAX experience, including writing and optimizing complex DAX formulas, with a focus on performance tuning
• Strong understanding of Power BI performance analysis tools (DAX Studio, Performance Analyzer, Server Timings) to identify bottlenecks and improve model efficiency
• Experience with Tabular Editor and XMLA endpoints for large data model management and performance optimization
• SQL proficiency, with a solid understanding of optimizing complex queries and analyzing query plans
• Experience with large-scale datasets in Power BI and SSAS
• Experience in optimizing data refresh cycles and managing incremental refreshes to support high-performance BI solutions
• Familiarity with DAX context transition and calculation groups for streamlined and high-performing data models
• Proven ability to analyze and debug performance issues across large-scale data environments, with an understanding of advanced data modeling techniques
• Knowledge of Power BI's engine architecture (including formula and storage engines) for performance optimization
• Knowledge of Python programming language 
• Strong analytical skills with an aptitude for identifying performance bottlenecks and solving complex BI problems
• English level - upper-intermediate
• Advanced or higher level of Ukrainian