L.A. Care Health Plan needs to design, develop, test, and implement current and future data warehouse, business intelligence solutions, and data migration projects, ensuring the quality of ETL code and optimizing their data environment for maximum value.
Requirements
- Experience in software development and design with strong emphasis on Data warehousing concepts, database design patterns, ETL methodologies, Processing and Transforming massive quantities of Data, Data cleansing, Data quality and Performance Tuning of ETL and database processes.
- Experience with Erwin data modeling toolset.
- Extensive experience in strategizing roadmap projects, data modeling, designing ETL framework and data mart life cycle development and providing technical supervision on implementation of large end-to-end Data Warehouse applications.
- Experience in UNIX Shell / Python Scripting for automation of batch and ETL jobs.
- Strong technical skill to learn, certified and lead team to EDM technology roadmap. The Enterprise Data Platforms includes Cloud based Informatica tool, IICS; Amazon AWS, Snowflake cloud technology
- Automate the processes using UNIX shell and python scripts for business needs.
- Ensures adherence to data management/governance policies, processes, and standards and responsible for fixing data quality issues by working together with data analyst and data architect.
Responsibilities
- Responsible for the design, develop, test and implement of current and future data warehouse, business intelligence solutions and data migration projects.
- Responsible for leading the Extract, Transform, and Load (ETL) development activities and ensuring quality of ETL code.
- Collaborates with data architects, BI architects to design and develop robust and scalable data solutions.
- Responsible for the requirement analysis, design, development, architecture, implementation and support of enterprise-wide databases.
- Delivers data integration through the implementation of shared databases, modification and optimization of current systems, managing the exchange and storing of data, and making recommendations when upgrades or changes are needed to maintain smooth operations.
- Optimizes data warehouse performance by dealing with any data conflicts that arise and keeping data definitions up to date.
- Tune and optimize ETL and database processes and framework.
Other
- Guides and mentors other developers as well as work collaboratively with other team members.
- Responsible for the daily workflow and leading the work of assigned staff.
- The Lead will mentor, coach, act as a resource and provide feedback on performance of assigned staff.
- Perform as the expert at identifying opportunities that improve and optimize their data environment for maximum value.
- Leads the work of assigned staff; regularly assigns and checks the work of others, providing guidance, training and feedback on performance to department management.
