Data Lead / Architect - Onsite in Vermont, 13+ yoe required

Responsibilities:

• Generate a comprehensive architecture document for all data sources detailing the database or data model and for each identify all data elements, their name, origin, data classification, attribute, format, whether a key, index, the edits, verification, or validation done to ensure data quality and integrity.

• Assists the project team to describe/document the common data models, how managed, maintained and their contribution to downstream applications and processes.

• Partners with business and IT teams to gain consensus, and to establish and implement the migration solution architecture standards, policies.

• Partners with data governance group, technical architects, and IT leads in the selection of all data, and the ETL and/or customized and configurable tools to be proposed/used in data assembly, aggregation and subsequent migration.

• Provides impact analysis on key data issues to assist with prioritization.

  Ensures the architectural vision, roadmap, and standards for governing, modeling, storing, delivering, and migrating data within the enterprise are adhered to.

• Assists to develop and implement data stewardship practices and a shared responsibility model of data governance.

• Ensures the migration solution design addresses the data standards and principles both from a functional and technical requirement perspective.

• Leads data migration architecture and data migration design sessions and drives resolution of design issues as appropriate.

• Leads the design of migration solutions to enable the external stakeholder community (solution provider) to use contributing data, both Open Data and under Data Sharing Agreements.

• Prepares documentation, including data architecture, data migration design, data/system flow charts, associated business processes and data migration plans/planning.

• Conducts data architecture and design reviews and issue resolution.

• Develops reference data models, methods, and documentation for the project team to implement for data correlation and/or interleaving via use of an MDM, transitory and/or staging entities that support migration to a target database.

• Works with Data Stewards and technical SMEs to identify Critical Data Elements. Lead and/or participate in Data Management initiative across business units as required. Define and implement policies and processes for data quality, data security, and governance for the project.

• Develop and implement strategy(s) for Data Mastery and Master Data Management.

• Develop governance process(es) for data stewards to manage Master Data.

• Partners directly with IT development teams and technical architects in the implementation of all applied logical data models.

• Ensures data quality and integrity; interprets, analyzes, and drives resolution of data problems.

• Tests performance of data-driven products.

• Raises Data Quality issues to the project team and leadership.

• Attends relevant data meetings where specific knowledge is required.

• Conducts reviews to ensure quality, standards compliance, reusability, and ease of maintenance.

• Architects, designs, and documents a Pilot execution environment to test and analyze the performance and resource demands of the Data Migration Solution in accordance with the Data Migration Plan.

• Other assignments as required to achieve the successful completion of the project and associated tasks.

Core Technological Requirements:

1. Database Management:
• Proficiency with DBMS and RDBMS such as IBM s IMS, Oracle, PostgreSQL, and MongoDB.
• Expertise in handling hierarchical, relational, and unstructured data models.
2. Data Ingestion and Management:
• Strong skills in ETL toolsets and data modeling techniques.
• Experience in implementing Master Data Management (MDM) and data mastery solutions.
3. Data Quality Tools:
• Utilization of tools to ensure and maintain data quality and integrity.
4. Programming and Software:
• Proficiency in relevant programming languages for database management and data processing.
5. Security and Compliance:
• Deep understanding of data security practices and compliance regulations, potentially including HIPAA.

Required Qualifications:

• Bachelor s or Master s degree in Computer Science, Engineering, or related field.
• Minimum of 10 years of experience in data architecture, data science, or a similar role.
• Demonstrated project management and leadership skills.
• Excellent verbal and written communication abilities.

Preferred Qualifications: (Needs certification)

• Certified Data Management Professional (CDMP)

• Master Data Management Certification (MDM)

• Certified in Data Protection (CDP)

• Certified Public Sector Data Governance Professional (PSDGP)

• Certified Analytics Professional (CAP)

• AWS Certified Data Analytics Specialty