Alfa Energy Group (An Edison Energy Company) is a global energy advisory firm that helps large corporate, industrial, and institutional clients better navigate the choices, opportunities, and risks that will emerge from the transition to a net-zero future. As stakeholder expectations around corporate sustainability increase, Alfa, Altenex & Edison help companies rise to this challenge by designing and implementing individualized strategies, projects, and programs across sustainability, renewables, transportation electrification, energy optimization, and energy supply.
Our alliance enables organizations to deliver on their strategic, financial, and sustainability goals by addressing today’s key energy challenges: carbon, cost, complexity, and creating energy equity across communities.
Edison Energy LLC is a wholly owned subsidiary of Edison International (NYSE: EIX) and does business in Europe as Altenex Energy and Alfa Energy Group.
Position Overview
The Senior Data Engineer - Architect will design, develop, and support the applications and programs while ensuring all components adhere to a consistent, extensible, evolving architecture which meets business requirements. Your expert skills in understanding data and data structures and designing sustainable and modernized data asset solutions and processes, will be instrumental in delivering on key analytical and reporting initiatives.
For flexibility purposes, this position can be worked from either a remote location or hybrid office setting.
Key Responsibilities
- Coordinate with data scientists, software developers and engineers to design and evolve our existing infrastructure.
- Design, build, and maintain our ETL pipelines to support analytical database needs.
- Architect, develop, and manage our data infrastructure.
- Maintaining and administering best practices for Cloud data warehouse and Data Lake.
- Review system capabilities and evaluate for efficiencies and improvements.
- Evaluate, recommend, plan, and execute the integration of new functionality, business processes and data into existing applications environment.
- Architect solutions that help automate the processing and manipulation of the data and information into usable streams for our customers.
- Facilitate demonstrations, proofs of concepts, and presentations.
- Architect new Cloud-based data pipelines.
- Bring together multiple data sources into a unified data warehouse.
- Apply analytics and visualizations to data sets.
- Strategic planning for Cloud data.
Required Experience & Qualifications
- Bachelor’s degree or equivalent experience in Computer Science or Math, Business Systems or Information Systems or related field (or equivalent work experience) necessary.
- 5+ years data engineering experience.
- 3+ years Cloud technologies including Azure SQL, Azure Data Factory, Synapse Analytics, Azure Data Lake Storage.
- 3+ years Git, SQL.
- Experience with big data concepts (analysis, extraction, schema, lineage, etc.) for data sets.
- Extracting data from multiple sources via APIs, scripting, ETL concepts.
- REST API development.
- Experience architecting and building Azure data pipelines.
- Troubleshoot ETL process as needed. Ability to identify bugs and apply fixes. Check data sanity and integrity by means of process audits.
- Strong problem solving and analytical skills required.
- Team orientated with the ability to work and communicate effectively with users at all levels in the organization.
- Strong (English) oral and written communication skills necessary.
- Highly self-motivated and directed, with keen attention to detail.
- Able to prioritize and execute tasks in a high-pressure environment.
- Ability to meet and coordinate multiple tasks and tight deadlines.
- Ability to function as a team member.
Preferred Experience & Qualifications
- Engineering degree, Microsoft Dynamics (D365) CRM and Power Platforms / Azure Fundamentals.
- Knowledge of Azure Data bricks and Cosmos DB.
- Knowledge of reporting tools including Power BI.
- Knowledge of Python or Scala.
- Database schema design, calculated metrics, alerts, reports.
- Familiarity with C#/.NET, SQL, Python, R, Scala, and others.
- Experience with microservices applications and Cloud-based services, data lake concepts for landing, refining, and analyzing data.
- Skills in leadership, managing through influence, relationship management, and presentations.
- Ability to work with BA, PM, other stakeholders at all levels.
Key Competencies
- Must work well in a dynamic environment and be comfortable adapting to changing business needs.
- Strategic thinker capable of establishing a clear intent and direction.
- Strong organization and process-oriented skills.
- Demonstrated ability to multi-task in a high-paced environment.
- Outstanding attention to detail while working on multiple projects with competing timelines.
- Ability to work independently on aggressive schedules and be self-motivated.
- Ability to understand and communicate complex technical concepts to a cross-disciplinary audience, both in writing and in presentation skills.
- Must work well in a remote team environment.
- Aptitude for analytical thinking, attentive to detail, and able to stay organized across multiple workstreams.
- Strong interpersonal skills with the ability to communicate and present effectively.
- Effectively solves problems and conflicts, thrives in collaborative environments.
Edison Energy, Altenex Energy and Alfa Energy Group is committed to building a diverse and inclusive workplace. We are a proud Equal Opportunity Employer and will not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national original, age, disability, protected veteran status or any other protected status.
#LI-Hybrid
Competitive Benefits Available
