PowerBI and Oracle PL/SQL/ETL Developer

Jobgether; Ottawa; On-site; CAD 90,000 - 130,000; Full time

Job summary

Jobgether in Canada seeks a senior Power BI/Oracle PL/SQL/ETL Developer to lead data migration and archival efforts in Ottawa. You will design, build, and optimize BI reports and ETL pipelines, translating complex requirements into robust solutions while ensuring data quality and governance.

Collaborating with business and technical stakeholders, you will own end-to-end data modernization initiatives, deliver scalable reporting, and uphold performance and security standards in a long-term

Qualifications

• Experience with data migration projects and archival initiatives.
• Strong understanding of BI reporting architectures and data governance.
• Ability to translate business requirements into technical specifications.

Responsibilities

• Gather, validate, and translate business requirements into specifications for migration and reporting.
• Analyze source data and design data models and mappings for legacy data migration.
• Develop and optimize Oracle PL/SQL and ETL processes for archival solutions.

Skills

Data analysis

Data modeling

Stakeholder communication

Tools

Power BI

Oracle PL/SQL

ETL

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a PowerBI and Oracle PL/SQL/ETL Developer based in Canada.

This is a senior data and software development opportunity supporting a major data modernization and archival initiative in Ottawa, Ontario.
The role focuses on migrating historical financial data from a legacy mainframe environment into a secure, scalable, and user-friendly archival solution.
You will combine advanced Power BI expertise with Oracle PL/SQL and ETL development to build reliable data and reporting solutions.
The position spans data analysis, modelling, migration, validation, business intelligence, integration, testing, and deployment.
You will work closely with business and technical stakeholders to translate requirements into effective technical solutions.
Strong attention to data quality, governance, performance, reporting accuracy, and long-term data retention will be essential.
This opportunity is well suited to an experienced developer who can take ownership of complex data initiatives in a collaborative environment.

Accountabilities

• Gather, validate, and translate business and technical requirements into clear functional and technical specifications, participating in stakeholder workshops to understand objectives, KPIs, reporting needs, and success criteria.
• Analyze source data and develop data models, mappings, business rules, and data structures that support migration, archiving, reporting, and integration requirements.
• Design, develop, maintain, and optimize Oracle PL/SQL and ETL processes supporting historical financial data migration and secure archival solutions.