Senior Software 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

At Apex Fintech Solutions, we're transforming how businesses leverage data to drive strategic decisions in the fintech and wealth tech community. Our Risk & Regulatory Data Products team is at the heart of this mission, building and maintaining scalable cloud infrastructure that powers our analytics capabilities and supports our clearing and custody services.

As a Senior Data Engineer on our team, you will design, build, and optimize robust, cloud-native data pipelines that transform raw financial data into valuable business insights. This role focuses initially on building data products that enable reporting and analytics for our Trade Processing System, in addition to building out performant data systems for a wide variety of use cases in the Margin, Risk, Regulatory Tech, and Securities Lending domains. You'll work closely with these cross-functional teams, along with Data Experience and Analytics to understand requirements and implement scalable solutions that support our growing data needs.

This role offers an exciting opportunity to work with cutting-edge cloud technologies while solving complex data challenges in a fast-paced financial services environment. 

Key Responsibilities:

Data Pipeline Development 

• Design, develop, and maintain scalable ETL/ELT pipelines for our enterprise data warehouse and data lake
• Implement robust data processing systems that support our Data Products  
• Build systems to handle real-time and batch data updates using change data capture (CDC) tools such as HVR, Dataflow, Datastream
• Build and extend existing systems that process, store, and move streaming and batch data from SQL-based sources to centralized GCP storage and/or cloud data warehousing platforms
• Build complex views that enable convenient and intuitive access to datasets

Quality & Optimization 

• Implement comprehensive data quality checks and monitoring to ensure accuracy and reliability
• Optimize existing data workflows for improved performance, cost efficiency, and scalability
• Ensure system quality, stability, and maintainability across all solutions
• Build and maintain data models that support transactional workloads, analytics and reporting needs

Support and Maintenance 

• Optimize existing data workflows for improved performance and efficiency
• Build, maintain, and extend data models that support realtime transactions, analytics and reporting needs
• Work with a continuous improvement mindset
• Provide Level 2 support and be part of on-call rotations

Collaboration & Communication 

• Communicate effectively with teams across many product domains
• Participate in code reviews and contribute to best practices for data engineering
• Document architectural diagrams and technical specs for data processes and workflows

Compliance & Security 

• Ensure security and privacy of data in accordance with financial-sector compliance requirements
• Implement appropriate access controls and data governance practices
• Support data operations across development, testing, and production environments
• Perform regular audits and attestations for data protection and compliance

Leadership 

• Gather requirements from stakeholders and translate them into technical solutions
• Advocate for architectural designs, explain tradeoffs, and recommend optimal paths forward
• Ser