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

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.

• 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 Big Query 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

• 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 topics 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

• 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)

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

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…