Design and build end-to-end analytics pipelines and dimensional data models on Snowflake. Own data ingestion, transformations, testing, monitoring, and ad hoc analytics; partner with stakeholders to turn ambiguous business needs into reliable, consumable datasets.
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.
Similar Jobs
Fintech • Software • Financial Services
Build scalable data solutions and reconciliations to automate Compliance & Finance regulatory processes. Partner with stakeholders to translate requirements into designs, lead technical development, review code, and evolve standards for data pipelines and reporting.
Top Skills:
ArgoCi/CdDockerKubernetesMetaplanePythonRest ApisRetoolSnowflakeSQL
Cloud • Information Technology • Machine Learning
Design and build scalable data pipelines, models, and dashboards for supply chain KPIs. Partner with business stakeholders to enable forecasting, scenario planning, data governance, automation, and actionable reporting for leadership and projects.
Top Skills:
AirflowAlationAtlanBigQueryCollibraDbtFivetranInformaticaLlm/Ai AgentsLookerOracle NetsuitePower BIPythonRedshiftSap EccSap S/4HanaSnowflakeSQLTableau
Software
Build and own the data warehouse, analytics, and self-serve BI; define metrics and data models; prepare datasets for ML/AI features; partner cross-functionally to deliver dashboards, ensure data quality, and document systems as the companys first analytics hire.
Top Skills:
BigQueryDbtJavaScriptPythonRedshiftSigmaSnowflakeSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
