ETL Developer Job at Openkyber, Alaska

RUFLSGovSFhyL1BvbXVMSGIrNmtEQklka2c9PQ==
  • Openkyber
  • Alaska

Job Description

149462: Lead Data Specialist Pathways - MS MDCPS Remote 12 Months Position Description:

MDCPS seeks an experienced professional to participate in planning and execution of data cleansing and data migration initiatives and concurrently participate in development of data models, data stack architecture, technical implementation and other critical functions of data management that will enable evidence based Child Welfare Practice at MDCPS.

POSITION SUMMARY:

This position is full-time (40 hours weekly) and requires an individual to participate as a significantly contributing team member on the MDCPS Data Management Team (DMT). The near-term scope of this team and this position includes participating in data related migration and design activities on the replacement of legacy case management system with the new CCWIS Cloud-Based hosted solution, and additional to that, planning and implementation of cloud-based data stack to enable robust and actionable analytics capabilities at MDCPS. This individual will be reporting to the lead architect on DMT.

Major Responsibilities:

  • Support and participation in Identification and management of data-related issues / risks and gaps
  • Understanding, conceiving and documenting source and target-state data architectures for applications and cloud based data analytic platforms
  • Data Pipeline Design and Implementation
  • Development of subject matter expertise in business drivers, business semantic meaning and business practice when providing data management services.
  • Design and Development of ETL architecture and technical work packages
  • Deliver on measurable improvements of data quality metrics
  • Entity Relationship Diagramming, Business Vocabulary, Data Dictionary, Multi-Dimensional Models, Semantic Models
  • Data mapping specifications for migration from large legacy database to new case management application, entity relationship diagrams, data base schema, data dictionary, transformation lineage, business vocabulary/semantic models.
  • Data Set Catalogue Planning and Implementation.
  • Provisioning and managing meta data in the data stack
  • Identifying business rules for complex business metrics and coding calculations for those metrics.
  • Semantic model design and development with time series, hierarchical/drill down views for child welfare metrics

Required Skills:

  • Eight (8) years of experience with Multidimensional Model Data Base Design, ETL design and development.
  • Eight (8) years of experience with data quality and master data management integration.
  • Eight (8) years of experience with ERD's, business vocabulary, data dictionary and database schema mapping.
  • Eight (8) years of data analytic implementation projects
  • Three (3) years of experience with cloud-based data stack tool and platforms
  • Excellent English-speaking skills, written communication skills, and knowledge transfer skills

Preferred Skills:

  • Experience in Child Welfare data modeling, case management and analytics
  • Experience with data quality and data exchange components of federal requirements for Child Welfare management systems
  • Prior CCWIS experience
  • Ability to communicate effectively
  • Ability to build a positive, productive rapport with team members

Regards,
Satya Technical Recruiter
Key Business Solutions, Inc

Job Tags

Full time, Remote work,

Similar Jobs

United Guard Security, Inc.

Unarmed Security Officer - Shuttle Driver Job at United Guard Security, Inc.

 ...United Guard Security is seeking a reliable and responsible Shuttle Driver to provide safe and secure transportation for our students to and from specified locations. The Shuttle Driver will be responsible for ensuring the safety, security, and timely arrival of passengers... 

Sinch

AI Content & SEO Writer Job at Sinch

 ...The essence of the role We're looking for an experienced AI Content & SEO writer to help scale our global content engine and support Sinch's...  ...and family planning support. WORK WHEREVER: Our flexible remote work offerings allow you to work wherever youre the most... 

Ross Downing Chevrolet, Inc.

Experienced Car Detailer - Hammond, LA Job at Ross Downing Chevrolet, Inc.

We are looking for an experienced automotive detailer to join our team! Full-time position with benefits.Call Ross Downing Chevrolet at (***) ***-**** and ask for Body Shop Manager Mark Bernard, or apply in-person at 600 South Morrison Blvd in Hammond

Diehl Concrete Inc.

Concrete Laborer Job at Diehl Concrete Inc.

 ...Must have a valid drivers license and good attitude. Some of the job duties will include but not be limited to: Grading. Compacting. Tying rebar. Help demo concrete. Place and learn to finish concrete. Please include references and rsum.... 

Flowserve

Precision Assembler Job at Flowserve

 ...Precision Assembler - SIGN ON BONUS If a culture of excellence, innovation and ownership is what youre searching for, consider putting...  ...Capable of calculating basic mathematical functions including computation of rate, ratio, and percent and to convert one type of...