AWS Data Engineer for State Analytics & Dashboards

Ethereum Technologies LLC; Exton (PA); On-site; USD 84,000 - 120,000; Full time

Job summary

The Commonwealth of Pennsylvania is seeking an AWS Data Engineer to join its analytics team supporting the PALDS initiative. You will transform complex data into trusted information to support state program delivery and executive decision-making.

You will design data pipelines, dashboards, and analytical models for non-technical users and collaborate with cross-agency teams to improve data quality and accessibility.

Qualifications

• Advanced SQL knowledge and proficiency with relational databases.
• Experience building and optimizing big data pipelines, architectures, and datasets.
• Advanced dashboards, reports, analytic models for executive users.
• Experience with student-level higher education data and linking sources for outcomes.
• Experience performing root-cause analysis on data and processes.
• Strong analytics with unstructured datasets.
• Experience building data transformation processes, data structures, metadata, dependency, and workload management.

Responsibilities

• Transform complex data into trusted information to support program delivery and executive decision-making.
• Evaluate data sources and develop analytics products to deliver actionable insights.
• Understand policy questions and design analytics solutions for state government agencies.

Skills

Advanced SQL

Big data pipelines

Dashboards & reports

Unstructured data analysis

Data transformation processes

REST API design

Tools

AWS services (S3, EC2, Glue, EMR, Redshift, Athena, Lambda, DynamoDB)

Git

CI/CD pipelines

Airflow

Azkaban

Luigi

Informatica

MuleSoft

Talend

TIBCO

Kafka

Hadoop

Spark

Storm

Job description

The Commonwealth of Pennsylvania is seeking an AWS Data Engineer to join its analytics team supporting the PALDS initiative. You will transform complex data into trusted information to support state program delivery and executive decision-making.

You will design data pipelines, dashboards, and analytical models for non-technical users and collaborate with cross-agency teams to improve data quality and accessibility.