Job Type
Full-time, Permanent. Hybrid – occasional travel to Bristol office.
The Role
The Integrations Engineer will work within the Integrations Engineering team to design, build and maintain data integrations, API integrations, data pipelines and integration infrastructure for Bupa Dental UK business.
Responsibilities
* In-depth understanding of integration engineering fundamentals, including data integration, API integration and ETL/ELT best practices.
* Experience designing and supporting RESTful API integrations, webhooks and event-driven integration patterns.
* Mastered the tools needed to debug and diagnose issues in data pipelines, APIs and system-to-system integrations.
* The ability to understand data flows, API contracts and relationships between source systems, operational applications and the data warehouse.
* Subject matter expertise in at least one area of the data platform or integration landscape.
* Good understanding of data modelling concepts, dimensional design and integration data mapping.
* Develop and maintain ETL/ELT pipelines and system integrations with appropriate logging, monitoring and error handling.
* Design, build and support API integrations using REST APIs, JSON/XML payloads and secure authentication patterns.
* Write efficient SQL queries and stored procedures.
* Participate in code reviews, API design reviews and integration testing, providing constructive feedback.
* Create and maintain documentation for data pipelines, API specifications, data mappings and integration processes.
* Given a well-defined integration requirement, design and implement a complete end-to-end data or API integration solution.
Skills & Experience – Essential
* Microsoft Azure Data Services (Data Factory, Data Lake Storage)
* T-SQL and SQL Server
* ETL/ELT concepts, data integration patterns and pipeline development
* API integration experience, including REST APIs, JSON/XML payloads, webhooks and API testing tools
* Understanding of secure integration practices, including authentication, authorisation, secrets management, logging and monitoring
* Data modelling fundamentals, data mapping and data quality validation
* Git version control
* Understanding of data warehouse concepts
* Problem-solving and analytical skills
Skills & Experience – Desirable
* Azure Synapse Analytics
* Python for Integrations Engineering
* Power BI fundamentals
* Snowflake Data Cloud
* Azure DevOps
* Data quality tools and frameworks
* Healthcare or dental industry experience
About You
* Show initiative and offer assistance to team members when needed
* Deliver feedback in a constructive manner
* Work collaboratively with senior engineers, incorporating feedback as needed
* Communicate data and integration issues, risks and progress clearly to technical and non-technical stakeholders
* Help maintain data catalogues, API documentation and integration design records
Benefits
* 25 days holiday, plus the option to buy more.
* Discounts in over 7,000 retailers, discounted gym membership and discounted dental insurance (of course).
* Health Trust – our bespoke employee private healthcare plan, providing healthcare cover with no medical underwriting for colleagues and their families.
* Access to remote GP and nurse services, physiotherapy, and mental health support.
* MyHealthcare Allowance, an annual allowance which is redeemable against a menu of Bupa healthcare products.
* Early access to your earned wages through Wagestream.
* Cycle to work scheme.
* And many more, just ask.
Equal Opportunity
Bupa Dental Care is an equal opportunities employer.
#J-18808-Ljbffr