AWS Data Engineer - Congensys Corp.

Summary: The role will design and build the infrastructure and pipelines that enable organizations to collect, store, process, and analyze large volumes of structured and unstructured data efficiently and securely. The AWS Data Engineer is responsible for the end-to-end data lifecycle, from ingestion and transformation to storage and delivery for analytics, machine learning, and operational systems. They ensure data is reliable, high-quality, scalable, and accessible for business and technical stakeholders. Responsibilities:

• Design, build, and optimize ETL/ELT workflows to ingest data from multiple sources. (e.g., S3, Redshift, Lake Formation, Glue, lambda).
• Implement data cleansing, enrichment, and standardization processes.
• Automate batch and streaming data pipelines for real-time analytics. Build solutions for both streaming (Kinesis, MSK, Lambda) and batch processing (Glue, EMR, Step Functions).
• Ensure pipelines are optimized for scalability, performance, and fault tolerance.
• Optimize SQL queries, data models, and pipeline performance.
• Ensure efficient use of cloud-native resources (compute, storage, networking).
• Design and implement data architecture across data lakes, data warehouses, and lakehouses.
• Optimize data storage strategies (partitioning, indexing, schema design).
• Implement data integration from diverse sources (databases, APIs, IoT, third-party systems).
• Work with Data Scientists, Analysts, and BI developers to deliver clean, well-structured data.
• Document data assets and processes for discoverability.
• Training of existing core staff who will maintain infrastructure and pipelines.

Qualifications

• Bachelor s degree in Computer Science, Data Engineering, or related field.
• 5+ years of experience in data engineering roles
• Proficiency in SQL, Python, or Scala for data transformation and processing.
• Experience in the utility industry data
• Strong understanding of utility data domains: meter data, customer data, grid/asset data, work management, outage data.
• Familiarity with CIM standards and utility integration frameworks.
• Working Knowledge of AWS services such as:
• Storage & Processing: S3, Glue, Redshift, Athena, EMR
• Streaming: Kinesis, MSK, Lambda

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.