Data Engineer - Mid

Job Description

Position Overview:

We are seeking a skilled and motivated Data Engineer / Database Engineer to support our

growing team providing an enterprise data warehouse and visualization environment. The

ideal candidate will have hands-on experience with Microsoft SQL Server, ETL pipelines,

and cloud-based data ingestion tools-especially AWS Glue. You will be responsible for

maintaining and enhancing our database systems, enabling near real-time data pipelines

from source databases (Oracle, SQL, etc) to Microsoft SQL Server, and ensuring secure,

efficient, and scalable data access.

Key Responsibilities:

• Support and maintain Microsoft SQL Server environments, with flexibility to adapt to

alternative database platforms as the architecture evolves.

• Design and implement data pipelines using AWS Glue for efficient and scalable data

ingestion.

• Build and maintain a near real-time data ingestion framework from Oracle

databases to Microsoft SQL Server.

• Develop and manage ETL processes, including incremental/delta-based extraction

of raw data from source systems.

• Build and optimize relational database schemas, ensuring performance, scalability,

and data integrity.

• Implement and manage fine-grained roles and permissions in SQL Server to enforce

data security and access control policies.

• Work closely with Data Analysts, Software Engineers, and other stakeholders to

ensure data systems meet business requirements.

• Monitor and troubleshoot data pipelines and workflows to ensure reliability and

consistency.