Data Engineer & Insights Analyst

Phoenix Business Consulting (Intelligent Enterprise); Harrisburg (Dauphin County); Remote; USD 90,000 - 150,000; Full time

Job summary

Phoenix Business Consulting (Intelligent Enterprise) is seeking a data engineering-focused professional to design and maintain scalable data pipelines and cloud-based architectures. The role involves building data solutions with AWS services, orchestrating workflows, and integrating large datasets for analytics and reporting.

The candidate will develop analytical environments, ensure data quality, and support governance and modernization efforts while collaborating with cross-functional teams

Qualifications

• Advanced SQL skills with relational databases.
• 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.

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.

Skills

Advanced SQL

Large-scale pipelines

Dashboards & reports

Education data linkage

Analytical skills

Unstructured data

Project management

Cross-functional teams

Job description

• 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.

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.