Senior Analytics Engineer: 26-02767

Akraya, Inc.; New York (NY); On-site; USD 90,000 - 96,000; Full time

Job summary

Akraya, Inc. is seeking a data analytics professional in New York, NY to design, build, and maintain robust data pipelines for analytics and BI. You will leverage advanced SQL and orchestration tools to transform data and ensure quality across the lifecycle.

The role emphasizes data modeling principles, Snowflake warehousing, and Python scripting for automation, with a 6+ month W2 contract in New York.

Qualifications

• 4+ years of experience with Airflow and SQL.
• Proficiency in Snowflake data warehousing.
• Experience with data modeling best practices.

Responsibilities

• Develop and optimize complex SQL queries for data transformation.
• Build and manage ETL/ELT pipelines using orchestration tools.
• Design and implement efficient data models for analytical purposes.
• Write Python scripts for automation and pipeline enhancement.
• Ensure data quality and integrity throughout the data lifecycle.

Skills

Data Analytics

Data Modeling

Tools

Airflow

SQL

Snowflake

Python

Job description

Primary Skills: Data Analytics (Advanced), Airflow (advanced), SQL (advanced), Snowflake (advanced), Data Modeling (advanced)

Contract Type: W2

Duration: 6+ Months

Location: New York, NY

Pay Range: $65 to $70/hour on W2

This role focuses on designing, building, and maintaining robust data pipelines to support analytics and business intelligence. You will leverage advanced SQL and orchestration tools to transform and move data efficiently. A strong understanding of data modeling principles is essential for creating scalable and maintainable data solutions.

Key Responsibilities

• Develop and optimize complex SQL queries for data transformation.
• Build and manage ETL/ELT pipelines using orchestration tools.
• Design and implement efficient data models for analytical purposes.
• Write Python scripts for automation and pipeline enhancement.
• Ensure data quality and integrity throughout the data lifecycle.

Must-Have Skills

• 4+ years of experience with Airflow and SQL.
• Proficiency in Snowflake data warehousing.
• Experience with data modeling best practices.

Domain / Industry Experience: Experience in financial crime compliance domains such as BSA/AML, transaction monitoring, or KYC/EDD is preferred.

ABOUT AKRAYA

Akraya is an award-winning IT staffing firm consistently recognized for our commitment to excellence and a thriving work environment. Most recently, we were recognized Stevie Employer of the Year 2025, SIA Best Staffing Firm to work for 2025, Inc 5000 Best Workspaces in US (2025 & 2024) and Glassdoor's Best Places to Work (2023 & 2022)! Industry Leaders in Tech Staffing As Talent solutions provider for Fortune 100 Organizations, Akraya's industry recognitions solidify our leadership position in the IT staffing space.