Bridgehead IT
Data Integration Engineer
San Antonio, Texas
Sponsorship not specifiedDetected 43 days ago
JavaScriptPythonPHPSQLBigQuerySnowflakeAzureData EngineeringCommunicationCollaborationMentoringWarehouse Management System
About the role
- You'll integrate diverse sources (databases, APIs, SaaS apps, flat files), and engineer performant ELT/ETL in the cloud.
- Troubleshoot data pipeline failures and errors.
- Respond to and troubleshoot errors identified.
Responsibilities
- 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.
- Optimize workflows for performance, reliability, and scalability (partitioning, parallelism, incremental loads, CDC, idempotency, retry/rollback).
- Manage Datawarehouse platforms such as Azure Synapse and Snowflake
- 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).
- SQL & Python Support
Requirements
- The ideal candidate will possess the following abilities, attributes, experience and
- The ideal candidate will possess the following abilities, attributes, experience and skills:
- Strong understanding of DWaaS database architecture and ability to design and build optimal data processing pipelines.
- Ability to work individually and as a team.
- 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.
- Provide technical guidance and mentoring for other team members.
Nice to have
- Write clean, maintainable code (primarily SQL, plus Python or PHP when required for custom connectors, transformations, or microservices).
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.
- Experience with Python/JavaScript or other scripting languages is a plus.
- Provide Support and troubleshooting for data platforms.
- Manage and prioritize multiple assignments.
- Good communication and cross functional skills.
Apply directly at Bridgehead IT →Create a free account for alerts like thisView Bridgehead IT immigration profile
This listing is sourced directly from Bridgehead IT's careers page and normalized into a canonical job model.