About the role

Intermediate ETL Developer migrating customer data into Pandell-ESG’s energy software. Writing conversion scripts, adapting ETL frameworks, and leading technical implementation projects.

Responsibilities

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.

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.

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