Sr. Data Warehouse Reporting Analyst

Mindlance; Canada; Remote; CAD 60,000 - 100,000; Full time

Job summary

An innovative organization is seeking a motivated Data Warehouse Reporting Analyst Sr. to enhance their reporting capabilities. This role involves collaborating with IT and Data Warehouse teams to design, build, and administer reporting solutions. You will lead the development of business requirements for reports, create ad-hoc reports, and ensure security compliance. Ideal candidates will have extensive experience with SQL Server and BI tools like Power BI and Tableau. Join a dynamic team dedicated to delivering high-quality performance and customer service in a fast-paced environment.

Qualifications

• Several years of experience with relational databases and reporting development.
• Experience in BI data warehousing reporting analysis and design.

Responsibilities

• Designs, develops, tests, and implements reports and dashboards.
• Supports user training and documentation for reporting tools.

Skills

SQL Server Reporting Services (SSRS)

Power BI

Tableau

Microsoft SQL Server

ETL

Business Intelligence (BI)

Education

High School Diploma

Bachelor's Degree in Information Technology

Tools

Microsoft Office Suite

MicroStrategy

Business Objects

Cognos

Job description

The client is seeking a highly motivated and experienced TEMPORARY - Data Warehouse Reporting Analyst Sr (Power BI Developer) to join our team. The Data Warehouse Reporting Analyst Sr. collaborates with the Information Technology Services (ITS) and Data Warehouse (DW) teams to develop and support organization-wide reporting. The incumbent participates in gathering and documenting report requirements and is responsible for designing, building, and administering reporting solutions for requesting departments. Assistance will be provided to departmental Business / Data Analysts in developing reports using the available business intelligence (BI) tools. The incumbent will develop ad-hoc reports for business users as applicable and participate in the design and development of the reporting infrastructure using Structured Query Language (SQL) Server technologies and BI reporting tools. The incumbent is responsible for administering report security and deployment within the client's ITS and data security policies as well as future environment upgrades.

Position Information :

Work Schedule : Monday to Friday ( : to : with one hour lunch)

Duties & Responsibilities :

1. Participates in a mission-driven culture of high-quality performance, with a member focus on customer service, consistency, dignity, and accountability.
2. Assists the team in carrying out department responsibilities and collaborates with others to support short- and long-term goals / priorities for the department.
3. Leads the development of business and functional requirements for reports.
4. Designs, develops, tests, and implements reports / dashboards and extraction, transformation, and loading (ETL) to fulfill business requirements as needed.
5. Serves as a subject matter expert across the organization and assists users with reporting (including ad-hoc reporting) and analysis activities and tools.
6. Supports user training, testing, documentation, and the roll-out of reports and end-user reporting tools.
7. Administers BI security, deployment, upgrades, and maintenance.
8. Maintains effective working relationships with the DW team, other Information Services teams, and the other business departments within the client.
9. Maintains knowledge of business processes and application design and understands cross-functional business relationships and their use of information.

Completes other projects and duties as assigned.

Minimum Qualifications :

• High School diploma or equivalent required.
• Several years of experience with general relational databases and reporting development required.
• Several years of experience with BI data warehousing reporting analysis, design, testing, and administration required.
• Several years of experience developing Microsoft SQL Server stored procedures and using reporting tools such as SQL Server Reporting Services (SSRS), Tableau, Power BI, MicroStrategy, Business Objects, and/or Cognos for developing reports required.
• An equivalent combination of education and experience sufficient to successfully perform the essential duties of the position such as those listed above may also be qualifying.

Preferred Qualifications :

• Bachelor’s degree in information technology or related field.
• One year of experience in developing reports in a healthcare-related business, preferably a health plan.
• Experience with SSRS, Tableau, and/or Power BI strongly preferred.

Required Licensure / Certifications : N / A

Knowledge & Abilities :

• Develop rapport and establish and maintain effective working relationships with the client's leadership and staff and external contacts at all levels and with diverse backgrounds.
• Work independently and exercise sound judgment.
• Communicate clearly and concisely, both orally and in writing.
• Work a flexible schedule; available to participate in evening and weekend events.
• Organize, be analytical, problem-solve, and possess project management skills.
• Work in a fast-paced environment and in an efficient manner.
• Manage multiple projects and identify opportunities for internal and external collaboration.
• Motivate and lead multi-program teams and external committees / coalitions.
• Utilize computer and appropriate software (, Microsoft Office : Word, Outlook, Excel, PowerPoint) and job-specific applications / systems to produce correspondence, charts, spreadsheets, and / or other information applicable to the position assignment.