Senior Data Analyst

Papigen

Toronto

On-site

CAD 90,000 - 130,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Papigen seeks a senior Data Analyst to enhance our financial sustainability reporting system and our operational data store. You will leverage Oracle PL/SQL to optimize data flows and ensure data accuracy for business users.

In this role you will collaborate with IT and finance teams, guide offshore developers, build and maintain data models with ERwin, and translate requirements into robust, scalable solutions. Excellent communication is essential.

Qualifications

  • Master's or bachelor's degree in a technical field with 7+ or 9+ years of relevant experience.
  • 7+ years Oracle databases experience with PL/SQL and accounting data understanding.
  • Proven data modeling experience and ERwin proficiency.
  • Excellent verbal and written communication across technical and non-technical stakeholders.
  • Strong problem-solving and task-prioritization skills.

Responsibilities

  • Understand requirements and design database structures; develop stored procedures and scripts.
  • Guide offshore resources to translate requirements into solutions.
  • Perform data analysis and support analytics/report development with proper data prep.
  • Optimize code performance and troubleshoot issues promptly.
  • Coordinate user acceptance testing of reports and data-driven solutions.
  • Develop SME knowledge and respond to ad hoc business requests.

Skills

Oracle PL/SQL
Data modeling
Communication
Problem solving

Education

Master's degree in IT / Computer Science / Mathematics / MIS
Bachelor's degree in IT / CS / Math / MIS

Tools

ERwin

Job description

Role Overview

We are looking for a senior Data Analyst with strong Oracle PL/SQL skills to support enhancements to a financial sustainability reporting system and an operational data store. The role requires the ability to understand the functional meaning of the data and to work effectively with business users and other technical teams.

Scope of Work
  • Understand requirements and design database structures; develop database components including stored procedures, functions, packages, and scripts.
  • Interact with other technical team members, including guiding offshore development resources to translate requirements into solutions.
  • Perform data analysis and inform analytics and report development with appropriate data layer preparation.
  • Modify code to optimize for performance and troubleshoot issues in a timely manner.
  • Coordinate user acceptance testing of reports and data-driven solutions.
  • Build application knowledge and serve as the SME to address ad hoc requests from business users.
Skills & Experience Required
  • Master's degree in IT, Computer Science, Mathematics, or MIS with 7+ years of relevant experience, or Bachelor's degree with 9+ years of relevant experience.
  • 7+ years of experience working on Oracle databases with strong PL/SQL skills and an understanding of accounting data.
  • Proven expertise creating data models and using the ERwin tool.
  • Excellent communication skills, with experience communicating effectively with technical and non-technical audiences and coordinating with team members and business users.
  • Demonstrated problem-solving and task prioritization skills to support successful project completion.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

JAE Consulting Inc. • Toronto

On-site
CAD 70,000 - 90,000
Data Reporting Analyst
Data Reporting Analyst

KTek Resourcing • Brampton

On-site
CAD 65,000 - 95,000
Senior Oracle PL/SQL Developer – Healthcare Data & Integration
Senior Oracle PL/SQL Developer – Healthcare Data & Integration

ThoughtStorm • Toronto

On-site
CAD 90,000 - 130,000
Senior Data Analyst / BI Analyst
Senior Data Analyst / BI Analyst

High Tech Genesis • Ottawa

On-site
CAD 90,000 - 120,000
Senior Oracle OBIEE Developer - OAS, OAC integration exp, RPD, PL/SQL, Banking
Senior Oracle OBIEE Developer - OAS, OAC integration exp, RPD, PL/SQL, Banking

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision! • Toronto

On-site
CAD 80,000 - 110,000
Senior Data Warehousing & BI Engineer
Senior Data Warehousing & BI Engineer

Analyst Technical Solutions • Toronto

On-site
CAD 90,000 - 120,000
Senior Oracle Application Database Administrator
Senior Oracle Application Database Administrator

Epsilon Solutions Ltd. • Toronto

On-site
CAD 120,000 - 160,000
Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
Senior Business Analyst
Senior Business Analyst

Charter • Lawnhill

On-site
CAD 90,000 - 130,000
Senior Database Administrator (Oracle Application DBA / Cloud)
Senior Database Administrator (Oracle Application DBA / Cloud)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 120,000 - 180,000