Gejits Infotech Inc needs a Senior Data Architect with minimum 12 Years extensive experience in designing, implementing, and maintaining data models and ETL processes to join our direct state client at Tallahassee, Florida.
Duration: Long Term.
Required Knowledge, Skills & Abilities
A. Knowledge
The Data Architect must possess demonstrated knowledge of:
a. Enterprise Data Warehouse (EDW) concepts and architectures.
b. Dimensional modeling (e.g., star schemas, snowflake schemas).
c. Relational database design principles.
d. Data integration and data pipeline architecture.
e. Data quality, data validation, and reconciliation methodologies.
f. Metadata management and data lineage concepts.
g. Master data management and reference data strategies.
h. Cloud-based data warehouse platforms (e.g., AWS, Azure, or similar).
i. Data governance frameworks and best practices.
j. Healthcare data concepts, including Medicaid claims, eligibility, providers, encounters, or managed care data.
k. Tools/Technologies: AWS, IBM InfoSphere, IBM Cognos, Splunk Enterprise, Tenable, Trend Micro, SortSite, QuerySurge, Erwin, ImageTrust, Semoss, SAS, PostgreSQL, Redshift, Aurora, DB Visualizer, DataStage.
B. Technical and Functional Abilities
The Data Architect must demonstrate the ability to:
a. Design and maintain scalable enterprise data warehouse architecture.
b. Develop conceptual, logical, and physical data models.
c. Translate business requirements into technical data designs.
d. Analyze source systems and map data into EDW structures.
e. Support data migration and modernization initiatives.
f. Review and validate vendor-created data models and database objects.
g. Identify gaps, inconsistencies, and architectural risks.
h. Partner with analytics, BI, and reporting teams to ensure data usability and availability.
i. Support data governance processes, including data standards and definitions.
j. Produce clear technical documentation and architecture diagrams.
C. Professional Competencies
The Data Architect must have the ability to:
a. Communicate complex technical concepts to non-technical stakeholders.
b. Work independently with minimal supervision.
c. Manage multiple priorities in a fast-paced environment.
d. Collaborate across bureaus, vendors, and leadership teams.
e. Adapt to evolving business and technical requirements.
f. Support Agency objectives related to data modernization and enterprise analytics.
D. Preferred Experience
a. Experience supporting Medicaid or public sector EDW implementations.
b. Experience transitioning EDW ownership.
c. Familiarity with CMS reporting, federal data submissions, or analytics support.
d. Experience working in hybrid vendor/state environments.