Logo
Alignity Solutions

Senior Data Engineer

Alignity Solutions, Orlando, Florida, us, 32885

Save Job

Overview Do you love a career where you Experience, Grow & Contribute at the same time, while earning at least 10% above the market? If so, we are excited to have bumped onto you. Learn how we are redefining the meaning of work and be a part of the team raved by Clients, Job‑seekers and Employees.

Role Sr.Data Engineer – Orlando, FL – 10+ Years

Key Responsibilities

Design, develop, and maintain ELT data pipelines using Apache Airflow, DBT, and Snowflake in an AWS environment.

Write modular, production‑grade Python code for data ingestion, transformation, and automation tasks.

Develop complex DBT models (incremental models, snapshots) with reusable macros and documentation.

Implement data pipeline orchestration and job scheduling using Apache Airflow (MWAA).

Optimize SQL queries and Snowflake performance (partitioning, clustering, caching).

Integrate and process data from multiple sources, including REST APIs.

Set up and maintain monitoring and logging using AWS CloudWatch.

Follow best practices for cloud security, including IAM roles, encryption, and access control.

Participate in version control and CI/CD processes using Git.

Collaborate with cross‑functional teams in a client‑facing capacity.

Required Technical Skills Data Engineering & ELT:

Strong experience with Snowflake (data modeling, optimization, clustering, caching).

Deep SQL expertise (complex joins, CTEs, window functions, subqueries, performance tuning).

Proficient with DBT (Data Build Tool) – creating and managing DBT models, macros, tests, and documentation.

Version controlling with Git and setting up CI/CD for DBT pipelines.

Programming:

Strong hands‑hand skills in Python – Pandas, NumPy, scripting for automation and API integration, Jinja/DBT macros.

AWS Cloud Platform:

AWS S3, Lambda, Redshift, Glue, Athena, IAM, KMS, CloudWatch.

Workflow Orchestration:

Expertise in Apache Airflow (preferably MWAA) – DAG creation, monitoring, integration with DBT, S3, Redshift.

Must‑Have Qualifications

10+ years overall IT experience with at least 5 years in Data Engineering.

Client‑facing experience with excellent verbal and written communication.

Ability to work independently with minimal supervision (Individual Contributor).

Proven track record of delivering large‑scale ELT solutions in cloud environments.

Preferred / Optional Experience

Experience with MWAA and AWS Glue for ETL development.

Understanding of data governance and quality frameworks.

Familiarity with financial domain data structures, compliance, and reporting.

Benefits Visit us at https://alignity.io/careers. Alignity Solutions is an Equal Opportunity Employer – M/F/V/D.

#J-18808-Ljbffr