Business Intelligence Developer

 

Business Intelligence Developer

 

What you will be doing:

This position is responsible for creating PowerBI reports, integrating with Microsoft Fabric, developing ETL jobs for reporting, and creating advanced SQL queries, views, and stored procedures. The core requirements include providing Business Intelligence/Analytics development for both existing and new/prototype applications, while collaborating daily business units on new and existing initiatives.

Key job responsibilities include:

• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow solutions, including Extract, Transform, and Load (ETL) processes for reporting applications.

• Highly proficient in using T-SQL to develop complex stored procedures and triggers.

• Creating interactive data analysis and data visualization components using PowerBI, performing PowerBI integrations with Microsoft Fabric, and utilizing Power Query.

• Taking charge of the end-to-end development of reporting solutions.

• Occasional travel to conferences and business meetings

This position will get direction from departmental lead. They have full latitude for independent judgment when applying skills and problem-solving capabilities, with input and minimal oversight required by supervisor. They update their job knowledge by studying state-of-the-art business intelligence tools, staying informed of industry trends, development techniques, and end user information consumption; participating in educational opportunities; reading professional publications; participating in professional organizations.
 

Key Responsibilities

Responsibility #1– 45%

Development
       •     Design and develop reports and dashboard utilizing PowerBi and PowerQuery.
       •     Requirement gathering
       •     Data Modeling
       •     SQL Scripting

       •     ETL for reporting

       •     Documenting analysis, data/ETL pipelines and business process descriptions

Responsibility #2 – 25%

Configuration and Administration
       •     Configuring and setting governance on PowerBI Platform

       •     Data Source Configuration and Maintenance

       •     Manage User and User Groups

Responsibility #3 – 30%

Business Intelligence

• Manage the design, development, and deployment of Business Intelligence solutions using the Microsoft BI stack, and manage the installation, configuration, and management of all related components.

• Brainstorm broad concepts and ideas for various reporting designs, both individually and with the team, and translate them into actionable, tangible objectives.

• Estimate time frames to deliver projects on time and within budget.

​Required Qualifications

Work Experience:

Years of Applicable Experience - 2 or more years

Education:

High School Diploma or GED (Required)

 

Preferred Qualifications

Skills:

       •     Business Intelligence Tools and Reporting Applications
       •     ETL Concepts
       •     Database and Data warehousing

       •     Microsoft Fabric

Experience:

       •     Microsoft BI stack solutions
       •     SQL Scripting skills

 

Additional Job Requirements:

• Remain in a stationary position for prolonged periods of time 

• Be adaptive and change priorities quickly; meet deadlines 

• Attention to detail 

• Operate computer programs and software 

• Ability to communicate effectively with audiences in person and in electronic formats.   

• Day-to-day contact with others (co-workers and/or the public) 

• Making independent decisions 

• Ability to