Senior BI Developer

Robert Half - Saint Paul, MN

Full-time - Mid Level

Saint Paul, MN

Administrative and Support Services

About the position

The Senior BI Developer will be responsible for creating and managing business intelligence (BI) and analytics solutions that transform data into actionable insights. This role involves data modeling, performance tuning, and the development of efficient SQL queries, views, and stored procedures. The developer will utilize tools such as Power BI, Azure Analysis Services, and Azure Data Factory (ADF) to deliver high-quality BI solutions, ensuring alignment with business needs and Agile methodologies.

Responsibilities

• Design, develop and deploy BI solutions (e.g. reporting tools).
• Carry out partitioning of data and performance tuning of reports.
• Conduct data analysis and write SQL, views, stored procedures, and DAX scripts.
• Understand and translate business needs to technical specifications.
• Ensure Agile operations and two-week sprints in alignment with the business architecture.
• Use Kusto (KQL) for querying and managing data from IoT devices.
• Familiarize with .NET web apps for minor software updates.
• Create and optimize data models; work in the data warehouse.
• Develop reports using Power BI, transitioning from SSRS to Paginated reports.

Requirements

• 4-6 years minimum experience using Power BI.
• 2-3 years minimum experience with Azure Data Factory (ADF).
• Strong SQL knowledge and significant experience with performance tuning.
• Experience with Azure portal and Kusto (KQL).
• Ability to navigate in Visual Studio 2019 efficiently.
• Understanding of Agile methodology and ability to estimate tasks effectively.

Nice-to-haves

• Familiarity with the Cosmos database.
• Familiarity with Microsoft Fabric or Snowflake.
• Prior exposure to AI tools and Azure Analysis Services.

Benefits

• Long-term contract opportunity.