ETL Developer

Pandell

. Plan data migrations, turning project requirements into a technical approach.

Posted 10/28/2026full-timeCalgary • CanadaMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL, T-SQL, PL/SQL, and ETL processes for data migration and conversion, with a strong ability to lead technical projects and mentor developers. Proficient in maintaining technical documentation and ensuring code quality through reviews and testing.

Highest-signal resume keywords

SQL Database ManagementETL ProcessesData MigrationTechnical LeadershipCode Review

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLT-SQLPL/SQLC#PowerShellData Conversion ScriptsRelational DatabasesNon-Relational DatabasesTechnical DocumentationComplex Queries

Soft Skills

Clear CommunicationAttention to DetailCuriosityTeam CollaborationGood Judgement

Tools & Technologies

SQL Server Management Studio (SSMS)Visual StudioMicrosoft AccessExcelGitHubJiraTeamCity

Industry Keywords

Energy IndustryLand AdministrationLand Management

Tech Stack

Tools & technologies

ETLOracleSDLCSQL

About the role

Key responsibilities & impact

Plan data migrations, turning project requirements into a technical approach.
Write and run conversion scripts to move data between systems.
Develop tools and modify conversion frameworks to meet project needs.
Learn customers’ data and business processes and work through unfamiliar data models.
Take the technical lead on small to medium-sized projects.
Help plan work, estimate effort, and keep technical tasks on track.
Review code and test other developers’ work against project requirements and team standards.
Troubleshoot issues during development, configuration, and performance tuning.
Maintain clear and accurate technical documentation.
Discuss technical questions with colleagues.
Mentor other developers through guidance and feedback.
Help customers implement Pandell-ESG software across its product groups.

Requirements

What you’ll need

5+ years of hands-on experience working with SQL, SQL Server Management Studio (SSMS), and Oracle databases.
Experience writing complex queries and data conversion scripts, with a solid understanding of database tables and how they relate to one another.
Knowledge of T-SQL, PL/SQL, C#, and PowerShell for ETL scripting and tool development.
Experience with ETL processes, data migrations, and conversion frameworks, including writing and running scripts of moderate complexity.
Experience building tools and making changes to existing frameworks.
An understanding of relational and non-relational databases.
Familiarity with the software development life cycle and how it applies to data conversion, configuration, and deployment.
The ability to guide technical work on a project and review code against requirements and quality standards.
Good judgement when planning your work, estimating how long tasks will take, and managing competing deadlines.
Clear communication, attention to detail, and the ability to work both independently and as part of a team.
Curiosity about unfamiliar systems and an interest in continuing to learn.
Post-secondary education in Computer Science, Information Systems, or a related technical field.
Experience with Visual Studio, Microsoft Access, Excel, GitHub, Jira, or TeamCity.
Knowledge of the energy industry, particularly land administration or land management, is a bonus.
GitHub profile or shareable code samples are welcomed.

Benefits

Comp & perks

Work-from-home or office flexibility - choose where you work best!
Flexible hours to support work-life balance
Competitive benefits package, including 100% dental reimbursement
Retirement Savings Plan with company matching
Training budget and professional development opportunities
Fully stocked kitchen at the office with healthy options, snacks, and plenty of coffee
A fun and engaging culture with virtual and in-person events, learning opportunities, and a games room and lounge
Wellness budget to support your version of wellbeing
Training opportunities
Collaboration with an incredible team