Sr Data Engineer

WHO WE ARE

Apex Fintech Solutions (AFS) powers innovation and the future of digital wealth management by processing millions of transactions daily, to simplify, automate, and facilitate access to financial markets for all. Our robust suite of fintech solutions enables us to support clients such as Stash, Betterment, SoFi, and Webull, and more than 20 million of our clients' customers. 

Collectively, AFS creates an environment in which companies with the biggest ideas in fintech are empowered to change the world. As a global organization, we have offices in Austin, Dallas, Chicago, New York, Portland, Belfast, and Manila.

If you are seeking a fast-paced and entrepreneurial environment where you'll have the opportunity to make an immediate impact, and you have the guts to change everything, this is the place for you. 

AFS has received a number of prestigious industry awards, including:

• 2021, 2020, 2019, and 2018 Best Wealth Management Company - presented by Fintech Breakthrough Awards

• 2021 Most Innovative Companies - presented by Fast Company

• 2021 Best API & Best Trading Technology - presented by Global Fintech Awards

ABOUT THIS ROLE

Apex Fintech Solutions is seeking a Senior Data Engineer to play a key role on our Billing engineering team, responsible for designing, developing, and maintaining high-quality software solutions. You will leverage your experience and expertise to contribute to the software development lifecycle, from requirements analysis and implementation to testing and deployment. You will collaborate with team members and cross-functional partners to deliver scalable, reliable, and efficient software products that meet the needs of our users and business objectives.

Duties/Responsibilities

• Design and maintain data pipelines for the classic billing system using Python and MS SQL Server, including ETL processes, data transformations, stored procedures, and scheduled jobs to support financial reporting and reconciliation workflows

• Build and optimize SQL queries and database objects in MS SQL Server for the legacy system, writing complex queries, views, indexes, and stored procedures to support billing operations, reporting requirements, and data quality checks

• Develop Python-based automation and data processing scripts to integrate the classic system with modern platforms, handling data extraction, transformation, validation, and loading between MS SQL Server and cloud-based systems like BigQuery and PostgreSQL

• Support data migration and modernization efforts from the classic billing system to the new microservices platform, designing data mapping strategies, building migration tools, and ensuring data integrity across systems during the transition

• Create and maintain data quality monitoring, implementing validation checks, reconciliation processes, and alerting mechanisms to ensure accuracy and consistency of billing data across both classic and modern systems

• Collaborate with engineering and finance teams to understand data requirements, provide data insights for billing calculations and settlements, and support ad-hoc analysis and reporting needs using SQL, Python, and BI tools

• Document data schemas, pipelines, and processes for both classic and modern systems, creating technical documentation, data dictionaries, and runbooks to support system knowledge transfer and operational continuity

Education and/or Experience

• Bachelor's degree in Computer Science, Engineering, or related field (or equivalent work experience) required; advanced degree preferred

• 5+ years of experience in software development with a strong proficiency in one or more programming languages, including Java, Python

• Experience with automated testing frameworks and methodologies for backend services

• Experience contributing to epics and participating in technical direction and implementation strategy for projects

• Experience with CI/CD (Continuous Integration/Continuous Deployment) pipelines and tools, automating build, test, and deployment processes

• Experience with cloud platforms (e.g., AWS, Azure, GCP)

• Experience with SQL including the ability to write complex queries and optimise database performance, e.g. Postgres, MS SQL Server

• Experience in financial services a plus

Required Skills/Abilities

• Ability to troubleshoot production systems, diagnose issues, and implement effective solutions to ensure system reliability and availability

• Strong problem-solving abilities, analytical thinking, and attention to detail

• Effective communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and contribute to technical discussions

• Knowledge of Agile software development methodologies and tools (e.g., Scrum, Kanban, Jira)

Work Environment

• This job operates in a hybrid work environment 2 day per week.

#engineering #full-time #mid-senior #LI-DM1 #AFSUK

​Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Our Rewards

We offer a robust package of employee perks and benefits, including a market-leading salary with an annual bonus, 28 days of annual leave plus 10 Northern Ireland national holidays, a training and development budget, and a pension matched up to 7%. Our benefits also cover private health insurance for medical, dental, and optical care, and life insurance. We emphasize work-life balance with flexible working hours, parental leave, a modern city center office, and a hybrid work schedule that allows for greater flexibility by partially working from home. Additional perks include monthly catered lunches, unlimited drinks and snacks, hackathon events, poker tournaments, and a charitable matching gift program.

EEO Statement

Apex Fintech Solutions is an equal opportunity employer that does not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, veteran status, marital status, or any other protected characteristic. Our hiring practices ensure that all qualified applicants receive fair consideration without regard to these characteristics.

Disability Statement

Apex Fintech Solutions is committed to creating an inclusive and accessible workplace for all candidates, including those with disabilities. We are dedicated to ensuring equal employment opportunities and providing reasonable accommodations to qualified individuals with disabilities. If you require reasonable accommodations to participate in the application or interview process, please submit your request via the Candidate Accommodation Requests Form. We will work with you to provide the necessary accommodations to ensure your full participation in our hiring process.