Business Intelligence Developer Jobs

The Business Intelligence Developer will work in collaboration with our internal Business Intelligence Project Team and will focus on:

• Translating business requirements into technical specifications

• Designing and developing the Data Analytics (Data ingestion, data warehouse, data lake ODS, pipeline, error handling, Azure cloud data gateway, Power BI security, Power BI workspace) reusable framework

• Designing Data Models based on technical specifications

• Exploring in-depth PowerBI features for advanced analytics which require more customization like DataFlow & DataMart

• Designing and building End to End Data pipeline and ETL packages including:

o Staging Areas and Date Warehouse Layouts with SQL Server

o Data pipeline with SSIS

o ETL Processes with SSIS / SSDT

o Error Handling

o Dashboards and reports with PowerBI Desktop

o Troubleshoot day to day data warehouse issues

The position requires the following technical qualifications:

• Experience with on premise Data Warehouse reusable framework design and implementation

• Good understanding of cloud design considerations for data storage and processing

• Experience with data modeling

• Experience with building data pipelines and ETL processes

• Extensive development experience with technologies including: SSIS, SQL Server, REST API, OLAP cubes, BI Analytic tools

• Extensive analytic development experience with PowerBI and preferably Microsoft Power Platform.

• Advanced Power BI Service configurations such as Power BI DataFlow and DataMart

• Experience in PowerBI report development, reports automation with data source refresh configurations

• Experience with analyzing data source systems to identify data transformation needs

• Thorough knowledge of software development methods, practices and procedures

• Ability to prepare technical design and write technical specifications

In addition, this position requires the ability to:

• Establish and maintain effective working relationships with a variety of internal contacts.

• Provide advice and assistance on matters related to the work.

• Communicate effectively orally and in writing.

• Perform assigned duties with minimal supervision, although direction will be given.

• Maintain confidentiality.