Job Description:Position OverviewWe are seeking an experienced and highly skilled Cloud Data Engineer to join our innovative team. In this pivotal role, you will be key in architecting, developing, and deploying sophisticated data solutions. You will design and build scalable data pipelines and integrations that drive our data-centric initiatives, ensuring data integrity and optimizing performance.We've embraced a flexible, hybrid approach to work. Based on your role and personal preference, we empower you to choose where you work best. This model allows you to balance your life and bring your whole self to work.
Responsibilities- Architect and Develop Data Solutions: Lead the end-to-end design and development of robust data pipelines and data architectures using AWS tools and platforms, including AWS Glue, S3, RDS, Lambda, EMR, and Redshift.
- Optimize ETL Processes: Design and optimize ETL workflows to facilitate the efficient extraction, transformation, and loading of data between diverse source and target systems, including data warehouses, data lakes, and both internal and external platforms.
- Collaborate and Design Data Models: Partner with stakeholders and business units to develop data models that align with business needs, analytical requirements, and industry standards.
- Data Integration and Architecture Maintenance: Collaborate with internal and external teams to design, implement, and maintain data integration solutions, ensuring high data integrity, consistency, and accuracy.
- Implementation and Troubleshooting: Oversee the implementation of data solutions from initial concept through to production. Troubleshoot and resolve complex technical issues to ensure data pipeline stability and high performance.
- Leadership and Mentorship: Provide guidance and leadership to engineering teams, promoting a culture of continuous improvement, knowledge sharing, and technical excellence. Mentor junior engineers and foster their professional growth.
- Innovation and Strategy: Drive technical innovation by staying abreast of industry trends and emerging technologies. Influence technical strategies and decisions to align with organizational goals and objectives.
- Documentation and Best Practices: Develop and maintain comprehensive documentation for data architectures, pipelines, and processes. Establish and enforce best practices for data engineering and quality assurance.
Skills and Abilities- Technical Expertise: Proficiency in ETL processes using Python, Java, or Scala, and hands-on experience with AWS tools and platforms. Demonstrated ability to design data models and implement data schemas.
- Innovation and Leadership: Proven track record of driving technical innovation, leading cross-functional projects, and shaping technical strategies and decisions.
- Problem-Solving Skills: Excellent analytical skills with the capability to diagnose complex technical problems and implement effective solutions.
- Soft Skills: Strong leadership, communication, and collaboration skills, with a commitment to mentoring and developing talent within the team.
- Additional Skills: Experience with data governance, security, and compliance best practices. Familiarity with other cloud platforms (e.g., Google Cloud, Azure) and data processing technologies.
- Domain Knowledge: Familiarity with financial services and capital markets is a plus.
Education- Bachelor's Degree in Computer Science, Engineering, or a related field Required
- Master's Degree Preferred
Experience- 7-10+ years of professional experience in data engineering with a strong focus on designing, developing, and implementing data pipelines and integrations.
Licenses- AWS Certified Solutions Architect and/or AWS Certified Data Engineer
Base Salary Range - $100,000 - $126,000For over 175 years, Penn Mutual has empowered individuals, families and businesses on the journey to achieve their financial goals. Through our partnership with Financial Professionals across the U.S., we help instill the confidence and reliability that comes from a stronger financial future. Penn Mutual and its affiliates offer a comprehensive suite of competitive products and services to meet the unique needs of Financial Professionals and their clients, including life insurance, annuities, wealth management and institutional asset management. To learn more, including current financial strength ratings, visit www.pennmutual.com.Penn Mutual is committed to Equal Employment Opportunity (EEO). We provide employment and advancement opportunities to all qualified applicants and associates, according to applicable laws. This is reflected in our practices for hiring, placement, promotion, transfer, demotion, layoff, termination, recruitment, compensation, selection or training, and all other terms and conditions of employment. All employment-related decisions and practices are free from unlawful discrimination. This includes: race, creed, color, national origin, ancestry, citizenship age, gender (including pregnancy), sexual orientation, gender identity or expression, domestic partnership or civil union status, marital status, genetic information, disability, religious observance or practice, liability, veteran status or any other classification protected under applicable law.