The Role
Develop and optimize SQL Server and Snowflake data solutions, migrate workloads to the cloud, and build ETL/ELT pipelines using SQL, Python, Airflow, and AWS. Responsibilities include performance tuning, data validation, reconciliation, monitoring, production troubleshooting, and support for transaction cost analysis products using large-scale financial, trade, and market data.
Summary Generated by Built In
We are looking for a Data Engineer with strong Microsoft SQL Server and Snowflake experience to join our Data & Analytics engineering team.
This role is ideal for an engineer who enjoys working with large-scale data, complex SQL, data pipelines, and production systems and wants to play a key role in modernizing a large SQL Server-based data platform to Snowflake and AWS.
You will work across both our existing SQL Server environment and our modern cloud data platform, developing new capabilities while helping migrate and optimize existing data processing.
Tech Stack
- Languages: SQL, Python, C#; scripting experience
- Databases: Microsoft SQL Server, Snowflake
- Data Engineering: ETL/ELT, Apache Airflow, data pipelines
- Cloud: AWS, including S3 and other AWS data services
- Development: Git, CI/CD, Liquibase, automated testing and deployment
- Data: Market data, trade data, transaction cost analysis, and financial data
Key Responsibilities
- Develop, maintain, and optimize complex SQL Server queries, stored procedures, functions, views, and data processing workflows.
- Design and develop scalable Snowflake data solutions, including data models, SQL transformations, loading processes, and analytical workloads.
- Participate in the migration of large volumes of data and processing from SQL Server to Snowflake.
- Analyze existing SQL Server logic and translate or redesign it for Snowflake where appropriate.
- Build and maintain ETL/ELT pipelines using SQL, Python, and workflow orchestration tools such as Apache Airflow.
- Develop data ingestion and processing workflows using AWS, including S3.
- Perform SQL Server and Snowflake performance tuning, including query optimization, execution plans, indexing, statistics, warehouse sizing, and workload optimization.
- Build data validation and reconciliation processes to ensure migrated and transformed data is accurate and complete.
- Troubleshoot production data issues, identify root causes, and implement reliable long-term solutions.
- Implement monitoring, logging, alerting, and operational controls for critical data pipelines.
- Collaborate with software engineers, service managers and implementation team, product teams, and DevOps.
- Support and enhance existing Transaction Cost Analysis (TCA) products and develop new functionality.
- Work with large-scale trade, market, benchmark, and financial data.
Skills, Knowledge and Expertise
Essential Skills & Experience
Educational Background:
Educational Background:
- Bachelor’s degree in Computer Science, Data Engineering, or a related field.
Technical Skills:
- Hands-on experience with Snowflake and AWS Cloud services (particularly S3 and data services).
- Strong hands-on SQL development experience.
- Python & C# scripting experience
- Strong experience with Microsoft SQL Server, including complex queries, stored procedures, performance tuning, and troubleshooting.
- Experience working with large datasets and production data systems.
- Strong analytical and problem-solving skills.
Desirable Skills & Experience
- Experience migrating SQL Server workloads to Snowflake or another cloud data platform.
- Experience with Apache Airflow or similar orchestration technologies.
- Experience with Git, CI/CD, Liquibase and automated deployment processes.
- Experience with data quality, reconciliation, and data governance.
- Knowledge of capital markets, trading, market data, or financial systems.
- Experience with Transaction Cost Analysis (TCA) or other financial analytics.
- Snowflake or AWS certification.
AI-Assisted Development:
- We encourage engineers to use modern AI-assisted development tools, such as Claude Code to accelerate development, debugging, testing, refactoring, and migration work.
- Candidates should understand how to use AI effectively while independently validating generated code for correctness, security, performance, and maintainability.
Benefits
Competitive Benefits & Perks We offer a comprehensive benefits package designed to support your well-being, growth, and work-life balance.
- Health & Financial Security:
- Medical, Dental, and Vision insurance
- Flexible Spending Accounts (FSA) & Health Savings Accounts (HSA)
- 401(k) retirement plan
- Pre-tax transit and parking benefits
- Time Off & Flexibility:
- Enjoy the best of both worlds: the energy and collaboration of in-person work, combined with the convenience and focus of remote days. This is a hybrid position requiring three days of in-office collaboration per week, with the flexibility to work remotely for the remaining two days. Our hybrid model is designed to balance individual flexibility with the benefits of in-person collaboration, enhanced team cohesion, spontaneous innovation, hands-on mentorship opportunities and strengthens our company culture.
- 22 days of Paid Time Off (PTO) per year, with the option to roll over unused days.
- One dedicated day per year for volunteering.
- Two professional development days per year to allow uninterrupted professional development.
- An additional PTO day added during milestone anniversary years.
- Robust paid holiday schedule with early dismissal.
- Generous parental leave for all parents (including adoptive parents).
- Work-Life Support & Resources:
- Budget for tech accessories, including monitors, headphones, keyboards, and other office equipment.
- Backup child and pet care, as well as tutoring services.
- Milestone anniversary bonuses.
- Wellness & Lifestyle Perks:
- Stipend and subsidy contributions toward personally-owned cell phones
- Contributions for gym memberships and health/wellness initiatives.
- Discounted healthcare premiums.
- Healthy meal delivery program subsidies.
Trading Technologies (www.tradingtechnologies.com) is a global capital markets platform services company providing market-leading technology for the end-to-end trading operations of Tier 1 banks, brokerages, money managers, hedge funds, proprietary traders, Commodity Trading Advisors (CTAs), commercial hedgers, and risk managers. With its roots in listed derivatives, the Software-as-a-Service (SaaS) company delivers “multi-X” solutions, with “X” representing asset classes, functions, workflows, and geographies. This multi-X approach features trade execution services across futures and options, fixed income, foreign exchange (FX), and cryptocurrencies, augmented by solutions for data and analytics, including transaction cost analysis (TCA); quantitative trading; compliance and trade surveillance; clearing and post-trade allocation; and infrastructure services. The award-winning TT platform ecosystem also helps exchanges deliver innovative solutions to their market participants and technology companies to distribute their complementary offerings to Trading Technologies’ clients.
Trading Technologies is backed by leading global investment firms Thoma Bravo, one of the world’s largest and most experienced software investors, and 7Ridge, a global growth equity firm focused on technology-enabled businesses.
This investment supports Trading Technologies’ continued focus on product innovation, platform scalability, and long-term growth for customers and partners worldwide.
Trading Technologies (TT) is an equal-opportunity employer. Equal employment has been, and continues to be, a required practice at the Company. Trading Technologies’ practice of equal employment opportunity is to recruit, hire, train, promote, and base all employment decisions on ability rather than race, color, religion, national origin, sex/gender orientation, age, disability, sexual orientation, genetic information, parental status, veteran, or any other protected status. Additionally, TT participates in the E-Verify Program for US offices.
About
Trading Technologies is a Software-as-a-Service (SaaS) technology platform provider to the global capital markets industry. The company’s award-winning TT® platform connects to the world’s major international exchanges and liquidity venues in listed derivatives alongside a growing number of asset classes, including fixed income and cryptocurrencies. The TT platform delivers advanced tools for trade execution and order management, market data solutions, analytics, trade surveillance, risk management, and infrastructure services to the world’s leading sell-side institutions, buy-side firms, and exchanges. The company’s blue-chip client base includes Tier 1 banks as well as brokers, money managers, hedge funds, proprietary traders, Commodity Trading Advisors (CTAs), commercial hedgers, and risk managers. These firms rely on the TT ecosystem to manage their end-to-end trading operations. In addition, exchanges utilize TT’s technology to deliver innovative solutions to their market participants. TT also strategically partners with technology companies to make their complementary offerings available to Trading Technologies’ global client base through the TT ecosystem.
Skills Required
- Bachelor's degree in Computer Science, Data Engineering, or a related field
- Hands-on experience with Snowflake and AWS cloud services, particularly S3 and data services
- Strong hands-on SQL development experience
- Python and C# scripting experience
- Strong experience with Microsoft SQL Server, including complex queries, stored procedures, performance tuning, and troubleshooting
- Experience working with large datasets and production data systems
- Strong analytical and problem-solving skills
- Experience migrating SQL Server workloads to Snowflake or another cloud data platform
- Experience with Apache Airflow or similar orchestration technologies
- Experience with Git, CI/CD, Liquibase, and automated deployment processes
- Experience with data quality, reconciliation, and data governance
- Knowledge of capital markets, trading, market data, or financial systems
- Experience with Transaction Cost Analysis or other financial analytics
- Snowflake or AWS certification
- Ability to use AI-assisted development tools while independently validating code for correctness, security, performance, and maintainability
Trading Technologies Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Trading Technologies and has not been reviewed or approved by Trading Technologies.
-
Healthcare Strength — Health coverage is described as competitive, with multiple plan options, discounted premiums, and wellness initiatives such as gym subsidies and healthy meal programs.
-
Leave & Time Off Breadth — Paid time off is portrayed as generous, combining substantial PTO, paid holidays, flexible schedules, and added allowances like training days and volunteer time.
-
Parental & Family Support — Family supports include generous parental leave for primary caregivers, backup care for children, adults, and pets, adoption assistance, and dedicated spaces for new mothers.
Trading Technologies Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Trading Technologies creates professional trading software, infrastructure and data solutions for a wide variety of users. Be aware of fraudulent job postings: It has come to our attention that individuals pretending to represent Trading Technologies are posting fake job ads on LinkedIn and possibly other job boards. These individuals conduct candidate interviews via Skype and extend offers, likely with the intent to collect personal information such as banking information, social security number or date of birth. They use a Gmail email address that is not affiliated with Trading Technologies. Only emails using a tradingtechnologies.com or trade.tt email address are authentic. Although we use third party recruiting agencies on a case-by-case basis, all candidates speak with a staff member who has a valid company email address before any offers are extended or personal information collected. Our open positions are posted on BuiltIn and on the Careers page of our website.
Why Work With Us
Cited by Crain's and Built In Chicago as one of Chicago’s best places to work, Trading Technologies is a pioneering financial technology firm that constantly pushes boundaries in the trading industry. TT is a highly collaborative and culture-first organization that fosters an environment of creativity and camaraderie to achieve results.
Gallery
