Description

• 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

Key Skills

Education

Any Gradute