Database Migration Analyst/Programmer

Katalyst Data Management; Calgary; On-site; CAD 90,000 - 110,000; Full time

Job summary

An established industry player seeks a Database Migration Analyst/Programmer to drive data migration projects using advanced SQL and Postgres skills. In this dynamic role, you'll analyze and profile source data, design robust migration processes, and ensure data integrity throughout the transition to the iGlass database model. The position offers a collaborative environment where your analytical and problem-solving skills will shine, making a significant impact in the Oil & Gas sector. If you are passionate about data quality and eager to contribute to innovative projects, this opportunity is perfect for you.

Qualifications

• 5+ years of experience in data model analysis and migration execution.
• Bachelor's degree in computer science or equivalent experience required.

Responsibilities

• Design and implement data migration processes using PL/pgSQL and SQL.
• Collaborate with teams to develop comprehensive data migration plans.
• Conduct analysis and profiling of source data from various systems.

Skills

Postgres PL/pgSQL

SQL

Data Modeling Principles

Analytical Skills

Communication Skills

Data Quality Commitment

Database Utilities

Team Collaboration

Attention to Detail

Data Change Control

Education

Bachelor's Degree in Computer Science

Tools

Postgres

Oracle

Job description

Salary Range: CA$90,000.00 To CA$110,000.00 Annually

Key Responsibilities and Accountabilities

The Database Migration Analyst/Programmer uses their knowledge of Data Model theory and practice, Postgres PL/pgSQL (or Oracle PL/SQL) and SQL to design, execute and confirm the migration from various origin databases into the Katalyst iGlass database (PPDM-based) data model. The Database Migration Analyst/Programmer works under the technical supervision of the Chief Database Architect on operational projects directed by operational Project and/or Account Managers to ensure that client origin data is accurately reflected in iGlass at the end of the migration process. Great organisational ability, a high level of attention to detail, the ability to multi-task, a natural curiosity and a desire to learn are also required for this role.

Key Responsibilities:

1. Conduct in-depth analysis and profiling of source data from various systems (e.g., ProSource Seabed, Trango, Petrobank, eSearch, custom databases).
2. Collaborate with Account/Project Management teams to develop comprehensive data migration plans, including mapping source data to the iGlass data model.
3. Design, code/program, and implement robust data model migration processes using PL/pgSQL, SQL, and industry-standard ETL best practices.
4. Create and maintain necessary database objects (tables, views, etc.) within the Postgres environment.
5. Develop in-depth expertise in the iGlass data model and its intricacies.
6. Perform thorough peer reviews and quality control on the work of colleagues.
7. Contribute to research and development projects as needed.

Skills Required:

1. Strong proficiency in Postgres PL/pgSQL (Oracle PL/SQL considered equivalent).
2. Solid understanding of data modelling principles and best practices.
3. Expert-level knowledge of SQL (DML & DDL).
4. Excellent analytical and problem-solving skills.
5. Strong communication and interpersonal skills.
6. Experience with database utilities (e.g., Postgres copy, Oracle SQLLoader/import).
7. Familiarity with industry-standard data models for the Oil & Gas domain, such as PPDM.
8. Attention to detail and a commitment to data quality.
9. Ability to work independently and as part of a team.
10. Experience with database change control and promotion processes.

Required Education and Experience

1. A bachelor’s degree in computer science or equivalent experience.
2. 5+ years of experience in data model analysis, data profiling, data mapping, and data model migration execution using Postgres PL/pgSQL (or Oracle PL/SQL) and SQL.
3. Knowledge of PPDM data model highly valued.

Occasional regional and international travel may be required.