Sr Data Engineer

This role involves designing and managing relational database schemas, including tables, views, indexes, and partitioning strategies to ensure high performance. The candidate will be responsible for building and maintaining ETL/ELT data pipelines that extract, transform, and load structured data from operational databases into data warehouses or analytics platforms. A key focus will be on optimizing SQL queries, managing database locks, and tuning memory and storage utilization to enhance overall system efficiency. The role also requires implementing data quality and governance measures such as data validation, schema enforcement, data masking, and backup/recovery procedures. Collaboration with data analysts, data scientists, and software engineers is essential to maintain reliable and low-latency data availability.

Key Responsibilities

- Design and manage relational database schemas, including tables, views, indexes, and partitioning strategies to support high-performance data operations.
- Develop and maintain ETL/ELT pipelines to efficiently extract, transform, and load structured data from operational sources into data warehouses or analytics stores.
- Optimize slow-running SQL queries, handle database locks, and tune memory and storage components such as buffer pools and connection pooling to improve database performance.
- Implement data quality controls and governance processes, including data validation checks, schema enforcement, data masking, and backup and recovery procedures to ensure data integrity and security.
- Collaborate closely with data analysts, data scientists, and software engineers to guarantee reliable, timely, and low-latency access to data for various business needs.

Required Qualifications

- Proven experience in designing and managing relational database schemas and structures for high-performance environments.
- Strong expertise in building and maintaining ETL/ELT pipelines for data integration and warehousing.
- Proficiency in SQL query optimization, database locking mechanisms, and tuning of memory/storage utilization.
- Hands-on experience with data quality frameworks, including validation, schema enforcement, data masking, and backup/recovery strategies.
- Ability to work collaboratively with cross-functional teams including data analysts, data scientists, and software engineers to deliver dependable data solutions.

Preferred Qualifications and Benefits

- Experience with advanced database partitioning strategies and performance tuning in large-scale environments.
- Familiarity with modern data warehousing and analytics platforms.
- Strong problem-solving skills and attention to detail in maintaining data accuracy and governance.
- Opportunity to work in a dynamic team environment focused on data-driven decision-making and innovation.

This position offers the chance to contribute to critical data infrastructure and collaborate with diverse technical teams to support business intelligence and analytics initiatives.