Senior Data Engineer Cloud Data Stack & ETL
Posted Today by 1759914853
Negotiable
Outside
Remote
USA
Summary: MDCPS is seeking a Senior Data Engineer to join their Data Management Team, focusing on data cleansing, migration initiatives, and the development of data models and cloud-based data architecture. The role involves significant participation in the transition from a legacy case management system to a new cloud-based solution, enhancing analytics capabilities. The position requires extensive experience in data management and analytics, particularly within the context of child welfare. The successful candidate will report to the lead architect on the team.
Key Responsibilities:
- Support and manage data-related issues, risks, and gaps.
- Document source and target-state data architectures for applications and cloud-based analytics platforms.
- Design and implement data pipelines.
- Develop subject matter expertise in business drivers and practices for data management services.
- Design and develop ETL architecture and technical work packages.
- Improve data quality metrics.
- Create entity relationship diagrams, business vocabulary, data dictionaries, and multi-dimensional models.
- Develop data mapping specifications for migration from legacy databases to new applications.
- Plan and implement data set catalogues.
- Manage metadata in the data stack.
- Identify business rules for complex metrics and code calculations.
- Design semantic models with time series and hierarchical views for child welfare metrics.
Key Skills:
- Eight (8) years of experience with multidimensional model database design, ETL design, and development.
- Eight (8) years of experience with data quality and master data management integration.
- Eight (8) years of experience with ERDs, business vocabulary, data dictionaries, and database schema mapping.
- Eight (8) years of experience in data analytic implementation projects.
- Three (3) years of experience with cloud-based data stack tools and platforms.
- Excellent English-speaking and written communication skills.
- Knowledge transfer skills.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
OBJECTIVE:
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 RESPONSIBLITIES:
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
Skills:
To be considered, all proposed consultants must meet the following mandatory requirements:
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 skill
Preferred Qualifications:
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