Data Engineer & Insights Analyst

Job Summary

The Commonwealth of Pennsylvania is seeking a skilled professional to join its analytics team to support the Pennsylvania Longitudinal Data System (PALDS). The role involves transforming complex data into reliable, actionable information to enhance program delivery, operational improvements, and decision-making within state government agencies. This position requires an understanding of policy-relevant research questions, evaluating data sources, and developing analytics products to provide actionable insights.

Responsibilities

• Create and maintain optimal data pipeline architecture.
• Design and implement cloud-based data solutions using AWS services such as S3, Glue, Redshift, EMR, Athena, Kinesis, and Lambda.
• Build and maintain data orchestration workflows using tools like Apache Airflow and AWS Step Functions.
• Assemble large, complex data sets meeting business requirements.
• Engineer analytical data environments for advanced statistical analysis, predictive modeling, and evidence-building activities.
• Partner with data scientists and analysts to ensure data assets support reproducible research and modeling.
• Identify, design, and implement internal process improvements.
• Build infrastructure for optimal data extraction, transformation, and loading from various sources using SQL and 'big data' technologies.
• Develop dashboards, reports, analytical models, and decision-support products.
• Ensure compliance with data governance standards, privacy requirements, and security controls.

Required Qualifications

• Advanced SQL knowledge and proficiency with relational databases.
• Experience building and optimizing 'big data' pipelines, architectures, and data sets.
• Advanced proficiency in designing dashboards, reports, and analytical models.
• Experience with student-level higher education data and establishing linkages to other sources.
• Strong analytic skills for working with unstructured datasets.
• Experience in data transformation, data structures, and workload management.
• Proficiency with cloud-based data services such as AWS.
• Proficiency in scripting languages like Python, R, Java, C++, Scala.
• Experience with version control systems like Git and CI/CD pipelines.
• Knowledge of data modeling techniques and data governance frameworks.
• Experience with big data tools such as Hadoop, Spark, Kafka.
• Experience with data pipeline and workflow management tools.
• Experience with data integration services from vendors like Informatica, MuleSoft, Talend, and TIBCO.

Location

Role is remote - however final interview is onsite in Harrisburg PA. 

Harrisburg, the capital city of Pennsylvania, offers a rich history and vibrant culture. It is a hub for government and business activities in the state, providing a dynamic environment for professionals.

 

---

Benefits
PEAK's benefit offerings available for our associates include medical, dental, vision, Flexible Spending Account (FSA), Dependent Care Savings Account (DCA), and 401K plan. PEAK believes that taking care of our team is essential for success and we are proud to provide benefits that enhance both your well-being and your future. Additionally, our associates may be eligible for Paid Sick Leave as required by Federal, State, or local laws.  

---

Equal Opportunity Employer (EEO) 
PEAK Technical Staffing is committed to creating a diverse and inclusive environment and is proud to be an Equal Opportunity Employer. PEAK does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or veteran status, or any other characteristic protected by applicable law. All employment decisions are made based on qualifications, merit, and business need. We encourage all individuals to apply. 

---

Americans Disabilities Act (ADA) 
The physical and mental requirements described in this job description are representative of those that must be met by an employee to successfully perform the essential functions of the position. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions. Must be able to perform the essential physical functions of the position, including sitting, standing, walking, stooping, kneeling, and lifting up to 25 pounds, with or without reasonable accommodation. 

---

Candidate Privacy
To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://peaktechnical.com/privacy-policy/ and https://peaktechnical.com/ca-residents-privacy-rights/  

---

AI Recruiting Disclosure 
We use AI-assisted tools to help review applications and compare your experience to job requirements, but all hiring decisions are made by human recruiters. You may request a human-only process or opt out of automated communication at any time. Required notices and our latest bias audit are available on our website: www.peaktechnical.com/ai-disclosure.