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.
Top Skills
What We Do
Bridgehead IT offers customized, end-to-end technology services that support businesses of all sizes. We’re different because we take a holistic approach to the technology needs of our clients. We focus on building partnerships to solidify relationship with a foundation based on securing and assessing long-term needs.
Our services are engineered to meet the specific objectives of each client. That starts with having the right people who are experts in their field to develop solutions that support our clients. Thoughtful solutions, not quick fixes.
Our clients range from publicly traded, global entities to mid-sized local businesses.
We are a premier partner with Microsoft, HPE, Cisco, VMWare and many others.
Our full range of technology based business solutions include:
• App Development • Change Management • Cloud Solutions • Conference Room Design • Cyber Security And Compliance • Digital Signage Displays • Endpoint Detection And Response • IT Cost Control • IT Service Delivery • Infrastructure Services • Microsoft 365 • Project Management • Structured Cabling
MISSION: Bridgehead IT offers customized, end-to-end technology services that support businesses of all sizes. We’re different because we take a holistic approach to the technology needs of our clients and empower our staff to become leaders in their fields.
VISION:
Perpetuate, grow, and diversify by expanding further into a multi-specialty technology and business consulting firm in the field of Information Technology.
Core Values:
ACT WITH INTEGRITY.
SAFEGUARD OBJECTIVITY.
VALUE EVERY EMPLOYEE.
STRIVE FOR EXCELLENCE.
Why Work With Us
Co-founders Wes Bunch, CEO, and Chris Brandvik, COO, have over 35 years of collective experience in the Information Technology sector. They established Bridgehead IT in 1999 with the goal of building a new kind of technology company — a whole new generation run by fresh thinkers who offer a forward vision.
Gallery
