Analytics Engineer

Aperia; New York (NY); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Parental leave

Disability insurance

Education reimbursement

Fitness membership

Volunteer time off

Job summary

Aperia is seeking an Analytics Engineer to design the data foundation and analytics apps that empower decision makers across payments and compliance. You will own data pipelines end-to-end, build scalable analytics on a fast-moving team, and collaborate with business stakeholders to translate needs into reliable datasets.

Responsibilities include modeling, transforming data in Snowflake, and creating dashboards while ensuring data quality and governance.

Qualifications

• Bachelor's degree in computer science, engineering, analytics, or related field.
• 4+ years designing data models and pipelines and handling ad hoc analytics requests.
• Advanced SQL and Python.
• Strong Snowflake experience (ingestion, transformations, governance basics).

Responsibilities

• Designs the merchant data foundation and models and owns end-to-end analytics on a small, high-impact team.
• Builds analytics pipelines with testing and monitoring built in.
• Turn business needs into reliable data pipelines and consumable datasets.
• Applies dimensional/semantic modeling and optimizes data for downstream users.
• Supports senior stakeholders with ad hoc analytics requests.
• Integrates source systems into Snowflake and troubleshoots data quality issues.

Skills

Analytical thinking

Ownership

Problem-solving

Multitasking

Education

Bachelor's degree in computer science, engineering, or related field

Tools

Snowflake

SQL

Python

Job description

Summary

Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia’s clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path.

Job Title

Analytics Engineer

What a Successful Analytics Engineer Does

• Designs the merchant data foundation and model while it's still taking shape, builds analytics from scratch, and owns things end-to-end on a small, high-impact team
• Goes deep into datasets, shapes infrastructure, and sees your work drive the business directly in a fast-moving environment
• Operates across the full spectrum of data engineering (~10%), analytics engineering (~80%), and business intelligence (~10%), and serves as a core technical point of contact for business stakeholders
• Handles regular and evolving ad hoc requests - often from senior management with imperfect data
• Turns high level requirements and business needs into reliable pipelines that make analytics frictionless for downstream users
• Does dimensional/semantic data modeling, performance tuning, and creates clean, consumable datasets
• Designs, builds, and operates analytics pipelines with testing and monitoring built in
• Builds analytics from the ground up while the underlying data model is still being defined, and helps define it
• Discovers, evaluates, and onboards new datasets; manages connectors and ingestion methods
• Integrates source systems into our central Snowflake platform and troubleshoots failures, latency, and data quality issues
• Handles unpredictable, deep ad hoc requests in a high paced environment with imperfect data

Requirements

• Bachelor's degree in computer science, business analytics, engineering, or a related field
• 4+ years designing data models and pipelines, and handling ad hoc analytics requests
• Advanced SQL and Python
• Strong Snowflake experience (ingestion, transformations, access patterns, governance basics) and can operate independently
• Proven ability to break ambiguous problems into structured, solvable components
• Strong analytical and systems-design skills
• High-ownership, proactive, and able to run multiple workstreams and follow through without constant direction
• Someone who digs into the why behind a request - a real problem-solver who delivers

Preferred Qualifications

• Snowflake SnowPro Core Certification
• Familiarity with geospatial data
• CI/CD pipeline development experience
• Experience in a fast-paced, technical, and contribution-oriented environment

Eligibility Requirements

• Must be willing to submit to a background investigation and drug test as part of the selection process.
• This position is not eligible for visa sponsorship. Applicants must have authorization to work in the country without the need for sponsorship.

Job Type

• Full-Time

Schedule

• Monday to Friday

Location

On-site in New York City, NY

Benefits

• Health insurance
• Health savings account
• Dental insurance
• Vision insurance
• 401(k) matching
• Life insurance
• Paid time off
• Parental leave
• Disability insurance
• Childcare assistance
• Education reimbursement
• Fitness membership
• Volunteer time off

This job description is not intended to be all-inclusive. An employee may also perform other reasonable related business duties as assigned by their immediate supervisor or management. Principals only.