Senior ETL Developer

Hi,

Hope you are doing great!

We have an opening for a Senior ETL Developer with our direct client, California Public Employees' Retirement System (CalPERS). If you are interested, kindly reply to me. I really appreciate your interest & time.


Job title: Senior ETL Developer

Duration: 12+ months

Location: Sacramento, CA - Hybrid (3 days onsite and 2 days remote)

Description:

The Analytics Specialist will be responsible for designing and implementing comprehensive data models that support analytics and business needs. Their work will encompass creating models that consist of data pipelines, the structure of the data, physical and virtual instances of the data, and optimizing for the analytics performed on the modeled data.

Key responsibilities include:

• Data Modeling and Design - Develop and maintain traditional data models for relational databases; Design application-supporting data models using advanced methodologies such as relational modeling, medallion architecture, and data modeling for cloud environments; Create data models tailored for artificial intelligence machine learning use cases specific to Clients needs.
• Tool Proficiency - Utilize Erwin Data Modeler software to design and maintain data models; Utilize Power BI to model data for visualization and analytics.
• Publishing and Documentation - Support publishing and maintenance of data models on the Client intranet for organizational access; Create, document, and maintain analytical models to ensure data literacy and usability by business users.
• Knowledge Transfer - Provide data modeling knowledge transfer sessions to ITSB team members and key business stakeholders, ensuring they understand and can apply relevant concepts and practices, and take ownership of all models created by the contractor. Advise the development and maintenance of data models by state staff.

Required Skills:

• At least five (5) years of experience in some or all areas of Pension, Health Insurance, Customer Service, or Finance.
• At least five (5) years of experience performing tasks pertaining to data integration (ETL) processes to transform disparate source data into the target data stores, data warehouses or datamarts.
• At least three (3) years of experience in data integration projects using Oracle Database 19c and Oracle Data Integrator or similar ETL tools
• At least five (5) years of experience with interpreting requirements and developing complex PL/SQL, SQL and data marts.