Data Architect

Job Title: Data Architect
Job ID: 87346
Location: Mound, Texas

What you will be doing:

• Define and implement end-to-end data architecture standards, including data modeling, data integration, metadata management, and governance across the enterprise.

• Design scalable data models across Bronze, Silver, and Gold layers of a Databricks Lakehouse using Delta Lake and Unity Catalog and DLT.

• Lead data modeling efforts for critical business domains (e.g., finance, materials, logistics, customer) with deep understanding of SAP source systems such as ECC or S/4HANA (e.g., tables like ACDOCA, BKPF, BSEG, MARA, LIPS).

• Collaborate with data engineers to optimize ingestion and transformation processes across streaming and batch pipelines.

• Establish canonical models and semantic layers that power downstream BI tools and self-service analytics.

• Define and enforce data quality, data lineage, and data security policies in coordination with governance teams.

• Work with business stakeholders, product managers, and analysts to translate analytical use cases into high-quality data models and architecture patterns.

• Provide architecture oversight and best practices guidance on data integration tools (e.g., Fivetran), data cataloging, and performance optimization.

• Review and approve physical and logical data model changes across teams to ensure consistency and maintain architectural integrity.

• Partner with IT security and compliance teams to implement PHI/PPI/PII masking strategies and data access controls via Unity Catalog.

• Adheres specifically to all company policies and procedures, Federal and State regulations, and laws.

• Display dedication to position responsibilities and achieve assigned goals and objectives.

• Always represent the Company in a professional manner and appearance.

• Understand and internalize the Company’s purpose,

• Display loyalty to the Company and its organizational values.

• Display enthusiasm and dedication to learning how to be more effective on the job and share knowledge with others.

• Work effectively with co-workers, internal and external customers and others by sharing ideas in a constructive and positive manner; listen to and objectively consider ideas and suggestions from others; keep commitments; keep others informed of work progress, timetables, and issues; address problems and issues constructively to find mutually acceptable and practical business solutions; address others by name, title, or other respectful identifier, and respect the diversity of our work force in actions, words, and deeds.

• Comply with the policies and procedures stated in the Injury and Illness Prevention Program by always working in a safe manner and immediately reporting any injury, safety hazard, or program violation.

• Ensure conduct is consistent with all Compliance Program Policies and procedures when engaging in any activity on behalf of the company. Immediately report any concerns or violations

What you must have:

• Bachelor’s Degree in a related field or four (4) years relevant experience in lieu of degree.

• Deep understanding of SAP ERP data models, especially core financials, logistics, and materials domains.

• Expertise in dimensional modeling, star/snowflake schemas, and modern data warehousing patterns.

• Proficiency in SQL and Python, with the ability to guide data engineers on best practices.

• Strong understanding of data governance, lineage, and security frameworks.

• Ability to communicate architectural concepts clearly to both technical and non-technical audiences.

• Exposure to SAP BW, S/4HANA CDS views, or native SAP data warehousing solutions.

• Familiarity with Power BI, Tableau, or Looker and how they integrate with semantic models.

• Understanding of AI/ML and how architecture supports model deployment and data science workflows.

• Must have seven (7) years [eleven (11) for non-degreed candidates] of experience in data architecture or data engineering, with a focus on enterprise-scale data.

• Strong hands-on experience with Databricks, including Delta Lake, Unity Catalog, and Lakehouse architecture.

• Proven experience in conceptual, logical, and physical data modeling using tools like ER/Studio, Erwin, Lucidchart, or dbt.

• Experience working in cloud environments such as Azure, AWS, or GCP.

• Strong leadership presence with the ability to influence across engineering, analytics, and business teams.

• Highly analytical, structured thinker with a passion for elegant, scalable solutions.

• Excellent collaboration and communication skills.

• Comfortable managing ambiguity and driving clarity in complex environments.

• Must have strong organizational skills

• Must have a detail orientation and the proven ability to prioritize work

• Must have effective verbal and written communication skills

• Must have the ability to work with limited supervision and as part of a team

• Sound decision-making abilities

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com