Data Engineer & Insights Analyst

Location: Remote Harrisburg, PA

Key Responsibilities

• Design, build, and maintain scalable data pipelines and cloud-based data architectures.

• Develop data solutions using AWS services, including S3, Glue, Redshift, EMR, Athena, Kinesis, and Lambda.

• Build and manage data orchestration workflows using Apache Airflow, AWS Step Functions, or similar tools.

• Extract, transform, and integrate large datasets from multiple sources using SQL and big data technologies.

• Develop analytical data environments supporting statistical analysis, predictive modeling, and machine learning.

• Perform data quality checks, validation, monitoring, logging, and root-cause analysis.

• Develop dashboards, reports, analytical models, and decision-support products.

• Support data conversion and system modernization initiatives.

• Implement data governance, metadata management, data lineage, privacy, and security controls.

• Collaborate with cross-functional teams to support enterprise data and analytics initiatives.

Required Qualifications

• Advanced SQL skills and experience with relational databases.

• Strong experience building and optimizing large-scale data pipelines and architectures.

• Experience developing dashboards, reports, analytical models, and decision-support products.

• Experience working with student-level higher education data and linking education data with employment and wage data.

• Strong analytical and problem-solving skills, including root-cause analysis.

• Experience processing large, complex, disconnected, and unstructured datasets.

• Strong project management and organizational skills.

• Experience working with cross-functional teams in a dynamic environment.