ARC Business Solutions Inc. is a customer-oriented information technology solution provider with proven abilities to incorporate strategy, creativity and technical aspects into business solutions. Service delivery is focused in four main technology solution verticals: Systems Delivery, Enterprise Information Management, Training and Managed Services; with industry expertise in Energy, Utilities, Government, Financial Services and the Public Sector.
ARC Business Solutions Inc. is currently seeking individuals with experience as a BI/Report Analyst for opportunities in Edmonton, AB. This is for a one year contract starting October 1 with a possible extension.
ROLE: BI/Report Analyst
Technical Knowledge
-
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.
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 clients 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.
We offer a competitive salary, profit sharing, share options and a comprehensive benefits package. These positions can be filled by full time ARC employees or contractors.
We thank all applicants for their interest; however only candidates considered for interviews will be contacted. We will be conducting interviews immediately. TO BE CONSIDERED - Please forward your resume clearly displaying reference number GK:BI in the subject line to [email protected]. For more information on ARC, please visit our website at www.arcbus.com.
xfXI2yI7Px
