Report Developer/Analyst Details
This report developer/analyst role will balance time between our (1) back-office system modernization initiative, developing new operational reports in SSRS/SQL, (2) maintaining and enhancing our existing operational reports in SSRS/SQL, and (3) developing analytics and dashboard work in PowerBI as assigned. The primary component of this role is report development in SSRS/SQL.
Report Developer/Analyst Responsibilities
Design, develop, and implement business intelligence solutions, including reports, dashboards, and data models using SQL, SSIS, Power BI, 3rd normal form, Kimball, and Data Vault.
Participate in report development tasks liaising between business units, project manager, development team, DBA, and report architect.
Ensure that report development tasks meet business requirements and goals, fulfill end-user requirements, and identify and resolve systems issues.
Ensure that developed reports are aligned with project and AMA (Alberta Medical Association) standards and best practices.
Develop unit tests for reports after development to ensure like for like from old to new systems.
Participate in the testing phase of the project to identify and remedy potential problem areas.
Ensure compliance with data governance policies and security standards.
Develop and post documentation for reports developed, procedures, and services that relate to your work.
Provide regular updates to the manager and the team on progress, emerging issues, and new opportunities. Attend daily BI standup.
Ability to work on multiple projects at the same time. While being able to pivot from project to operational on short notice.
Understanding of how Oracle database queries work, as well as Microsoft CRM data structure, is a plus.
Report Developer/Analyst Mandatory Skills
5+ years experience with SQL
5+ years experience with SSRS
5+ years experience with 3rd normal form database methodology
3+ years experience with Kimball data warehouse methodology
2+ years experience with Power BI
Understanding of SSIS, Data Vault, Oracle, Microsoft CRM.
Report Developer/Analyst Location
Edmonton or Calgary
Report Developer/Analyst Start Date
ASAP
Your company, your values, your career! Coast Hotels is a dynamic and growing brand. Our culture is rooted in our...
Apply For This JobAt Tile Town, our mission is to improve lifestyles. For 50 years we’ve been a 100% Canadian-owned and operated company...
Apply For This JobThis opening for a remote Customer Support Coordinator is a full-time Monday- Friday opportunity at Advisor Websites, a software company...
Apply For This JobLocation: This position can be located in any of our corporate offices in Canada. Our organization: Founded in 2017, Wellington-Altus...
Apply For This JobNew Horizon Co-op is hiring a Part-Time Cashier at our Downtown Food Store in Grande Prairie, Alberta. Who we are:...
Apply For This JobSCHEDULED WEEKLY HOURS: Aurora Branch – Tuesdays and Thursdays (9:15am to 4:15pm) Ability to cover Monday through Friday for sick...
Apply For This Job