7 days ago
Responsibilities
- Design, build, and support end-to-end data pipelines using Fivetran, dbt, and Snowflake.
- Configure and manage Fivetran connectors across SaaS applications, databases, APIs, and file-based sources.
- Develop and maintain dbt staging, intermediate, mart, and publish models, including tests, freshness checks, incremental processing, documentation, and reusable macros.
- Develop optimized Snowflake SQL and scalable analytical data models.
- Support Snowflake objects, security and RBAC, stages, data sharing, and data-loading patterns.
- Implement data quality, reconciliation, monitoring, and operational alerting.
- Troubleshoot production pipelines and perform root-cause analysis across ingestion and transformation layers.
- Participate in Git-based development, CI/CD, code reviews, and DEV/QA/PROD deployments.
- Collaborate with application, infrastructure, security, analytics, and business teams to onboard new data sources.
- Manage data modeling projects, ensure policy adherence, provide strategic guidance, and lead a team.
Requirements
- Strong hands-on experience with Snowflake, including advanced SQL, data modeling, performance optimization, RBAC, stages, and data integration patterns.
- Strong hands-on experience with dbt or dbt Cloud, including models, tests, macros, incremental models, sources, documentation, jobs, and deployment patterns.
- Production experience configuring, monitoring, and troubleshooting Fivetran pipelines and connectors.
- Strong SQL skills including complex joins, CTEs, window functions, reconciliation, and query optimization.
- Experience with Git, branching, pull requests, code reviews, and automated deployment workflows.
- Working knowledge of Python for data processing, automation, API integrations, file processing, data validation, and operational scripting.
- Familiarity with Claude and AI-assisted development workflows using tools such as Cursor or VS Code; deep AI/LLM development experience is not required.
- Preferred experience includes 5+ years of data engineering or related experience, 2+ years with Snowflake and dbt, and 4–6 years in data modeling or data analysis.
- Preferred experience includes enterprise DEV → QA → PROD SDLC and change-management processes, reusable ingestion and transformation patterns, and production troubleshooting.
- Graduate education in Computer Science, Data Science, or a related field is listed as a qualification.
About EXL
EXL provides data analytics, AI, and digital operations services for enterprises in insurance, healthcare, banking, and other regulated industries. It delivers consulting, managed services, and technology platforms to improve decision-making, risk management, and operational efficiency. Founded in 1999 and headquartered in New York, EXL is a public company listed on the NASDAQ (ticker: EXLS).