Data Integration Engineer

11 hours ago

San Antonio, Texas, United States Bridgehead IT Full time

Position Summary:

The Data Integration Engineer will own the design, build, and operation of scalable data pipelines and warehouse models that power analytics and operational reporting. You'll integrate diverse sources (databases, APIs, SaaS apps, flat files), and engineer performant ELT/ETL in the cloud. You'll collaborate closely with analytics, app dev, and business stakeholders to turn requirements into trusted, production-grade datasets.

Duties/Responsibilities:

Data Pipeline Development

  • Design and implement scalable ETL/ELT pipelines (batch and near-real-time) to ingest from databases, APIs, SaaS, and flat files into Snowflake, Azure Synapse, or similar.
  • Build integrations using tools such as Azure Data Factory (ADF), Fivetran, CData Sync, and Boomi; extend with custom code where needed.
  • Write clean, maintainable code (primarily SQL, plus Python or PHP when required for custom connectors, transformations, or microservices).
  • Optimize workflows for performance, reliability, and scalability (partitioning, parallelism, incremental loads, CDC, idempotency, retry/rollback).
  • Manage Datawarehouse platforms such as Azure Synapse and Snowflake
  • Troubleshoot data pipeline failures and errors.

Data Warehouse Management

  • Develop and maintain data models, schemas, views, and stored procedures; manage staging/core/mart layers and source to target mappings.
  • Implement data quality validation and monitoring (null/dup/range checks, schema drift detection, reconciliation).
  • Respond to and troubleshoot errors identified.
  • Apply warehouse best practices (clustering/partitioning, cost governance, role-based access, tagging/lineage).

SQL & Python Support

  • Complete complex SQL queries, refactors (window functions, CTE chains), and performance tuning (explain plans, pruning, join strategy).
  • Create and/or troubleshoot Python notebooks (packaging, scheduling, secret mgmt) and integration into pipelines.

 Collaboration & Documentation

  • Partner with data analysts and stakeholders to clarify requirements and acceptance criteria and translate into source to target and technical designs.
  • Maintain technical specs, data flow diagrams, and operational procedures; contribute to standards and reusable patterns.

Qualifications:

The ideal candidate will possess the following abilities, attributes, experience and skills:

  • 4+ years' experience in Data Warehousing and Data Engineering.
  • Strong experience with Data Warehouse as a Service (DWaaS) platforms (Snowflake, BigQuery, etc).
  • Strong SQL skills and ability to write queries and data extracts.
  • Experience working with different database types
  • Experience working with and troubleshooting different ETL tools such as Azure Data Factory, Boomi, Fivetran, and CData Sync.
  • Strong understanding of DWaaS database architecture and ability to design and build optimal data processing pipelines.
  • Demonstrated skill in designing highly scalable ETL processes with complex data transformations, data formats including data cleansing, data quality assessment, error handling and monitoring.
  • Design, develop, manage, and monitor complex ETL data pipelines and support it through all environment runways.
  • Experience with Python/JavaScript or other scripting languages is a plus.
  • Provide Support and troubleshooting for data platforms.
  • Manage and prioritize multiple assignments.
  • Ability to work individually and as a team.
  • Provide technical guidance and mentoring for other team members.
  • Good communication and cross functional skills.

Bridgehead IT is proud to be an equal opportunity workplace and is an affirmative action employer.

  • Software Integration Engineer

    11 hours ago

    San Antonio, Texas, United States Cymertek Full time

    Software Integration EngineerLOCATIONSan Antonio, TX 78208CLEARANCETS/SCI Full Poly (Please note this position requires full U.S. Citizenship)KEY SUMMARYWe are seeking a highly motivated and detail-oriented Software Integration Engineer to join our team. In this role, you will be responsible for ensuring seamless integration of software systems, components,...

  • Data Engineer

    2 weeks ago

    San Antonio, Texas, United States Food Safety Net Services Full time $80,000 - $150,000 per year

    About The RoleWe are seeking an experienced Data Engineer / Database Administrator with a strong background in the healthcare or laboratory industry to design, build, and maintain secure, compliant, and high-performance data systems. This role requires expertise in the Microsoft technology stack, including Azure, Synapse Analytics, and SQL Server, as well as...

  • Data Engineer w/ Accumulo

    2 days ago

    San Antonio, Texas, United States Sandoval Technology Solutions Full time

    The ideal candidate will have extensive experience with data integration, processing, and management, specifically utilizing Apache Nifi, RESTful APIs, Hadoop, Accumulo, and Elasticsearch.Key Responsibilities:Design, develop, and maintain data pipelines to support C2IE deployments.Utilize Apache NiFi for data ingestion, transformation, and routing.Develop...

  • VP, Data Engineering and Architecture

    1 week ago

    San Antonio, Texas, United States TaskUs Full time

    About TaskUs: TaskUs is a provider of outsourced digital services and next-generation customer experience to fast-growing technology companies, helping its clients represent, protect and grow their brands. Leveraging a cloud-based infrastructure, TaskUs serves clients in the fastest-growing sectors, including social media, e-commerce, gaming, streaming...

  • Data Engineer – AI

    2 weeks ago

    San Antonio, Texas, United States Guidehouse Full time $120,000 - $180,000 per year

    Job FamilyData Science ConsultingTravel RequiredUp to 25%Clearance RequiredAbility to Obtain Public TrustWhat You Will DoWe are seeking an experiencedData Engineerto join our growing AI and Data practice, with a dedicated focus on the Federal Civilian Agencies (FCA) market within the Communities, Energy & Infrastructure (CEI) segment. This individual will be...

  • Environmental Data Engineer

    2 weeks ago

    San Antonio, Texas, United States Grassroots Carbon Full time

    Position: Environmental Data Engineer / Machine Learning EngineerPosition Type: Full-TimeReports to: Jay Weeks, Director of Data & Soil ScienceRole OverviewAs a Data Engineer / Machine Learning Engineer, you will play a pivotal role in bridging the gap between experimental prototypes and scalable, production-ready systems. You'll spend approximately 50% of...

  • Senior Project Engineer, NA

    2 weeks ago

    San Antonio, Texas, United States Vantage Data Centers Full time $104,000 - $130,878 per year

    About Vantage Data CentersVantage Data Centers powers, cools, protects and connects the technology of the world's well-known hyperscalers, cloud providers and large enterprises. Developing and operating across North America, EMEA and Asia Pacific, Vantage has evolved data center design in innovative ways to deliver dramatic gains in reliability, efficiency...

  • Data and Application Integration Coordinator

    3 days ago

    San Marcos, Texas, United States San Marcos Consolidated Independent School District (SMCISD) Full time

    JOB TITLE: Data and Application Integration Coordinator WAGE/HOUR STATUS: ExemptREPORTS TO: Exec. Dir. of Technology ServicesDEPT./SCHOOL: District Wide DATE REVISED: October 2025PRIMARY PURPOSE:Design, manage, and optimize automated data integrations that connect district information systems, instructional applications, and identity management platforms....

  • Data Center Engineering Specialist

    6 days ago

    San Antonio, Texas, United States Valero Full time

    Valero is the best-in-class producer of essential fuels and products that are foundational to modern life. We invite you to join our ~10,000 employees to drive exceptional results for our company, the energy industry and our community.As aData Center Engineering Specialist,you will provide engineering design and support for electrical systems, Heating,...

  • Cleared Data Center Electrical Engineer, Field Engineering

    1 week ago

    San Antonio, Texas, United States Amazon Web Services (AWS) Full time

    DescriptionWe have an immediate opening for a Field Engineer in the San Antonio, TX region.As An Amazon Field Engineer, You Will Provide Full Life-cycle Support To AWS Data Centers From Design Inception Through Site Improvement And Maintenance. You Will Be The 'go To' Engineering Resource For Your Region When Technical Advice Is Needed, And Will Use Your...