Application Support Engineer

Job Specification:
Application Support Engineer

Geode Capital Management is seeking a highly motivated Application Support Engineer Contractor to join our Technical Operations team. The ideal candidate will be responsible for supporting critical applications, troubleshooting issues, and maintaining operational excellence. This role requires a blend of technical expertise, analytical skills, and strong communication. This is a hybrid work environment opportunity located in Boston, Massachusetts with a weekly in office schedule of Tuesdays, Wednesdays and Thursdays and remote work availability on Mondays and Fridays.

• Experience supporting ETL pipelines and data loaders, including troubleshooting, job monitoring, and data flow validation
• Expertise in SQL for complex querying, and data integrity validation across datasets
• Monitor, support, and troubleshoot production applications to ensure high availability and performance
• Use Control-M and other orchestration tools to monitor and manage workflow processes effectively
• Operate and manage integrations using the Snaplogic platform (low code/no code) as part of day-to-day operations
• Work with Service Now or similar ticketing systems to track incidents, requests, and changes
• Manage and follow change management workflows for safe and compliant release deployments
• Write and troubleshoot SQL queries to identify and resolve data-related issues
• Utilize Linux to investigate application and system-level issues
• Apply knowledge of Terraform in AWS cloud environments for infrastructure as code
• Collaborate with development teams to implement and optimize modern observability platforms such as Grafana, Prometheus, or Data Dog for application monitoring and alerting
• Frequently participate in an on-call rotation, including weekends, to resolve production issues promptly.

• Strong experience with SQL for querying and troubleshooting data-related problems
• Expertise in SQL for complex querying, performance tuning, and data integrity validation across datasets
• Experience with Control-M or similar orchestration tools to monitor workflows
• Proficiency in Linux for command-line operations and log analysis
• Familiarity with Service Now or equivalent ticketing systems
• Proficiency in Git for version control and collaboration
• Hands‑on experience with Jenkins pipeline configuration and management
• Knowledge of Terraform and AWS cloud infrastructure
• Expertise in monitoring and observability tools such as Grafana, Prometheus, or Data Dog
• Understanding of financial services applications and terminology (preferred)
• Familiarity with Snaplogic or similar low‑code/no‑code integration platforms
• Experience supporting ETL pipelines and data loaders, including troubleshooting, job monitoring, and data flow validation
• Strong analytical and problem‑solving skills with the ability to work under pressure
• Excellent verbal and written communication skills for interacting with stakeholders at all levels

• Shift begins at 5:30 AM, ensuring coverage into later hours
• On‑call rotations, including weekends, are a frequent requirement; flexibility is essential

• Experience working in financial institutions or with financial applications
• Knowledge of operational best practices in regulated environments

Founded in 2001, Geode is headquartered in Boston’s financial district, the center of one of the world’s most vibrant finance and technology hubs and employs approximately 180 employees. Geode is a systematic asset manager providing core beta exposures across a range of equity and niche asset classes, with over $1 trillion in AUM. With a robust infrastructure and experienced investment professionals, Geode offers the scale of a large asset‑management firm with the benefits of a smaller organization.

Geode is proud to be an equal‑opportunity employer and supports a diversified work environment. Learn more about Geode at

Have you used any scheduler/orchestration/ETL software before in a production environment? If yes, which ones? (If the answer is no, please skip the candidate)

How would you find only unique values in a column?

Listen for: "SELECT DISTINCT."

What's the difference between INNER JOIN and LEFT JOIN?

• INNER JOIN = matching records in both tables
• LEFT JOIN = all rows from left table + matching rows

How would you identify duplicate records in a table?

Listen for: COUNT, GROUP BY, HAVING.

When would you use ORDER BY?

Listen for: "sorting results."

If an ETL job loads incomplete data, what SQL checks would you run?

Listen for: record counts, null checks, comparing source vs. target tables.

(Linux) How do you find errors in a log file?

Listen for: grep, filtering patterns in logs.

(Linux) What command lists all files, including hidden ones, in a directory?

Listen for: any combination of a command starting with ‘ls’.

Have you used "vi" editor before in Linux?

Listen for: YES