Detailer Evening Shift

The Client is looking for an Analytics Specialist 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.

Knowledge & Skills

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
  
  

Requirements

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