AWS Data Engineer: Dashboards & Big Data Pipelines

Robotic Process Automation LLC; Exton (PA); On-site; USD 87,000 - 117,000; Full time

Job summary

Commonwealth of Pennsylvania is seeking an AWS Data Engineer to join the PALDS analytics team in Exton, PA. The role focuses on transforming complex data into trusted information to support program delivery, operational improvements, and executive decision-making in state government agencies.

Responsibilities include evaluating data sources, developing analytics products, and delivering actionable insights for decision-makers. AWS, Python, and SQL skills are essential for this role.

Qualifications

• Advanced SQL knowledge with relational databases and query authoring.
• Experience building big data pipelines and datasets.
• Ability to design dashboards and analytics for executive users.
• Experience with student-level higher education data or linked sources is a plus.
• Root-cause analysis on data and processes to improve operations.
• Experience with unstructured data and data transformation workflows.

Responsibilities

• Transform complex data into trusted information for program delivery.
• Develop analytics products for executive decision-making.
• Evaluate data sources and respond to policy-relevant questions.
• Collaborate with state agencies to deliver actionable insights.

Skills

Advanced SQL

Big data pipelines

Dashboards for exec users

Data governance

Unstructured data analysis

Data transformation workflows

Tools

AWS cloud services

Python

Java

SQL & NoSQL databases

Git & CI/CD

Data modeling (dimensional, star/snowflake)

Job description

Commonwealth of Pennsylvania is seeking an AWS Data Engineer to join the PALDS analytics team in Exton, PA. The role focuses on transforming complex data into trusted information to support program delivery, operational improvements, and executive decision-making in state government agencies.

Responsibilities include evaluating data sources, developing analytics products, and delivering actionable insights for decision-makers. AWS, Python, and SQL skills are essential for this role.