Job Description:
Job Summary: The Senior Data Engineeris responsible fordesigning, building, and evolving Penn Mutuals enterprise data platforms and pipelines that enable analytics, reporting, and data-driven decision making.
As a senior individual contributor, the Senior Data Engineer partners closely with architecture, analytics, data governance, and application teams to translate business and analytical needs into robust data engineering solutions aligned with enterprise cloud and technology standards.
Responsibilities:
- Design, build, and maintain scalable batch and streaming data pipelines supporting enterprise analytics, reporting, and downstream consumption.
- Develop and optimize data ingestion, transformation, and orchestration workflows across structured and semistructured data sources.
- Engineer and maintain curated, analyticsready data models (e.g., dimensional, canonical, or domainoriented datasets).
- Ensure data solutions meet performance, reliability, availability, and recoverability expectations.
- Implement data solutions aligned to Penn Mutuals cloud data platform strategy, including cloud storage, compute, and analytics services.
- Apply data architecture patterns that support data lakes, lake houses, and analytical warehouses.
- Partner with Enterprise Architecture to ensure data solutions conform to technology standards, integration patterns, and security requirements.
- Contribute to platform evolution decisions, including tooling selection, architectural patterns, and modernization initiatives.
- Embed data quality checks, validation rules, and observability into pipelines to ensure trusted data.
- Support data governance and stewardship practices, including metadata management, lineage, and controlled data access.
- Ensure data solutions comply with security, privacy, and regulatory requirements relevant to financial services and insurance.
- Collaborate with analytics, reporting, and data science teams to enable selfservice analytics and advanced insights.
- Translate business requirements into welldesigned data structures and datasets that are easy to consume and reuse.
- Support downstream use cases including dashboards, regulatory reporting, operational analytics, and advanced modeling.
- Promote engineering best practices including version control, automated testing, CI/CD, and documentation.
- Drive continuous improvement through evaluation of emerging data technologies and industry trends.
Minimum Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the minimum knowledge, skill, and/or ability required.
- Bachelors degree in Computer Science, Engineering, Information Systems, or a related field (Masters degree preferred).
- 5+ years of professional experience in data engineering, analytics engineering, or data platform development.
- Strong proficiency in SQL and at least one modern programming language commonly used for data engineering (e.g., Python, Java, or Scala).
- Develop AWS serverless solutions using Lambda, Glue, Step Functions, SNS/SQS, EMR, Lake Formation, API Gateway, IAM, CloudFormation, CloudWatch, S3.
- Extensive experience designing and building data pipelines and analytical data models.
- Handson experience with cloudbased data platforms and distributed data processing concepts.
- Solid understanding of data architecture patterns, data integration, and performance optimization.
- Strong problemsolving skills with the ability to analyze complex data challenges and implement effective solutions.
- Excellent communication skills, with the ability to explain data concepts to both technical and nontechnical stakeholders.
Preferred:- Experience with cloud computing platforms (e.g., AWS, Azure, Google Cloud) and containerization technologies (e.g., Docker, Kubernetes).
- Knowledge of Infrastructure as a Service concepts and tooling (Cloud Formation, Terraform, etc.), deployment automation tools (Jenkins, GitHub Actions, Bamboo, etc.)
- Knowledge of software development methodologies such as Agile or Scrum.
Competencies:
- Customer Service: Exceptional attitude and a passion for providing outstanding service to internal customers.
- Attention to Detail: Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently
- Analytical Skills: Collects and researches data; Designs workflows and procedures; Identifies data relationships and dependencies.
- Communications: Exhibits good listening and comprehension. Expresses ideas and thoughts in verbal and written form. Keeps others adequately informed. Selects and uses appropriate communication methods.
- Problem Solving: Ability to solve issues efficiently and quickly.
Base Salary Range - $130,000 - $150,000
