Power BI Analyst

Our client is seeking a contract Sr. Power BI Analyst to fulfill new development, enhancements, maintenance and support for all data warehouse, data marts, reporting, data visualizations and dashboards for our client, including documentation of all requirements and development details aligned to audit expectations.

Working on the Information Management team, the Analyst will utilize data from source systems to populate data assets and build attractive, intuitive, and insightful information products. The candidate will ideally exhibit a combination of business acumen and data analysis skills while also being creative, and adept in visual design and development.

• Developing highly complex, mission critical reports, projects, and applications.
• Delivering professional quality of data analysis and ETL processes to reduce the high consequence of error.
• Documentation for all processes, internal and external audit requirements.
• Building Extract, Transform, Load processes using SAS Data Integrator based on a logical model or design.
• Performing peer code reviews to ensure adherence to design, development, and maintenance standards.
• Contributing to design and development best practices and guidelines.
• Monitoring and remediating all issues with the data warehouse/data marts and reports.
• Providing knowledge transfer to the other members of the development team.
• Performing and supporting daily tasks such as job scheduling, monitoring, troubleshooting and remediation.
• Support testing of solutions in all applicable environments.
• Support stakeholders in the use of information products.
• Assist with training materials, and demonstrations.
• Ensure issues are identified, tracked, reported on, and resolved in a timely manner.
• Participate in post-project implementation reviews or ‘lessons learned’, incorporating these lessons into appropriate process documentation, standards templates, and checklists.

• Minimum of 10 years’ experience in data modeling, data management, metadata management, enterprise reporting, data visualizations, dashboards
• Experience with both Kimball and Inmon methodologies
• Demonstrated ability to navigate between big-picture and implementation details
• Experience in database and/or reporting environments incorporating Microsoft SQL Server technology.
• Strong analytical skills and SQL expertise. Well versed in database technology and data warehouse design standards
• Experience with ETL processes/tools, SAS products considered a benefit.
• Working knowledge of TFS or equivalent project management, development management tools.
• Experience in visual design and development utilizing Microsoft Power BI, Tableau, or similar software.
• Demonstrated ability to present data in an intuitive way and familiarity with data visualization best-practices.
• Understanding of OLAP/multi-dimensional data organization techniques and one or more related languages (e.g. DAX; VizQL).
• Education/experience in Advanced Mathematics and/or Statistics is considered an asset
• Education/experience in Machine Learning and/or Artificial Intelligence is considered an asset
• Technical writing ability 
• Excellent troubleshooting and problem-solving skills.
• Ability to work in a collaborative team environment.
• Ability to work with minimal supervision.
• Experience working on complex assignments requiring continuous periods of concentration, with periodic interruption.
• Strong organizational and analytical skills.
• Strong interpersonal and communication (written & verbal) skills, including technical writing ability.