What you will be doing:
The Business Intelligence Analyst will work in collaboration with our Business Strategy and Improvement Team and will focus on:
Translating business requirements into technical specifications
Data profiling
Source data analysis with SQL or applicable tools
Business Analysis
Designing and developing the data analytics (data warehouse, data lake ODS, data modelling, Power BI security, Power BI workspace) reusable framework
Designing data models based on technical specifications
Exploring advanced Power BI features for analytics, including customized solutions such as Dataflows and Datamarts
Designing and building data pipelines and ETL packages including:
M Query
Dax Language
Power Query
Dashboards and reports with Power BI Desktop
Troubleshoot day-to-day data warehouse issues
Design, build, and deploy BI solutions (e.g., reporting tools, dashboards)
Maintain and improve existing BI systems
What you must have:
Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle)
Experience with on-premise data warehouse reusable framework design and implementation
Experience with data modelling, analysis, and visualization
Work with relational and non-relational databases to extract, transform, and load (ETL) data
Experience with building data pipelines and ETL processes
Extensive development experience with technologies including SQL Server, REST APIs, OLAP cubes, and BI analytics tools
Extensive analytic development experience with Power BI and preferably Microsoft Power Platform
Advanced Power BI Service configuration experience, including Power BI Dataflows and Datamarts
Experience in Power BI 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
Experience using Azure Dev Ops to manage projects is preferred
Experience with programming languages such as Python or R is a plus
Experience with Microsoft Fabric for data integration, data warehousing, analytics, semantic modeling, and enterprise reporting solutions is considered a strong asset
Salary/Rate: $85.00/ hour
Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search: