Senior Data Architect

Job Type: Contract

Job Overview:

Requirement/Must Have:

• Bachelor s or College degree in Computer Science or related field.
• Minimum 8 years of experience designing, planning, implementing, and supporting enterprise solution databases in large and complex enterprise IT environments.
• Minimum 8 years of experience documenting enterprise solution databases.
• Minimum 8 years of experience with enterprise architecture principles, standards, best practices, tools, policies, and processes.
• Minimum 8 years of experience working as a Data Architect within enterprise IT environments.
• Strong knowledge of enterprise data modeling and database architecture.
• Experience translating business requirements into scalable data structures and engineering specifications.
• Strong analytical, problem-solving, and communication skills.

Experience:

• Experience reducing duplication across reporting templates and regulatory data structures.
• Experience defining and maintaining canonical data elements and Unified Business Object models.
• Experience designing normalized and denormalized data structures for analytics and governance requirements.
• Experience developing object/fact tables and dimension tables for enterprise analytics solutions.
• Experience supporting advanced analytics use cases including trend analysis, anomaly detection, and predictive modeling.
• Experience documenting architectural decisions and maintaining traceability.
• Experience collaborating with data engineering and analytical teams during implementation and validation activities.
• Experience planning schema evolution and maintaining analytical continuity.

Responsibilities:

• Identify overlapping parameters, metrics, and calculations across monitoring and reporting templates.
• Define and maintain canonical data elements to support consistent interpretation and reuse.
• Rationalize reporting templates to reduce redundancy and prepare them for standardized ingestion.
• Design analytics-ready data structures including fact and dimension tables.
• Lead and steward Unified Business Object models across regulatory domains.
• Define structural standards including row-level grain, attribute consistency, versioning, and historical traceability.
• Document and maintain architectural decisions and rationale.
• Translate finalized data model designs into engineering specifications including schemas, ingestion contracts, transformation expectations, and data quality rules.
• Provide architectural guidance to data engineering teams during pipeline development.
• Review implementations for structural conformance and identify deviations from canonical model intent.
• Design data structures supporting aggregation, trend analysis, anomaly detection, and future machine learning use cases.
• Balance normalization and denormalization strategies for governance and performance requirements.
• Maintain structured feedback loops with data analysts to guide schema evolution and improvements.
• Plan for future schema evolution to support evolving environmental monitoring and reporting needs.

Should Have:

• TOGAF certification preferred.
• Experience designing enterprise architecture database plans and models in large enterprise environments.
• Experience performing threat and risk assessments and presenting mitigation recommendations to senior leadership.
• Experience using architecture modeling tools such as PowerDesigner, ER Studio, ERwin, BPwin, or Rational Rose.
• Experience managing Agile application development projects.
• Experience with enterprise business intelligence tools such as Microsoft Power BI.
• Experience providing leadership, planning, estimation, and solution presentations.

Skills:

• Data Architecture.
• Enterprise Data Modeling.
• Database Design and Documentation.
• Data Governance.
• Canonical Data Modeling.
• Analytics and Reporting Structures.
• Data Engineering Collaboration.
• Power BI.
• Agile Methodologies.
• Enterprise Architecture Principles.

Qualification and Education:

• Bachelor s or College degree in Computer Science or related field required.
• TOGAF certification preferred.