10 days ago
Base Salary
$64k - $95k/yr
Responsibilities
- Develop new data pipelines in Azure Databricks and contribute to the enterprise data lakehouse.
- Enhance SQL Server Agent jobs, stored procedures, views, functions, SSIS packages, and related schemas.
- Build and maintain external-system and API integrations using Salesforce MuleSoft.
- Write and tune complex T-SQL, analyze execution plans, and apply indexing and statistics strategies.
- Build and maintain Power BI data models and datasets, including publishing, scheduled refreshes, and gateway configuration.
- Perform data validation, reconciliation, and data-quality checks across source and target systems.
- Monitor, triage, diagnose, and resolve failures across approximately 300 production data integration jobs.
- Drive root-cause analysis and prevent recurrence of production failures.
- Gather requirements and deliver solutions with team members, application developers, and academic and administrative stakeholders.
- Communicate status, root causes, and business impact to non-technical stakeholders.
- Use AI-assisted development tools to accelerate coding, troubleshooting, and documentation while reviewing and testing generated output.
Requirements
- At least 5 years of hands-on Microsoft SQL Server and T-SQL development experience.
- Advanced set-based T-SQL skills, including window functions, common table expressions, deduplication, latest-record-per-key patterns, and conditional aggregation.
- Experience building, scheduling, monitoring, and troubleshooting SQL Server Agent job chains in production.
- Experience developing and maintaining SSIS packages, including debugging deployed-package failures.
- Demonstrable hands-on Azure Databricks experience with notebooks, jobs, workflows, Spark SQL or PySpark, and Delta Lake.
- Hands-on MuleSoft API integration development, including Mule flows, DataWeave transformations, error handling, deployment, and production monitoring.
- Productive use of agentic coding tools such as Claude Code, Databricks Genie, OpenRouter, or Cursor, with the judgment to validate AI-generated output.
- Experience with execution-plan analysis, index design, statistics maintenance, and diagnosing production query regressions.
- Production incident-support experience through resolution against service-level expectations.
- Professional written and spoken English sufficient to explain technical issues and business impact to non-technical stakeholders.
- Ability to work 100% onsite in Irvine, California during standard Pacific business hours.
Benefits
- Medical, dental, vision, and life insurance.
- Paid holidays and paid time off.
- 401(k) plan and contributions.
- Long-term and short-term disability coverage.
- Paid parental leave.
- Employee stock purchase plan.
- Discretionary annual incentive program based on performance and applicable plan terms.
- Onsite work five days per week in a client or Cognizant office in Irvine, California; remote work is not available.
Tech Stack
DatabricksMicrosoft SQL Server
Categories
Data Engineering
About Cognizant
Cognizant is a public IT services and consulting firm that designs, builds, and runs enterprise technology, including digital engineering, cloud modernization, data/AI, and managed services. It sells consulting, systems integration, and outsourcing on multi-year engagements to large enterprises in healthcare, banking, retail, communications, and manufacturing. Founded in 1994 and headquartered in Teaneck, New Jersey, Cognizant is NASDAQ-listed (CTSH) and a Fortune 500 company.