Senior Data Warehousing & BI Engineer

Analyst Technical Solutions; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Analyst Technical Solutions seeks a skilled data warehousing/BI professional to design, develop and test ETL processes, reports and dashboards for EOIS data. The role emphasizes Oracle SQL/PLSQL, Informatica mappings, Crystal Reports and BOE reporting within an SDLC/Agile environment.

The successful candidate will craft data warehouse solutions, contribute to dimensional modeling and deploy BI systems in a fast-paced IT setting, collaborating closely with IT teams and management.

Qualifications

• 5+ years of experience in data warehousing and BI environments.
• 5+ years experience in Crystal Reports, Power BI and BOE reports.
• 5+ years experience in Oracle SQL and PL/SQL.
• 5+ years experience in Informatica.
• Complete knowledge of SDLC methodologies, e.g. Agile development.
• Experience in RDBMS design concepts.
• Experience with Data Warehouse design, reporting and ETL concepts.
• Experience with Data Warehouse architecture, design, dimensional modeling, development and deployment of BI systems.

Responsibilities

• Perform analysis, design, developing, unit testing, defect fixing and other necessary tasks in a data warehousing and BI environment in Oracle PL/SQL
• Design, develop and test Informatica mappings
• Develop ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Data marts
• Develop and maintain BOE reports
• Communicate your progress clearly and timely to the management team
• Must have skills in Crystal reports, Informatica, Power BI and BOE reporting

Skills

Data warehousing

Crystal Reports

Power BI

BOE reports

Oracle SQL/PLSQL

Informatica

SDLC / Agile

Tools

Crystal Reports

Power BI

BOE (BusinessObjects) reports

Informatica

Oracle SQL/PLSQL

Job description

Analyst Technical Solutions seeks a skilled data warehousing/BI professional to design, develop and test ETL processes, reports and dashboards for EOIS data. The role emphasizes Oracle SQL/PLSQL, Informatica mappings, Crystal Reports and BOE reporting within an SDLC/Agile environment.

The successful candidate will craft data warehouse solutions, contribute to dimensional modeling and deploy BI systems in a fast-paced IT setting, collaborating closely with IT teams and management.