Data & Integration Engineer

The future of energy is digitized, decarbonized and localized. At SmartestEnergy, we need revolutionary thinkers to help our customers make the most of this new landscape, thinking differently to find smart solutions to complex problems. 

Formed in 2001, we’re an agile business driven by entrepreneurial thinking. As a subsidiary of the Marubeni Corporation, we also have strong investment and infrastructure behind us. As well as our three offices in the US, we have three offices in the UK and another in Australia.  Further expansion is planned for 2026 and beyond which means global career opportunities for you, with plenty of potential to explore new markets. 

When you join our Team, you will have the opportunity to contribute and make an impact every single day. 

Overview

As part of Smartest Energy US’s IT department, the Data & Integration Engineer plays a critical role in transforming raw operational and market data into actionable insights that drive business decisions across the energy value chain. This unique role sits at the intersection of business intelligence and cloud architecture. You will be responsible for not only analyzing data to drive business decisions but also building the Azure API integrations and Microsoft Fabric workflows that ensure our data ecosystem is automated, scalable, and reliable. The successful candidate will work closely with stakeholders in Trading, Risk, Retail, and Finance to design and deliver high-quality data solutions, reports, and analytics. This includes data modeling, validation, and visualization to enhance data platforms and reporting tools. This is an exciting opportunity to join a growing, innovative energy business that values collaboration, agility, and the intelligent use of data to enable smarter energy solutions.

In this role, you will be involved with the following:

• Partner with business users to gather and translate analytical and reporting requirements into technical solutions.

• Develop and maintain data models, dashboards, and reports to support Trading, Risk, Retail, and Finance operations.

• Perform data validation and quality assurance to ensure accuracy, consistency, and completeness.

• Design and maintain Azure APIs (Functions, API Management) to facilitate data exchange between internal systems and third-party vendors.

• Identify manual bottlenecks and implement automated solutions using Power Automate , Azure Logic Apps , or Python scripts.

• Analyze market and operational data to identify trends, variances, and opportunities for business improvement.

• Support integration of new data sources, including wholesale energy market data, customer systems, and financial systems.

• Assist with system testing, troubleshooting, and documentation for data-related initiatives.

• Promote best practices for data management, security, and governance within the IT organization.
  

To be successful in this role, you are likely to have the following skills/experience:

• Bachelor’s degree in computer science, Data Analytics, Information Systems, Engineering, or a related field.

• 3–7 years of experience as a Data Analyst, preferably in the energy, utilities, or commodities sectors.

• Strong SQL skills and experience with data visualization tools (e.g., Power BI, Tableau, Qlik).

• Hands-on experience with Azure services (App Services, Key Vault, SQL Database).

• Strong understanding of RESTful APIs , JSON, and authentication protocols (OAuth2).

• Working knowledge of data warehousing, ETL concepts, and cloud-based data platforms (Azure, AWS, or GCP).

• Experience with CI/CD pipelines (Azure DevOps) and automation via Python or PowerShell.

• Familiarity with wholesale and retail electricity markets, market data feeds, or risk/settlement systems is highly desirable.

• Strong analytical mindset, attention to detail, and the ability to communicate complex information clearly to non-technical audiences.

• Experience of collaborating across technical and business teams in a fast-paced, evolving environment.

Diversity

Celebrating our inclusive and diverse culture is core to what we do. We value everybody irrespective of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability and genetic information (including family medical history). EOE.

We know that for our business to thrive we need diverse talent with a range of backgrounds, skills and capabilities in each of the countries in which we operate. We view diversity as one of the key enablers that helps our business to grow.

We are committed to the full inclusion of all qualified individuals. As such, if a reasonable accommodation is needed to participate in the job application or interview process, please reach out to the HR & People Team via email [email protected] so we can discuss with you further.