Business Intelligence Engineer

Description:

On behalf of our client Affinity is seeking an experienced BI Engineer who will be part of the project team responsible for migrating reports from legacy reporting platform, SQL Server Reporting Services (SSRS) to a modern platform, Power BI and Azure Cloud tools. The BI Engineer is responsible for building medium to high complexity Power BI dashboards, paginated reports and SQL datasets. Ability to work independently by understanding legacy reports and porting logic to Power BI or SQL will be a key success factor.

PRIMARY RESPONSIBILITIES

• Analyzes data sources and complex data stores and writes production grade, high performing SQL to extract data.

• Develops business intelligence solutions such as reports and dashboards, with a focus on user experience and design.

• Conducts quality assurance testing, to ensure solutions built are accurate, high functioning, performant, and meet client requirements.

• Conducts change management and releases reports, dashboards, or datasets to business users. • Applies knowledge of DevOps practices including continuous deployment, continuous integration, test-driven development and automated testing.

QUALIFICATIONS

Must have:

• A degree in Data, Science, Business Analytics, Mathematics, or a related field

• A minimum of 3 years of experience with responsibility for developing production business intelligence solutions such as reports and dashboards.

• 3+ years of experience learning, conducting technical data analysis, and extracting and transforming data from complex data stores.

• 3+ years of experience utilizing SQL to query DBs, create stored procedures, triggers and functions.

• 3+ years working with Power BI – creating dashboards and paginated report builds.

• 3+ years of experience designing complex data visualization solutions, whilst taking into account solution user experience.