Alexander Technology GroupGeode 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 ServiceNow 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 DataDog for application monitoring and alerting
Frequently participate in an on-call rotation, including weekends, to resolve production issues promptly S
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 ServiceNow 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 DataDog
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
Company Overview: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 support a diversified work environment. Learn more about Geode at
NEW SCREENING QUESTIONS FOR CANDIDATES
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?
"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?
COUNT, GROUP BY, HAVING.
When would you use ORDER BY?
"sorting results."
If an ETL job loads incomplete data, what SQL checks would you run?
record counts, null checks, comparing source vs. target tables
(Linux) How do you find errors in a log file?
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?
¿Te interesa este puesto?