Duration: minimum 6 months
Strategic Project: EPOP
Job Summary:
The Lead ETL Architect/Lead is responsible for the design, develop, test and
implement of current and future data warehouse, business intelligence
solutions and data migration projects. This position is responsible for
leading the Extract, Transform, and Load (ETL) development activities and
ensuring quality of ETL code. The Lead ETL Data Integration developer guides
and mentors other developers as well work collaboratively with other team
members. The Lead ETL Data Integration developer collaborates with data
architects, BI architects to design and develop robust and scalable data
solutions. This position is 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.
Experience required:
• At least 6-8 years of experience designing, developing, and testing ETL
interfaces aligned with defined requirements preferably in a healthcare, or
analytical or technological industries.
• At least 3 years of architect/lead experience.
• 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.
• Experience with one of the Health Care systems – QNXT/CCA/EDIFECS is
preferred.
Skills Required:
• Strong technical skill to lead team to EDM technology roadmap. The
Enterprise Data Platforms includes Cloud based Informatica tool, IICS; Amazon
AWS, Snowflake cloud technology
• Demonstrated ability in success executing I.T. strategies to meet and
exceed.
• Strong knowledge and ability in identifying strategic business objectives.
• Strong ability to present ETL documentation and designs to team members and
convey complex information in a clear and concise manner.
• Ability to demonstrate effectiveness in developing successful business
relationships with I.T. internal and business personnel.
• Ability to engage key decision makers when it is required.
• Ability to articulate and sell complex solutions to I.T. and Business
leaders.
• Proven consultative and strategic skills.
• Outstanding inter personal and presentation skills.
• Excellent written and verbal/ telephonic communication skills.
• Demonstrated ability in providing high level technical expertise
Penguin Peers focuses on Technology, Finance Technology, and Fin Tech. Their
company has offices in Los Angeles. They have a small team that's between 1-10
employees.
You can view their website at <https://www.penguinpeers.com> or find them on
[LinkedIn](https://www.linkedin.com/company/penguinpeers/).
