Data Engineer - San Antonio Lake Flato Architects is a nationally recognized architectural design firm based in San Antonio, Texas. Lake Flato is seeking a Data Engineer to help build and maintain the firm's evolving AI infrastructure initiatives. The ideal candidate will work alongside our Systems Integrator to support our office-wide, multi-year Data & AI Initiative, focusing on the buildout of the firm's Lakehouse as our primary in-house data engineering resource. The Role This is a foundational, build-from-the-ground-up role with strong ownership. You will report to the Data & AI Lead and work closely with the integrator team, our IT infrastructure partner, and colleagues who specify the tools the firm needs. Cloud infrastructure, deployment, and CI/CD are owned by our IT infrastructure partner, this is a focused data-engineering role, not a platform-operation one, and you can put your attention on building reliable, well-documented data pipelines.Core Responsibilities:• Build the Lakehouse pipeline using automated ingestion pipelines that pull data from our project management/ERP system, HR systems, design and BIM tools, and CRM on a scheduled basis• Build the Bronze layer-a raw, unmodified copy of source data that preserves the original as it is transformed downstream• Build the Silver layer-cleaned and standardized data: removing duplicates, standardizing fields, handling missing values, and joining related datasets across systems• Build the Gold layer-business-ready, aggregated datasets structured for specific use cases such as project profitability, utilization analytics, and fee benchmarking• Develop the serving layer and API integrations that connect Gold data to dashboards and AI applications• Monitor pipeline health on a regular cadence and resolve failures, data anomalies, and feed disruptions • Maintain data lineage documentation so any output can be traced back to its source• Apply the firm's data quality and governance standards-surfacing issues rather than masking them• Add new data sources and extend transformation logic as the initiative grows• Internalize and document the architecture • Work alongside the systems integrator during the build, treating every session as a chance to understand why architectural decisions are made-not just what to build• Produce clear documentation alongside the build, including plain-language runbooks that let others maintain and extend the system• By the end of the engagement, be able to add sources, modify logic, and troubleshoot failures independentlyRequired Qualifications:• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related technical field-or equivalent practical experience. • 4+ years of hands-on data engineering experience building and maintaining production data pipelines (ingestion, transformation, and scheduled automation). • Strong proficiency in Python and SQL• Working experience with a cloud data environment-Microsoft Azure preferred; AWS or GCP experience readily transferable• Familiarity with layered or medallion data architecture patterns (Bronze/Silver/Gold or equivalent staged transformation models)• Experience integrating data from REST APIs and enterprise systems (ERP, finance, HR, or similar)• Demonstrated discipline in documentation-you write things down so others can maintain what you buildwww.lakeflato.com Preferred Qualifications:• Experience with platforms such as Databricks, Azure Synapse, or Microsoft Fabric• Exposure to an architecture, engineering, or professional-services ERP system (e.g., Deltek VantagePoint) or comparable project-based financial systems• Understanding of data governance practice-cataloguing, access controls, lineage, and quality standards• Experience building serving layers or APIs that feed dashboards and applications• AI-adjacent data engineering: experience standing up and maintaining vector stores and embedding pipelines, and serving curated data to LLM or AI applications through APIs• Interest in how data infrastructure connects to analytics and AI-not just moving data, but enabling what it powers• Experience working alongside an external systems integrator or consulting team and carrying a system forward independently afterwardAdditional Details:• Permanent, full-time position based in our San Antonio office, with on-site presence expected during the implementation engagement and a hybrid schedule thereafterCompensation & Benefits:• Competitive salary commensurate with experience and qualifications, and a comprehensive benefits package. Lake Flato is an equal opportunity employer committed to creating an inclusive workplace where all employees can thriveApplication: To be considered for this position, please submit the following to lfhr@lakeflato.com: • Format email with subject line 'Data Engineer'• Resume & Cover LetterWhen applying, please include responses to the following questions in your email: • How did you hear about Lake Flato?• Are you legally authorized to work in the U.S.?• Will you now or in the future require sponsorship for employment visa status?• Can you perform the essential functions of the job for which you are applying, with or without a reasonable accommodation?• What date are you available to start working? Please visit our website at www.lakeflato.com for more information on our firm, our culture and our people. Upon receipt, we will review and contact you should your qualifications meet our staffing needs. No phone calls, please.Target start: late July 2026