Lead ETL Developer at Solugenix Corp

Lead ETL Developer
Los Angeles, CA (Remote/Onsite)
6-Month Contract
Job ID 24-09209

Solugenix is assisting a client, a prestigious health insurance company, in their search for a Lead ETL Developer. This is a 6-month contract opportunity based out of Los Angeles, CA (Remote/Onsite).

The Lead ETL Developer 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 the quality of ETL code. The Lead ETL Data Integration developer guides and mentors other developers as well works collaboratively with other team members. The Lead ETL Data Integration developer collaborates with data architects, and 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 the performance of assigned staff. Perform as the expert at identifying opportunities that improve and optimize their data environment for maximum value.

Qualifications:

• At least 6-8 years of experience designing, developing, and testing ETL interfaces aligned with defined requirements preferably in healthcare, or analytical or technological industries.
• At least 3 years of architect/lead experience.
• Experience in software development and design with a 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.

• Strong technical skills to the lead team to EDM technology roadmap. The Enterprise Data Platforms include Cloud-based Informatica tool, IDMC, Amazon AWS, and Snowflake cloud technology.
• Demonstrated ability in successfully executing I.T. strategies to meet and exceed.
• Strong knowledge and ability to identify 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 interpersonal and presentation skills.
• Excellent written and verbal/ telephonic communication skills.
• Demonstrated ability in providing high-level technical expertise.

Pay Range for CA, CO, IL, NJ, NY, WA, and DC: $75/hour to $80/hour. Starting rate of pay offered may vary depending on factors including but not limited to, position offered, location, education, training, and/or experience.

Solugenix will consider qualified applicants with a criminal history pursuant to the California Fair Chance Act and Ordinance. Applicants do not need to disclose their criminal history or participate in a background check until a conditional job offer is made to you. After making a conditional offer and running a background check, if we are concerned about conviction that is directly related to the job, applicants will be given the chance to explain the circumstances surrounding the conviction, provide mitigating evidence, or challenge the accuracy of the background report.

About the Client
Our client is one of the world's leading health insurance company based out of Los Angeles, CA.

About Solugenix
Solugenix is an information technology services company known for its deep experience and knowledge in providing comprehensive technology services, solutions, and talent support for companies around the world. The company offers a variety of cutting edge and talent support solutions to promote growth and cutting-edge advancement to our esteemed clients and candidates. We provide these talent support solutions on a contract, contract-to-hire, and direct hire basis. We also have additional resources from our staffing partners to ensure the right match and expertise for the best result.
For over 50 years, global and local brands have trusted Solugenix as an added resource and partner in taking steps to ensure their immediate and future success. In addition to generating ground-breaking, industry-defining solutions, Solugenix has been delivering the talent and support needed to make it happen. We are dedicated to partnering with clients and candidates whose core values also foster a culture of professionalism, teamwork, and integrity.