Senior BI Developer

$135,200 - $156,000/Yr

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, Views, and Stored Procedures, with a strong emphasis on using Power BI, Azure Analysis Services, and Azure Data Factory (ADF). The position is a long-term contract opportunity, primarily targeting candidates local to Minnesota.

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.
• Responsible for creating and optimizing data models; will work in their data warehouse.
• Report development (Power BI, moving SSRS reports to Paginated reports).

Requirements

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

Nice-to-haves

• Familiarity with the Cosmos database will be considered a plus.
• Familiarity with Microsoft Fabric or Snowflake is considered a plus.
• Prior exposure to AI tools and Azure Analysis Services will be beneficial.

Benefits

• Medical insurance
• Vision insurance
• Dental insurance
• Life insurance
• Disability insurance
• 401(k) plan