Solution/Data Architect (Onsite) -- Position on our payroll

Gateway Solutions
SC, United States
Full-time
Quick Apply

Req-ID : 11434-1

Client : State of South Carolina(Department of Health and Human Services)

Role : Solution / Data Architect(Onsite)

Location : COLUMBIA, SC 29210

Duration : 36 Months

Web Cam Interview

The Replacement Medicaid Management Information System (MMIS) project is one of the largest IT projects for the State of South Carolina.

It is a multi-year effort to replace the State's aging MMIS and related applications with more modern capabilities along with

corresponding business operations services.

DAILY DUTIES / RESPONSIBILITIES :

The MES Core Software and Solution / Data Architects are responsible for defining and diagramming solutions around the data structures for MES Core as a Source of Truth and central data hub within SCDHHS.

They are responsible for defining and updating internal canonical data models and recording those definitions within modeling tools and documentation, as well as performing the necessary mapping from source systems to the canonical model to guide the overall Extract, Transform, Load (ETL) processes of MES Core in its primary function as a data interchange hub.

This position incorporates data-based technical analysis and decision-making on structures, metadata, data types, valid values, and mastering rules for MES software solutions.

As MES Core matures into a Source of Truth for SCDHHS, the ability to design solutions that are compatible with a distributed master data management solution are critical.

In addition to serving as primary architects of data modeling solution, this role also carries the responsibilities of MES Core Software and Solution Architects : defining ETL solution patterns and supporting development teams during the typical SDLC of automated data transmission solutions.

SCDHHS is looking for candidates who can work independently, are meticulous and careful in definition of design and data modeling and can confidently execute on significant design decisions that reflect the shape of data transmission for the agency'

s data interchange hub.

Essential Responsibilities :

  • Work alongside appropriate technical and non-technical staff to understand the underlying requirements of target and source systems and their native data structures and relationships.
  • Create data models that accurately represent translation from source to hub or hub to target depending on need.
  • Design data models that promote a comprehensive representation of agency data, and that accommodate the needs of various systems of record from which authoritative data originates.
  • Leverage national standards and design concepts from organizations like CMS and HL7 to ensure that future data interchange is as effective and standardized as possible.
  • Assist development teams in understanding data models and intended targets.
  • Function as a solutions architect for development teams when data modeling needs have been met.

Program Experience :

  • Experience should include success in developing solutions with and modelling enterprise level data in a health care domain.
  • Experience should include working with Protected Health Information (PHI) and Personally Identifiable Information (PII).
  • Experience working in an Agile framework is preferred.
  • Experience working with FHIR highly preferred.

Technical Experience :

  • Amazon Web Services (AWS) environments, including experience with AWS components such as Glue, DocumentDB, HealthLake, DynamoDB, Athena, S3, Redshift, and Kinesis, and Lake Formation.
  • Experience with UML data modelling for relational databases, NoSQL document data stores, and data lakes using common data modelling tools such as SPARX.
  • Working knowledge of SQL and NoSQL query tools.
  • Working knowledge of JSON and XML.
  • Big Data and NoSQL technologies such as MongoDB and Hadoop.
  • Relational systems such as Oracle or Microsoft SQL Server.
  • Experience with Master Data Management.
  • Experience with scripting languages such as Python or JavaScript.
  • Data analysis and visualization using technology such as Tableau.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE) :

  • 5+ years of experience with enterprise data mapping and data modelling
  • 5 + years of experience with querying languages
  • 2+ years of solution architecture design
  • 2+ years of experience working in AWS environments

REQUIRED EDUCATION / CERTIFICATIONS :

  • Bachelor's degree in Computer Science, Applied Math or similar discipline or equivalent work experience
  • 14 hours ago
Related jobs
Gateway Solutions
SC, United States

In addition to serving as primary architects of data modeling solution, this role also carries the responsibilities of MES Core Software and Solution Architects: defining ETL solution patterns and supporting development teams during the typical SDLC of automated data transmission solutions. Req-ID: ...

Crossroads
Charleston, South Carolina

Strong knowledge of data architecture, data warehousing, business intelligence, data integration, data analysis, reporting, and/or machine learning. Experience in the design and development of cloud data solutions including data lake storage, relational data, semi-structured data, streaming data, an...

Gateway Solutions
SC, United States

OBJECTIVES TO BE FULFILLED BY CANDIDATE:</b><br /> The principal duties of this position are to evaluate agency needs, as-is and to-be business processes, and technical designs to provide analysis and advice on strategies for information technology solutions and non-technical solutions. ...

Lorven Technologies
Charleston, South Carolina

Strong communication and collaboration skills, with the ability to effectively communicate technical concepts to non-technical audiences. Strong communication and collaboration skills, with the ability to effectively communicate technical concepts to non-technical audiences. The ideal candidate is w...

Promoted
AMAROK
Columbia, South Carolina

At least three years sales engineering or technical sales experience. As the Technical Sales Engineer (TSE), you will be part of AMAROK's dynamic Product Management team where you will play a pivotal part in preparing and delivering compelling product demonstrations to both internal stakeholders and...

Promoted
Incedo Inc.
Fort Mill, South Carolina

Understanding of cloud-based disaster recovery (DR) strategies and high availability (HA) architectures. Experience in migrating on-premises workloads to the cloud. ...

Promoted
Capgemini
Fort Mill, South Carolina

AWS cloud Engineer would be responsible for implementing & and maintaining cloud infrastructure and services. Deploy, and manage scalable and reliable cloud infrastructure on AWS platform. Collaborate with architecture and development teams to ensure cloud solutions align with business requirements....

Promoted
HKA Enterprises
Greenville, South Carolina

Serves as a technical, system integration, and IT architecture subject matter expert and works with operations team, IT Architects, Systems Analysts, and within the IT infrastructure technical team to design and build IT systems and platforms that exceed functional expectations consistent with the v...

Promoted
Swift Placement & Consulting
Greenville, South Carolina

We are seeking a sales hunter that can prospect and engage customers in an exclusive and protected sales territory. Industrial sales or capital equipment background with exposure to manufacturing. Bachelor's degree in Engineering or Business with a strong mechanical aptitude (preferred). Enginee...

Promoted
Crunchy Data Solutions, Inc.
Columbia, South Carolina

Crunchy Data is the leading provider of trusted open-source PostgreSQL and enterprise PostgreSQL technology and is looking to hire a talented Operations Engineer to join Crunchy Data. PostgreSQL's active development community, proven architecture, and reputation for reliability, data integrity, ...