Data Engineer

Role Overview

We are looking for aData/BI Engineerto join our technology team and contribute to the development and maintenance of scalable data solutions. This role involves working with structured and unstructured data, integrating new sources, and optimizing data pipelines to support reporting and analytics.

The position focuses onSQL Serveras the primary database technology, with an increasing emphasis oncloud-based services, includingAWS tools such as Athena, Glue, and SageMaker.

This role will play a key part in enabling data-driven decision-making by ensuring efficient data processing and high-quality insights.

Key Responsibilities

• Collaborate with stakeholders to define and scope data processing requirements.
• Develop and maintain data pipelines usingSQL, SSIS, AWS Glue, and Athena.
• Optimize and debugSQL Serverprocedures, functions, and queries for performance and efficiency.
• Work with internal teams to integrate data from various sources into a centralized data platform.
• Ensure data quality, consistency, and reliability for business intelligence and analytics.
• Stay updated on cloud-based data pipeline tools and big data technologies to enhance scalability and performance.

Skills & Experience

Required:

• Strong proficiency inSQL Server (T-SQL, Query Optimization, Indexing, Partitioning).
• Experience withSSISfor data integration and ETL processes.
• Scripting knowledge usingPowerShell.
• Familiarity withdata modelingand designing efficient database structures.
• Strong problem-solving and analytical skills.

Preferred:

• Experience withAWS services(Glue, Lambda, Redshift, Athena).
• Knowledge ofbig data technologiesand scalable data architectures.
• Proficiency inPythonfor data processing and automation.

Ideal Candidate Traits

Successful candidates typically:

• Have a passion for working with data and solving complex challenges.
• Are curious, detail-oriented, and proactive in optimizing data solutions.
• Demonstrate strong time management and prioritization skills.
• Adapt well to changing requirements and business needs.
• Communicate effectively and collaborate across teams.
• Take ownership of their work and seek continuous improvement.