Data Engineer
Trading Technologies International, Inc.24 days ago
New York, NY, USAMid Level
Responsibilities
- Develop, maintain, and optimize complex Microsoft SQL Server queries, stored procedures, functions, views, and data processing workflows.
- Design scalable Snowflake data models, SQL transformations, loading processes, and analytical workloads.
- Migrate large volumes of data and processing from SQL Server to Snowflake and redesign existing SQL Server logic as needed.
- Build and maintain ETL/ELT pipelines using SQL, Python, and Apache Airflow or similar orchestration tools.
- Develop AWS-based data ingestion and processing workflows, including workflows using 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, implementation teams, product teams, and DevOps.
- Support and enhance Transaction Cost Analysis products and develop new functionality for trade, market, benchmark, and financial data.
- Use AI-assisted development tools such as Claude Code while independently validating generated code for correctness, security, performance, and maintainability.
Requirements
- 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 Microsoft SQL Server experience, 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 is desirable.
- Experience with Apache Airflow or similar orchestration technologies is desirable.
- Experience with Git, CI/CD, Liquibase, and automated deployment processes is desirable.
- Experience with data quality, reconciliation, and data governance is desirable.
- Knowledge of capital markets, trading, market data, or financial systems is desirable.
- Experience with Transaction Cost Analysis or other financial analytics is desirable.
- Snowflake or AWS certification is desirable.
Benefits
- Medical, dental, and vision insurance.
- Flexible Spending Accounts and Health Savings Accounts.
- 401(k) retirement plan.
- Pre-tax transit and parking benefits.
- Hybrid work arrangement with three days in the office and two remote days per week.
- 22 days of paid time off per year with rollover options.
- One paid volunteering day per year and two professional development days per year.
- Additional PTO during milestone anniversary years and a paid holiday schedule with early dismissal.
- Generous parental leave for all parents, including adoptive parents.
- Budget for technology accessories and office equipment.
- Backup child and pet care and tutoring services.
- Milestone anniversary bonuses.
- Cell phone stipend and subsidy contributions.
- Gym membership and health and wellness contributions.
- Discounted healthcare premiums and healthy meal delivery subsidies.
About Trading Technologies International, Inc.
Trading Technologies International builds a SaaS platform for professional trading, order management, market data and risk, connecting clients to major global exchanges for listed derivatives and other asset classes. Its products span execution tools, algorithmic and automated trading, surveillance and post-trade services, delivered over a low‑latency network with colocation footprints across North America, Europe and Asia. Founded in 1994 and headquartered in Chicago, the company is privately held under 7RIDGE ownership.