Negotiable
Outside
Remote
USA
Summary: The Lead Data Specialist Pathways role involves full-time participation in the MDCPS Data Management Team, focusing on data migration and design activities related to replacing a legacy case management system with a new cloud-based solution. The position requires expertise in data architecture, ETL design, and data quality management, with responsibilities including data pipeline implementation and analytics capabilities enhancement. The individual will report to the lead architect and contribute significantly to the team's objectives.
Key Responsibilities:
- Support and participate in identification and management of data-related issues, risks, and gaps.
- Understand, conceive, and document source and target-state data architectures for applications and cloud-based data analytic platforms.
- Design and implement data pipelines.
- Develop subject matter expertise in business drivers, semantic meaning, and practices for data management services.
- Design and develop ETL architecture and technical work packages.
- Deliver measurable improvements in data quality metrics.
- Create entity relationship diagrams, business vocabulary, data dictionaries, multi-dimensional models, and semantic models.
- Develop data mapping specifications for migration from legacy databases to new applications.
- Plan and implement data set catalogues.
- Provision and manage metadata in the data stack.
- Identify business rules for complex metrics and code calculations for those metrics.
- Design and develop 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: Other
Role: Lead Data Specialist Pathways