company

Data Integration Engineer at Bridgehead IT | San Antonio, TX

Bridgehead ITSan Antonio Texas United States
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Unlock Your Potential

Generate Job-Optimized Resume

One Click And Our AI Optimizes Your Resume to Match The Job Description.

Is Your Resume Optimized For This Role?

Find Out If You're Highlighting The Right Skills And Fix What's Missing

Experience Level

Experience

Qualifications

The ideal candidate will possess the following abilities, attributes, experience, and skills: 4+ years of experience in Data Warehousing and Data Engineering. Proven experience with Data Warehouse as a Service (DWaaS) platforms, including Snowflake and BigQuery. Exceptional SQL skills, with the ability to write complex queries and perform data extraction efficiently. Experience with ETL/ELT processes and data integration tools. Strong analytical skills and attention to detail. Ability to work collaboratively with cross-functional teams. Excellent problem-solving skills and the ability to troubleshoot and resolve issues. Experience with cloud environments and data modeling.

About the job

Position Summary:

The Data Integration Engineer will take the lead in designing, constructing, and maintaining robust data pipelines and warehouse models that drive insightful analytics and operational reporting. You will seamlessly integrate various data sources—including databases, APIs, SaaS applications, and flat files—and develop efficient ELT/ETL processes in a cloud environment. Collaboration with analytics teams, application developers, and business stakeholders will be key as you transform requirements into reliable, production-ready datasets.



Duties/Responsibilities:

Data Pipeline Development

  • Create and implement scalable ETL/ELT pipelines (both batch and near-real-time) to source data from databases, APIs, SaaS, and flat files into platforms like Snowflake and Azure Synapse.
  • Utilize integration tools such as Azure Data Factory (ADF), Fivetran, CData Sync, and Boomi, enhancing capabilities with custom code as necessary.
  • Produce clean, maintainable code primarily in SQL, with Python or PHP utilized as needed for custom connectors, transformations, or microservices.
  • Enhance workflows for optimal performance, reliability, and scalability through effective partitioning, parallel processing, incremental loads, CDC, idempotency, and robust retry/rollback strategies.
  • Oversee data warehouse platforms, including Azure Synapse and Snowflake, ensuring their smooth operation.
  • Identify and resolve data pipeline failures and errors promptly.

Data Warehouse Management

  • Develop and sustain data models, schemas, views, and stored procedures; proficiently manage staging, core, and mart layers along with source-to-target mappings.
  • Enforce data quality validation and monitoring practices (e.g., null/duplicate/range checks, schema drift detection, reconciliation).
  • Address and troubleshoot identified errors with efficiency.
  • Adopt and apply best practices in data warehousing (e.g., clustering, partitioning, cost governance, role-based access, tagging/lineage).

SQL & Python Support

  • Execute complex SQL queries, refactor existing queries (using window functions, CTE chains), and optimize performance through explain plans, pruning, and join strategies.
  • Create and troubleshoot Python notebooks, ensuring seamless integration into pipelines, including aspects like packaging, scheduling, and secret management.

Collaboration & Documentation

  • Work closely with data analysts and stakeholders to clarify requirements and acceptance criteria, translating them into detailed technical designs.
  • Maintain technical specifications, data flow diagrams, and operational procedures; contribute to documentation standards and reusable patterns.

About Bridgehead IT

Bridgehead IT is a dynamic technology company specializing in data solutions that empower organizations to harness the power of their data. With a focus on innovation and collaboration, we strive to deliver high-quality, scalable data integration and analytics solutions that drive business success.

Similar jobs

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.