Data Engineer

At AES, we raise the quality of life around the world by changing the way energy works. Everyone makes an impact every day in our small, global teams. Apply here to start an extraordinary career today.

Position : Data Engineer

Reports to : Analytics Director

Location : Remote, Indianapolis (IN), Dayton (OH) or Arlington (VA)

At AES we have an amazing opportunity to transform the world with renewable energy. By using the vast amounts of information available, we are designing Smart Maintenance, Smart Operations, Smart Grid and other Energy related solutions to improve our operations and be a global leader in renewable energy generation.

Data Engineers work collaboratively with business and technology stakeholders to establish and maintain the enterprise data architecture and data migration efforts. You will be responsible for building, operating and supporting the latest cloud-based data technologies from data ingestion to consumption. As part of a team, you help to successfully deploy large scale data solutions in the enterprise, using modern cloud based technologies.

Your Role and Responsibilities

Data Engineers are a part of AES's digital transformation. The focus of this role would be on the development side with main emphasis on the concepts of efficiently designing and implementation of our cloud-based Enterprise Data Lake. Work with Enterprise/Solution Architects to create/implement plans to improve existing data models and structure the tables with the design pattern that will help the system for improved performance. Generally, has in-depth knowledge and expertise of database technologies, along with solid programming, design and system analysis skills. Willingness to learn new technologies that can help improve the current system.

The Work You May Do

• Build pipelines and processes for cleaning and organizing data as well as build tools to help make the data accessible by data scientists and the business.
• Leverage Google Cloud Platform and similar tools.
• Understand and support a corporate data model and overall data governance
• Communicate with application, back-office and external customer teams regarding data requirements, standards, performance and access
• Define and perform unit testing of database code as appropriate.
• Perform code reviews and audits of application team’s database code to ensure compliance with established best practices.
• Utilize big data analytics tools and apply techniques for data retrieval, preparation and loading of data from a wide variety of data sources using various data engineering tools and methods.
• Build integrations (API, etc.) with on-premise and cloud databases
• You have a strong understanding of programming languages extensively used in Data Science applications (e.g., R, Python, Scala, Java, etc.)
• Debug, troubleshoot, design and implement solutions to complex technical issues.
• Build capabilities with software tools (e.g. Google Cloud Platform)
• Work in an Agile, collaborative environment, partnering with other scientists, engineers, and database administrators of all backgrounds and disciplines to bring analytical rigor and statistical methods to the challenges of predicting behaviors.
• Designing and implementing data solutions for operational and secure integration across systems.
• Demonstrating solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
• Improving operations by conducting systems analysis to understand process and application bottlenecks; recommending changes in policies and procedures.
• Leverage Agile, CI/CD and DevOps methodologies to deliver high quality product on-time

Who You Are

• You have a knack for transforming data and migrating data in cloud platforms leveraging cloud native tools.
• You have built high-capacity data analytics systems using cloud platforms and services for storing, collecting, and analyzing data. (Google Cloud preferred.)
• You have a passion for creating scripts to move data and a prowess for data manipulation
• You have the ability to deal with ambiguity and the flexibility to change direction as additional information becomes available.

Required Professional and Technical Expertise

• Bachelors degree in in computer science, software engineering or a closely related field; a Master's degree is preferred
• 2 + years of experience developing batch and streaming ETL processes (preferably Talend)
• 2 + years of experience with relational and NoSQL databases, including modeling and writing complex queries
• 2 years of development experience leveraging an Agile methodology with experience collaborating on coding projects in Google Cloud Platform
• 2+ years of industry experience with modern programming languages like Python (preferred), Java, etc.
• 1+ years of industry experience with graph databases like Neo4j or TigerGraph (preferred)
• Exposer to columnar cloud databases preferably BigQuery.
• Exposure to relational database platforms like Microsoft, Oracle, etc.
• Progressive mindset particularly around deployment models and emerging technologies
• 2 + years of experience in Cloud Engineering, experience in a similar role with demonstrated relationship building skills resulting in traceable, measurable, impactful results
• experience working in team environments and implementing organizational change.

AES is an Equal Opportunity Employer who is committed to building strength and delivering long-term sustainability through diversity and inclusion. Respecting all backgrounds, differences and perspectives enables us to improve the lives of our people, customers, suppliers, contractors, and the communities in which we live and work. All qualified applicants will receive consideration for employment without regard to sex, sexual orientation, gender, gender identity and/or expression, race, national origin, ethnicity, age, religion, marital status, physical or mental disability, pregnancy, childbirth, or related medical condition, military or veteran status, or any other characteristic protected under applicable law. E-Verify Notice: AES will provide the Social Security Administration (SSA) and if necessary, the Department of Homeland Security (DHS) with information from each new employee's I-9 to confirm work authorization.

Safety comes first at AES. To protect the health and safety of our people, customers, communities and partners, and to provide and maintain a workplace that is free of known hazards, AES requires all newly-hired people or current AES people applying for U.S.-based role(s), to be fully vaccinated against COVID-19 or be willing to be fully vaccinated against COVID-19 by their date of hire. Except where prohibited by law or not specifically covered in a collective bargaining agreement, new hires and transfers will be required to provide proof of vaccination during onboarding and periodically thereafter. This policy will comply with all applicable laws and is based on guidance from the Centers for Disease Control and Prevention and local health authorities, as applicable.