For roles that are 100% remote or hybrid, you must have access to a reliable high-speed internet connection to support daily job responsibilities. A minimum bandwidth of 50 Mbps download and 5 Mbps upload is required. Those fully remote associates residing in states where service is required by contract, law, or regulation will be allowed to submit for reimbursement. Your career starts now. We’re looking for the next generation of health care leaders. At AmeriHealth Caritas, we’re passionate about helping people get care, stay well and build healthy communities. As one of the nation's leaders in health care solutions, we offer our associates the opportunity to impact the lives of millions of people through our national footprint of products, services and award-winning programs. AmeriHealth Caritas is seeking talented, passionate individuals to join our team. Together we can build healthier communities. If you want to make a difference, we’d like to hear from you. Headquartered in Newtown Square, AmeriHealth Caritas is a mission-driven organization with more than 30 years of experience. We deliver comprehensive, outcomes-driven care to those who need it most. We offer integrated managed care products, pharmaceutical benefit management and specialty pharmacy services, behavioral health services, and other administrative services. Discover more about us at www.amerihealthcaritas.com. Responsibilities: Under the leadership of the Manager of Data Engineering & Automation, the Data Engineering Architect is responsible for Automation of report production in Business Intelligence (BI) systems that integrate with databases, data warehouses/marts and data lake. You will be responsible for delivering data warehouse and business intelligence solutions by building data models, writing ETL processes and administering systems to facilitate business intelligence tools. You will work closely with end users and IT development staff to ensure that new and existing data models and databases are consistent with approved data architecture standards. Work Arrangement Remote role Monday through Friday, 8:30 AM EST to 5:00 PM EST

Responsibilities

Design, develop, and test enhancements to ETL and BI solutions and work with complex Data modeling and design patterns for BI/Analytics reporting requirements Lead ETL design and development initiatives including data analysis, source-target mapping, data profiling, change data capture, ETL coding, QA testing, and performance tuning Support technical development in designing, testing and implementing database changes Partner with product owners to deliver high performing quality customer experiences that are engaging, purposeful and powerful in their simplicity Participate in automation script code reviews and provide guidance on their compliance with automation best practices Demonstrate skills using code repositories Interact with the product delivery team and participate in product requirement/design reviews to provide input on completeness of functional requirements, product designs and schedules Identify interdependencies, ambiguities or omissions and make suggestions to improve requirements and ensure usability/testability Review software documentation to ensure technical accuracy, compliance or completeness with focus to mitigate risks Learn rapidly and enthusiastically, focusing on understanding the application/product/area in detail Education and Experience Bachelor’s Degree in Computer Science or related field Minimum of 3 years of experience in an automation of reporting environment; agile environment, report automation engineering, batch and real time processing, agile methods, healthcare industry Experience working as a Data Engineer in a production environment with a focus on ETL’s, data monitoring, data engineering, and analytics Programming experience in Python, SQL Experience working in Databricks, MS SQL Server, Hadoop Experience working with PowerBI and Tableau Experience implementing solutions leveraging CI / CD etc. Our Comprehensive Benefits Package Flexible work solutions including remote options, hybrid work schedules, Competitive pay, Paid time off including holidays and volunteer events, Health insurance coverage for you and your dependents on Day 1, 401(k) Tuition reimbursement and more.