Analytics Engineer

About this role

<p><strong>Job Title</strong></p> <p>Analytics Engineer</p> <p><strong>Summary</strong></p> <p>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.</p> <p><strong>What&nbsp;</strong><strong>a Successful Analytics Engineer Does</strong></p> <ul> <li>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</li> <li>Goes deep into datasets, shapes infrastructure, and sees your work drive the business directly in a fast-moving environment</li> <li>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</li> <li>Handles regular and evolving ad hoc requests - often from senior management with imperfect data</li> <li>Turns high level requirements and business needs into reliable pipelines that make analytics frictionless for downstream users</li> <li>Does dimensional/semantic data modeling, performance tuning, and creates clean, consumable datasets</li> <li>Designs, builds, and operates analytics pipelines with testing and monitoring built in</li> <li>Builds analytics from the ground up while the underlying data model is still being defined, and helps define it</li> <li>Discovers, evaluates, and onboards new datasets; manages connectors and ingestion methods</li> <li>Integrates source systems into our central Snowflake platform and troubleshoots failures, latency, and data quality issues</li> <li>Handles unpredictable, deep ad hoc requests in a high paced environment with imperfect data</li> </ul> <p><strong>Requirements</strong></p> <ul> <li>Bachelor's degree in computer science, business analytics, engineering, or a related field</li> <li>4+ years designing data models and pipelines, and handling ad hoc analytics requests</li> <li>Advanced SQL and Python</li> <li>Strong Snowflake experience (ingestion, transformations, access patterns, governance basics) and can operate independently</li> <li>Proven ability to break ambiguous problems into structured, solvable components</li> <li>Strong analytical and systems-design skills</li> <li>High-ownership, proactive, and able to run multiple workstreams and follow through without constant direction</li> <li>Someone who digs into the why behind a request - a real problem-solver who delivers</li> </ul> <p><strong>Preferred&nbsp;</strong><strong>Q</strong><strong>ualifications</strong></p> <ul> <li>Snowflake SnowPro Core Certification</li> <li>Familiarity with geospatial data</li> <li>CI/CD pipeline development experience</li> <li>Experience in a fast-paced, technical, and contribution-oriented environment</li> </ul> <p><strong>Eligibility Requirements</strong></p> <ul> <li>Must be willing to submit to a background investigation and drug test as part of the selection process.</li> <li>This position is not eligible for visa sponsorship. Applicants must have authorization to work in the country without the need for sponsorship.</li> </ul> <p><strong>Job Type</strong></p> <ul> <li>Full-Time</li> </ul> <p><strong>Schedule</strong></p> <ul> <li>Monday to Friday</li> </ul> <p><strong>Location</strong></p> <p>On-site in New York City, NY</p> <p><strong>Benefits </strong></p> <ul> <li>Health insurance&nbsp;</li> <li>Health savings account</li> <li>Dental insurance</li> <li>Vision insurance</li> <li>401(k) matching</li> <li>Life insurance</li> <li>Paid time off</li> <li>Parental leave</li> <li>Disability insurance</li> <li>Childcare assistance</li> <li>Education reimbursement</li> <li>Fitness membership</li> <li>Volunteer time off</li> </ul> <p><em>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. </em></p> <p><em>Recruiters please don't contact this job poster. DO NOT contact us with unsolicited services or offers.</em></p> <p>&nbsp;</p>