Role Overview
Our Data & Analytics Operations team is seeking a Senior Support Engineer to support mission-critical data platforms, operational processes, and application upgrades within client's analytics environment. This role combines hands-on technical support, troubleshooting, data analysis, and operational project coordination.
This is not a traditional software development role. The successful candidate will leverage their development background to diagnose and resolve issues, support ETL and data ingestion processes, participate in platform upgrades, and help ensure operational stability across our data ecosystem.
The ideal candidate can quickly learn new environments, understand complex data flows, identify root causes of data discrepancies, and effectively coordinate operational initiatives through the full software development lifecycle.
Operational Support (Approximately 70-80%)
- Monitor and support end-to-end data ingestion, ETL, and analytics processes
- Investigate and resolve complex data discrepancies and production support issues
- Analyze failed jobs, data quality issues, and platform performance concerns
- Troubleshoot SQL, ETL, database, and cloud platform issues
- Monitor production environments and implement operational improvements
- Support data warehousing and enterprise data lake environments
- Ensure compliance with Incident, Problem, and Change Management processes
- Create and maintain technical and operational documentation
Operational Projects & Upgrades (Approximately 20-30%)
- Participate in application, database, cloud, and platform upgrades
- Coordinate operational project activities through the full SDLC lifecycle
- Assist with planning, UAT, deployment preparation, release coordination, and production implementation
- Work closely with support engineers, project teams, and technology partners to deliver operational enhancements
- Support ongoing modernization initiatives including Snowflake and Iceberg adoption efforts
Critical Skills / Must-Haves:
Core Technical Requirements
- 4+ years of experience supporting enterprise data, analytics, or application environments
- Strong SQL development and query optimization skills
- Hands-on ETL experience (Informatica Cloud or Informatica On-Prem preferred)
- Experience troubleshooting data pipelines, integrations, and data processing workflows
- Strong understanding of relational databases and data warehousing concepts
- Experience with Microsoft SQL Server
- Experience working within cloud-based environments.
- AWS / Cloud Experience
Candidates should have hands-on experience with several of the following technologies:
Priority AWS Skills
- AWS Glue
- AWS Lambda
- EMR
- EC2
- S3
- Redshift
- CloudWatch
- SDLC & Project Experience
- Experience participating in platform, application, database, or cloud upgrades
- Strong understanding of Software Development Lifecycle (SDLC)
- Ability to coordinate activities across development, testing, staging, and production environments
- Experience planning and supporting deployments through production implementation
- Demonstrated project coordination or operational project management experience
Nice to have Skills:
- Exposure to additional AWS services such as Bedrock, SageMaker, Amazon Q, and Athena is highly desirable.
Preferred Qualifications
- Snowflake experience
- Apache Iceberg experience
- Enterprise Data Lake environments
- Distributed computing and large-scale data processing
- Python development
- GitHub Copilot
- Amazon Q
- DevOps tools including BitBucket, Jenkins, Ansible, and CI/CD pipelines
- Experience with AI solutions or AI agent development
- Financial services or insurance industry experience.