Senior Data Engineer

Position Title:

Department:

Reports To:

Work Location:

Position Summary

The Senior Data Engineer is responsible for designing, building, and maintaining robust data pipelines and data warehouse solutions. This role works closely with data analysts, software engineers, and other stakeholders to ensure data is clean, reliable, and accessible for business insights. The ideal candidate will bring strong ETL development experience, proficiency in SQL and cloud platforms, and the ability to work independently on complex data initiatives.

Essential Duties and Responsibilities

Key responsibilities include, but are not limited to:

• Design, develop, and maintain scalable ETL pipelines and data warehousing solutions using tools such as SQL Server, Redshift, and dbt.
• Write advanced SQL queries and scripts for data extraction, transformation, and loading from various structured and unstructured data sources.
• Collaborate with cross-functional teams to understand data needs and translate them into scalable and maintainable solutions.
• Maintain and improve existing data models and data flows; implement changes to optimize performance and reduce redundancy.
• Ensure data integrity, accuracy, and security throughout the data lifecycle.
• Work with cloud-based platforms (preferably AWS) to deploy, manage, and monitor data services and pipelines.
• Develop and maintain technical documentation related to data models, workflows, and systems architecture.
• Perform data profiling, cleansing, and validation to ensure high-quality and reliable analytics.
• Contribute to architectural decisions for enterprise data infrastructure and mentor junior data engineers when needed.
• Stay current with emerging trends and technologies in data engineering and recommend improvements to the existing infrastructure.

Supervisory Responsibilities

• None

Qualifications

To perform this role successfully, candidates must meet the following requirements:

Education & Experience

• Bachelors degree in Computer Science, Information Technology, Data Science, or a related field (preferred).
• Minimum of 5 years of hands-on experience as a Data Engineer or in a similar role.
• Proven expertise in

  data warehousing

  concepts and

  ETL development tools

  (any).
• Proficient in

  SQL Server

  ,

  AWS Redshift

  , and

  dbt

  for data modeling and transformation.
• Strong

  SQL scripting

  capabilities and

  intermediate Python programming

  skills.
• Exposure to

  cloud technologies

  , particularly

  AWS

  (e.g., S3, Lambda, Glue, Redshift, etc.).
• Experience in working with large-scale datasets and optimizing data pipelines for performance and scalability.
• Strong analytical thinking and problem-solving skills with the ability to work in a fast-paced environment.

Language Skills

• Ability to read and comprehend technical documentation and business requirements.
• Ability to draft moderately complex documentation and communicate clearly with team members.
• Strong verbal communication skills for both technical and non-technical audiences.

Mathematical Skills

• Ability to apply mathematical concepts such as fractions, percentages, ratios, and proportions to practical problems.
• Comfort with data profiling, statistics, and data quality metrics.

Reasoning Ability

• Strong ability to troubleshoot and resolve complex data issues.
• Ability to understand and solve ambiguous problems through structured thinking and analysis.
• Ability to handle multiple priorities and deliver quality outcomes within tight deadlines.

Computer Skills

• Proficient in database technologies, SQL coding, and ETL tools.
• Comfortable using cloud services (AWS preferred), version control systems (Git), and development tools.
• Familiarity with workflow orchestration tools (e.g., Airflow, Prefect) is a plus.

Certificates and Licenses

• None required (Relevant AWS certifications are a plus)

Travel Requirements

• Minimal travel (up to 5%) may be required for meetings, training, or conferences.

Information Security & Privacy Compliance

• Ensure the secure handling and storage of sensitive data.
• Implement access control protocols and data encryption standards.
• Maintain compliance with privacy regulations (e.g., GDPR, HIPAA) and internal data governance policies.
• Participate in regular security audits and proactively address vulnerabilities in data systems.

Position Description Acknowledgment

By signing below, I acknowledge that I have reviewed and understood the duties and expectations associated with the Senior Data Engineer role. I understand that responsibilities may evolve over time and agree to communicate with my supervisor for clarification as needed. I also understand that performance evaluations and compensation may be tied to fulfilling these responsibilities.

Employees Name (Print):

Employees Signature:

Managers Signature:

Version 1 Effective June 2025