Enterprise Data Architect Consultant

cginfinity; Houston (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

CG Infinity is seeking an Enterprise Data Architect Consultant to design, build, and lead the implementation of a scalable enterprise data Lakehouse. You will unify multiple systems into a single data ecosystem to drive analytics and business decision-making.

The role requires hands-on leadership in data governance, MDM, and standards, with expertise across ERP/CRM and cloud data platforms. You will guide discovery sessions and define a strategic data roadmap for impactful outcomes.

Qualifications

• 8+ years in data architecture, data engineering, or enterprise data management roles.
• Proven experience building enterprise data Lakehouse from scratch across multiple systems.
• Strong data modeling, ETL/ELT design, and data integration expertise.
• Hands-on experience with cloud data platforms (Azure, AWS, or GCP).
• Expertise in Data Governance, MDM, and data quality management.

Responsibilities

• Design and implement a scalable enterprise data Lakehouse from inception.
• Define end-to-end data architecture (ingestion, transformation, storage, integration, consumption).
• Establish standards, frameworks, and best practices aligned with business and tech strategies.
• Evaluate technologies to support long-term scalability.
• Lead discovery sessions with stakeholders to identify use cases and dependencies.
• Translate business requirements into data models, flows, and architectures.
• Develop and maintain a data roadmap with phases, milestones, and deliverables.
• Oversee data pipelines connecting ERP, CRM, operational systems, and third-party platforms.
• Define data models (conceptual, logical, physical) to support analytics and reporting.
• Establish data quality frameworks and ensure data reliability and integrity.
• Lead Master Data Management initiatives and establish governance policies.
• Communicate technical concepts to non-technical stakeholders; lead cross-functional teams.
• Drive adoption of data solutions through change management and alignment.

Skills

Data architecture

Data modeling

ETL/ELT design

Data governance

MDM

Cloud platforms

Python

Stakeholder leadership

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Databricks

Azure Synapse

Power BI

Tableau

Job description

Enterprise Data Architect Consultant

Position Summary

CG Infinity is seeking a strategic and hands-on Enterprise Data Architect to design, build, and lead the implementation of a scalable, enterprise-wide data Lakehouse. This role will be responsible for developing a modern data architecture from the ground up, integrating multiple systems and business units into a unified data ecosystem that drives analytics, reporting, and business decision-making.

The ideal candidate combines deep technical expertise with strong business acumen, capable of leading discovery efforts, defining priorities, and ensuring data solutions are aligned with organizational goals. This individual will also play a key leadership role in establishing data governance, master data management (MDM), and enterprise data standards.

Key Responsibilities

Enterprise Data Architecture & Strategy

• Design and implement a scalable, secure, and high-performance enterprise data Lakehouse from inception.
• Define the end-to-end data architecture, including data ingestion, transformation, storage, integration, and consumption layers.
• Establish architectural standards, frameworks, and best practices aligned with business and technology strategies.
• Evaluate and recommend technologies (cloud platforms, ETL/ELT tools, data lakes, Lakehouses) to support long-term scalability.

Cross-Functional Discovery & Requirements Alignment

• Lead discovery sessions with business and technical stakeholders to identify high-value use cases, priorities, and dependencies.
• Translate business requirements into technical data models, data flows, and architecture designs.
• Ensure alignment between data solutions and business objectives, including KPIs, reporting, and analytics needs.
• Develop and maintain a data roadmap with clearly defined phases, milestones, and deliverables.

Data Lakehouse Development & Delivery

• Oversee development of integrated data pipelines that connect disparate systems (ERP, CRM, operational systems, third-party platforms).
• Define and implement data models (conceptual, logical, physical) to support analytics and reporting.
• Establish data quality frameworks and ensure reliability, consistency, and integrity of enterprise data.
• Ensure performance optimization and scalability of the data environment.

Data Governance & Master Data Management

• Develop and implement enterprise data governance policies, standards, and controls.
• Lead Master Data Management (MDM) initiatives to standardize key business entities across systems.
• Define data ownership, stewardship, and accountability models across business units.
• Ensure compliance with regulatory, security, and data privacy requirements.

Leadership & Stakeholder Engagement

• Act as a trusted advisor to executive leadership, including the CTO and business leaders.
• Communicate complex technical concepts clearly to non-technical stakeholders.
• Lead cross-functional teams, including data engineers, analysts, and business users.
• Drive adoption of data solutions across the organization through change management and stakeholder alignment.

Required Qualifications

• 8+ years of experience in data architecture, data engineering, or enterprise data management roles.
• Proven experience building an enterprise data Lakehouse from scratch spanning multiple systems and business units.
• Strong experience with data modeling, ETL/ELT design, and data integration frameworks.
• Hands-on experience with cloud data platforms (e.g., Azure, AWS, or GCP).
• Demonstrated expertise in:
  • Python Development
  • Data Governance frameworks
  • Master Data Management (MDM)
  • Data quality and metadata management
• Experience leading discovery sessions and requirements gathering workshops with senior stakeholders.
• Strong understanding of enterprise systems (ERP, CRM, operational apps) and integration patterns.
• Excellent communication, facilitation, and leadership skills.

Preferred Qualifications

• Experience in consulting environments or multi-client, multi-business unit organizations.
• Industry experience in oil & gas or chemical sectors, with an understanding of upstream, midstream, downstream, or refining operations.
• Familiarity with modern data tools (e.g., Snowflake, Databricks, Azure Synapse, Power BI, Tableau).
• Experience implementing data lakes, Lakehouse architectures, or hybrid data ecosystems.
• Knowledge of Agile and iterative delivery methodologies.
• Relevant certifications (e.g., Azure Data Architect, AWS Data Analytics, DAMA CDMP).

Success Metrics

• Successful delivery of a fully operational enterprise data Lakehouse aligned with business priorities.
• Measurable improvement in data accessibility, quality, and reporting capabilities.
• Adoption of data governance and MDM practices across business units.
• Delivery of a clear project roadmap with defined milestones, timelines, and outcomes.
• Positive stakeholder feedback on alignment between business needs and technical solutions.