Intermediate ETL Developer

Pandell - An ESG Company

United States

Hybrid

USD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

WFH flexibility
Flexible hours
Dental reimbursement
Retirement match
Training budget
Office snacks & coffee
Culture events

Job summary

Pandell-ESG is seeking an Intermediate ETL Developer to join the Project Services team. You’ll analyze customer data, plan conversions, and write scripts to move data into our software. You’ll learn data models, adapt tools, and troubleshoot to ensure successful migrations.

The role offers hands-on technical work and opportunities to lead small to mid-size projects. You’ll collaborate with a team that understands software, data processes, and business requirements, contributing to mentoring and

Qualifications

  • 5+ years of hands-on experience with SQL, SSMS, and Oracle databases.
  • Experience writing complex queries and data conversion scripts.

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.
  • Understand customers’ data and business processes, handling unfamiliar data models.
  • Take technical lead on small to medium projects, plan work and estimate effort.
  • Review code and test others’ work to ensure requirements and standards.
  • Troubleshoot issues during development, configuration, and performance tuning.
  • Maintain clear documentation and discuss technical questions with teammates.
  • Mentor and provide feedback to help others build skills.

Skills

SQL & SSMS
Oracle
T-SQL
PL/SQL
C#
PowerShell
ETL scripting
Data migrations
Code review

Education

Post-secondary education in Computer Science, Information Systems, or a related technical field

Tools

Visual Studio
Microsoft Access
Excel
GitHub
Jira
TeamCity

Job description

Enjoy figuring out how the data fits together? An unfamiliar database, a tricky conversion, a migration ready to run. If that sounds like your kind of work, we’d like to hear from you! We’re looking for an Intermediate ETL Developer to join Pandell-ESG’s Project Services team. You’ll help customers move their data into our software and work alongside a strong team that’s ready to roll up their sleeves and help.

About the role

You’ll work through the details of each migration: understanding the customer’s data, planning how it needs to be converted, and writing the scripts to make it happen. You’ll learn different data models, adapt our conversion tools, and troubleshoot along the way. You’ll also have opportunities to take the technical lead on small to medium-sized projects and help other team members build their skills and confidence. It’s a role for someone who enjoys hands‑on technical work and wants to take on more responsibility with a team behind them.

Your team

Our Project Services team helps customers implement software across Pandell’s suite of more than 12 product groups. You’ll work with colleagues who understand the software and the business processes behind it, sharing ideas, and working through challenges together.

About Us

ESG, along with its subsidiary Pandell, is a global leader in energy software, providing Software-as-a-Service (SaaS) solutions that support companies across utilities, renewables, retail energy, and oil and gas. Across North America and the UK, our combined platforms help teams manage key parts of their business, including billing, asset management, regulatory requirements, and geospatial data. These tools bring together the information and workflows teams rely on every day, making it easier to run operations and stay organized. Through cloud-based technology and data-driven insights, we help energy companies navigate complex markets and continue progressing toward Net-Zero goals.

Life at Pandell‑ESG

We care about doing good work and being good people to work with. That means making room for questions, listening to different perspectives, and helping each other when the work gets complicated. We want people to feel welcome, respected, and comfortable being themselves. You’ll have the trust, tools, and flexibility to do your work, along with support from your teammates.

Requirements

What you’ll do:

  • Plan data migrations, turning project requirements into a technical approach.
  • Write and run conversion scripts to move data between systems.
  • Develop tools and make changes to our conversion frameworks to meet project needs.
  • Get to know customers’ data and business processes, working through unfamiliar data models with support from senior teammates.
  • Take the technical lead on small to medium-sized projects, helping plan the work, estimate effort, and keep technical tasks on track.
  • Review code and test other developers’ work, with guidance when needed, to check that it meets project requirements and team standards.
  • Troubleshoot issues during development, configuration, and performance tuning.
  • Keep technical documentation clear and accurate, and talk through technical questions with colleagues.
  • Help other developers build their skills and confidence through mentoring and feedback.

What you’ll bring:

  • 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.
Bonus points for
  • Experience with Visual Studio, Microsoft Access, Excel, GitHub, Jira, or TeamCity.
  • Knowledge of the energy industry, particularly land administration or land management.
  • We’d love to see your work.
Benefits

What’s In It for You?

At Pandell-ESG, we believe in creating a workplace where you can do your best work while enjoying meaningful projects and a strong sense of belonging. Here are just a few things we offer:

  • 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
  • A wellness budget to support your version of wellbeing

Join us and be part of something EPIC.

If you’re excited about helping customers succeed, bringing software to life through training, and collaborating with an incredible team, we’d love to hear from you!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote ETL Developer: Lead Data Migrations & Tools
Remote ETL Developer: Lead Data Migrations & Tools

Pandell - An ESG Company • United States

Hybrid
USD 90,000 - 120,000
WFH flexibility
Flexible hours
Dental reimbursement
+4
Staff Data Engineer, Applied Data Science III
Staff Data Engineer, Applied Data Science III

Electric Power Engineers, LLC • Austin (TX)

Remote
USD 130,000 - 190,000
Health, dental, and vision coverage
Generous PTO and paid holidays
MyShare Employee Ownership Program
+2
Data Engineer: Build Scalable Pipelines & Trusted Data
Data Engineer: Build Scalable Pipelines & Trusted Data

Sakata Ornamentals • Burlington (WA)

On-site
USD 110,000 - 125,000
Health insurance
401(k) Program + Company Match
Holiday Bonus
+2
Software Support Engineer
Software Support Engineer

Preferred Data Corporation • High Point (NC)

On-site
USD 70,000 - 90,000
Health, dental, and vision insurance
Unlimited paid time off
Training and professional development opportunities
SQL Developer / Data Warehouse ETL Developer
SQL Developer / Data Warehouse ETL Developer

South Geeks • United States

Remote
USD 90,000 - 140,000
100% remote work
Payment in USD
PTO
+4
Data Engineering Solution Lead
Data Engineering Solution Lead

Jobgether • United States

Remote
USD 105,000 - 155,000
Remote work
Medical, dental, and vision insurance
401(k) retirement plan with company •?
+4
Lead Engineer Data
Lead Engineer Data

Empower Retirement, LLC • Kansas

Hybrid
USD 125,000 - 182,000
Medical, dental, vision & life
401(k) with company match
Tuition reimbursement
+5
SQL Data Engineer
SQL Data Engineer

Peregrine Advisors • Washington

Hybrid
USD 120,000 - 140,000
Medical, dental, vision insurance (em折
Employer-paid life insurance
Disability insurance
+3
Lead Engineer Data
Lead Engineer Data

Empower • United States

Hybrid
USD 125,000 - 182,000
Medical insurance
401(k) plan
Tuition reimbursement
+2
Data Engineer
Data Engineer

Sakata Ornamentals • Burlington (WA)

On-site
USD 110,000 - 125,000
Health insurance
401(k) Program + Company Match
Holiday Bonus
+2