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