Senior Data Engineer

We are seeking a senior, hands-on Senior Data Engineer who combines deep technical expertise in data pipelines, data modelling, and integration with the ability to guide standards and uplift delivery across the data ecosystem.

This role is accountable for designing and delivering scalable, reliable, and high-performance data solutions that support both analytics and application use cases. The successful candidate will play a key role in shaping the organization’s data architecture, ensuring that data is structured, governed, and accessible in a way that supports business decision-making and product capabilities.

What you'll do:

• Data Engineering Leadership, Standards & Quality
  • Act as a senior technical authority for data engineering, defining and enforcing best practices for pipeline design, data modelling, and data quality.
  • Contribute to and lead code reviews for SQL, ETL pipelines, and data transformations to ensure maintainability, performance, and consistency.
  • Establish standards for naming conventions, data structures, documentation, and version control across the data platform.
  • Mentor and guide team members on data engineering techniques, performance tuning, and design patterns.
  • Promote a culture of high-quality, testable, and observable data solutions.
• Data Pipeline Development & Integration
  • Design, develop, and maintain scalable data pipelines using Azure Data Factory (ADF), including pipelines, data flows, triggers, and parameterization.
  • Integrate data from APIs, flat files, databases, and cloud/on-prem systems.
  • Implement robust ingestion patterns for structured and semi-structured data (JSON, XML, CSV).
  • Ensure reliable, efficient, and secure movement of data across systems.
• Data Modelling & Transformation
  • Design and maintain both normalized (OLTP-aligned) and denormalized (analytical / reporting) data models.
  • Apply best practices in dimensional modelling (fact/dimension tables) as well as normalized relational design.
  • Implement transformations using SQL (T-SQL), stored procedures, and data flows to prepare analytics-ready datasets.
  • Ensure data models are scalable, reusable, and aligned with business requirements.
  • Manage historical data tracking, including slowly changing dimensions and auditability.
• Performance, Reliability & Scalability
  • Optimize SQL queries, ETL pipelines, and data storage for large datasets (millions+ rows).
  • Implement indexing strategies, partitioning, and efficient data access patterns.
  • Ensure pipelines are resilient with proper error handling, retry logic, and monitoring.
  • Design solutions that minimize impact on transactional systems (clear separation of OLTP and reporting workloads).
  • Proactively identify and resolve performance bottlenecks.
• Application & API
  
  https://www.executiveplacements.com/Jobs/S/Senior-Data-Engineer-1280494-Job-Search-04-14-2026-01-00-14-AM.asp?sid=gumtree