Senior Power BI Developer to support the design, development, deployment, of Microsoft Power BI reports and applications related to the end-to-end design, development, implementation and documentation of enterprise dash-boarding, reporting BI.

Start Date: ASAP

End date: March 28, 2024

MUST HAVE

·       4+ years proven hands-on experience developing and deploying Microsoft Power BI reports and applications in an on-premises and cloud environment using Power BI Desktop, and Azure Synapse Analytics

·       4+ years’ proven experience developing enterprise Business Intelligence solutions with multiple implementations including automated/scheduled refresh of products to end clients.

·       4+ years’ proven experience in data transformation, data modeling, database design, querying/data extraction, development, and implementation in Power BI products from relational databases in an on-premises and cloud environment.

·       Hands on experience with SQL, DAX, Power Query M, SAS, R, Pyspark, and Python within automated data pipelines

·       Proven experience creating documentation including, but not limited to requirements, technical specifications, lineage and source to target mappings as well as applicable training material and update instructions

NICE TO HAVE

·       Proven communication (verbal, written, and presentation) skills with ability to convey technology solutions to all stakeholders

·       Proven experience working closely in a team product development environment

·       Proven interpersonal skills with ability to convey technology solutions to all stakeholders

·       Must be a self-directed and effective in working independently, yet equally comfortable contributing in a team environment. In addition be able to manage time and complete multiple tasks while continually meeting deadlines.

·       Successful completion of Microsoft DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI is considered an asset

·       Power BI Data Analyst Associate Certification also considered an asset

Resource Responsibilities

Report Development Support

·       Assist in the identification and documentation client requirements for the purpose of developing a suitable solution to meet the business needs

·       Support the design and build of specialized and customized Power BI reports, applications, and data sets for reporting and analytical purpose

·       Extract data using SQL and SAS

·       Transform/Structure report data and create report measures and metrics using Power Query M, and DAX, SAS, R, Pyspark, and/or Python

·       Test and validate reports and applications including preparation and documentation of test criteria and reviewing test results

·       Support quality management and assurance on data, reports, an applications to ensure security and integrity of data

·       Assist in the development of end-user training material and update instructions

·       Liaise and coordinate with internal and external consultants in detailed systems deliverables and technical problem resolution

·       Assist in developing and executing SQL (Structured Query Language) scripts and perform data analysis

·       Provide cross training on BI product solutions

·       Participate as a team member in the execution of project plans providing technical expertise and advice re: architecture, development tools, work effort estimates

Business Requirement Specialist

·       Translate business requirements into specifications, including translating design into ETL design document and report design specifications and documentation

·       Document data and measure source to target mapping, lineage, business and technical and business definitions as well as other report meta data into enterprise business data dictionary

Data Transformation

·       Design, direct and implement ETL processes, including data capture, data quality, testing, and validation methods

·       Ensure successful data model and database implementation

ETL Development

·       Support the development, deployment, configuration and validation of data models for BI products

·       Assist in performance tuning complex large data loads and long running jobs to optimize run time, resource utilization and increase maintainability

·       Troubleshoot and resolution of product defects

·       Assist with the technical walkthroughs of BI products for design improvements and development peer reviews

·       Validate the BI product data models and source data after any system and code changes

·      Participate in cross training and knowledge transfer sessions with other teams