Job Title
Analytics Engineer
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.
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.
Recruiters please don't contact this job poster. DO NOT contact us with unsolicited services or offers.
Skills Required
- Bachelor's degree in computer science, business analytics, engineering, or related field
- 4+ years designing data models and pipelines and handling ad hoc analytics requests
- Advanced SQL
- Advanced Python
- Strong Snowflake experience (ingestion, transformations, access patterns, governance basics)
- Proven ability to break ambiguous problems into structured, solvable components
- Strong analytical and systems-design skills
- High ownership, proactive, able to run multiple workstreams and follow through without constant direction
- Willing to submit to a background investigation and drug test
- Authorization to work in the country without the need for visa sponsorship
- Snowflake SnowPro Core Certification
- Familiarity with geospatial data
- CI/CD pipeline development experience
- Experience in a fast-paced, technical, contribution-oriented environment
What We Do
Your success is our objective. We have more than a decade of service providing business intelligence solutions and applying extensive experience and knowledge to your business requirements. From its roots in the finance, banking, and the payments industry, Aperia expanded to become the preeminent provider of ETL, BI, and hosted solutions in a variety of industries. Aperia platforms scale with industry, processing massive volumes on time. The Software as a Service (SaaS) platforms support millions of end users creating billions of transactions per day, all with the speed and reliability required for business. The company’s management combines more than a century in finance, business consulting, rapid growth, and governance, as well as business intelligence, the company’s core function. Aperia knows that data holds power and providing the precision tools to release that power from data in any format is our passion, skill, and talent.
