ETRM Data Engineer

• Architect and maintain high-throughput ETL data pipelines integrating ETRM platforms with enterprise applications.
• Develop custom Python scripts to automate complex data transformations, validation rules, and API connections.
• Optimize enterprise SQL Server stored procedures, indexing schemes, and high-volume database queries.
• Build and manage production-grade data integration packages utilizing SQL Server Integration Services (SSIS).
• Extract, transform, and integrate energy trading datasets across heterogeneous Oracle and SQL Server environments.
• Implement automated data quality validation frameworks and dimensional models for the enterprise data warehouse.
• Deliver operational trade reporting solutions and interactive analytical dashboards using SSRS and Power BI.

• 6 or more years of experience in enterprise data engineering and ETL pipeline development.
• Proficiency in Energy Trading and Risk Management (ETRM) platforms and commodity trade lifecycle data.
• Experience with Microsoft SQL Server database design, advanced stored procedures, and SSIS packages.
• Experience in Python scripting for data transformation utilizing Pandas, NumPy, and REST APIs.
• Experience with Oracle database querying, cross-platform integration, and query performance optimization.
• Experience in enterprise data warehousing, dimensional modeling, SSRS reporting, and Power BI dashboards.
• Excellent verbal and written communication skills.

Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.