Data Engineer

Responsibilities

• Develop and maintain integration pipelines in Azure Data Factory that move and transform data between SaaS platforms and the company's data layer.
• Write, optimize, and maintain T‑SQL code — stored procedures, views, functions, and triggers — supporting both integration logic and downstream reporting.
• Design and maintain normalized relational data models in Azure SQL Database and SQL Server.
• Build and maintain integrations with vendor REST APIs, including authentication, pagination, retry logic, and structured error handling.
• Support and extend SQL Server components used for real‑time and complex‑payload integration scenarios, including C# / CLR stored procedure modules.
• Partner with business analysts to expose curated data through Power BI, leveraging the existing SQL layer (views, functions, semantic models) in a sustainable client/server model.
• Monitor pipelines and integrations for reliability, performance, and data quality; investigate and resolve issues as they arise.
• Document data flows, data models, and integration interfaces.
• Participate in code reviews, technical discussions, and small‑team planning.

• 3+ years of professional experience in a data engineering or database development role.
• Advanced T‑SQL skills: complex queries, stored procedures, performance tuning, indexing strategies.
• Solid experience with Azure SQL Database and / or Microsoft SQL Server.
• Hands‑on experience with Azure Data Factory, or an equivalent ETL / orchestration platform (SSIS, Informatica, Talend, Fivetran, etc.).
• Working knowledge of relational data modeling, including normalized OLTP design.
• Experience integrating with REST APIs and OData services, including OAuth 2.0 / API key authentication, pagination, and error handling.
• Strong written and verbal communication skills, with the ability to translate business requirements into data structures.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent practical experience.

Proficient in developing and maintaining integration pipelines using Azure Data Factory and optimizing T‑SQL for data transformation and reporting. Experienced in relational data modeling and integrating with REST APIs to ensure data quality and performance.