Skip to main content

SQL Developer

00069926682

Data Warehouse Engineer (SQL Server)

About the Role

As a Data Warehouse Engineer (SQL Server), you will make an impact by designing, developing, and optimizing enterprise-scale data warehouse solutions that support critical business and analytics initiatives. You will be a valued member of the Data Engineering team and work collaboratively with business stakeholders, analytics teams, risk management teams, and enterprise technology partners to deliver high-performing data solutions.

In This Role, You Will:

  • Design, develop, and maintain SQL Server-based data warehouse solutions supporting large-scale enterprise reporting and analytics.
  • Build and optimize ETL/ELT pipelines using SQL Server and SSIS to process high-volume structured data from multiple source systems.
  • Develop advanced T-SQL stored procedures, views, functions, and transformation logic to support business-critical data requirements.
  • Implement and support dimensional data models, including fact and dimension structures, SCD Type 1 and Type 2 processing, and incremental load frameworks.
  • Monitor, troubleshoot, and tune database performance through query optimization, indexing strategies, and workload analysis.
  • Integrate data from APIs, external vendors, and legacy platforms into modern analytics environments.
  • Support enterprise data migration initiatives, including modernization of SSIS-based ETL solutions into ELT architectures.
  • Collaborate with business users and technical teams to ensure data quality, scalability, performance, and SLA compliance.
  • Develop operational monitoring and metadata tracking solutions to improve transparency and reliability of data platform operations.

Work Model

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role's business requirements, this is a hybrid position requiring 3 days per week in a Cognizant or client office in New Jersey. Regardless of your working arrangement, we are here to support a healthy work-life balance through our various wellbeing programs.

The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.

What You Need to Have to Be Considered

  • 10+ years of experience in Data Engineering, Data Warehousing, or SQL Server Development.
  • Strong expertise in SQL Server, T-SQL development, stored procedures, views, functions, and database design.
  • Experience designing and supporting large-scale data warehouse environments with multi-terabyte datasets.
  • Hands-on experience with SSIS and SQL-based ETL/ELT development frameworks.
  • Deep understanding of dimensional modeling, star schemas, fact and dimension design, and data warehousing best practices.
  • Experience implementing incremental load processes, Change Data Capture (CDC), and SCD Type 1/Type 2 methodologies.
  • Proven experience with SQL query optimization, indexing strategies, and performance tuning.
  • Experience integrating data from APIs, external vendors, and multiple enterprise source systems.
  • Strong analytical, problem-solving, and troubleshooting skills.
  • Excellent communication and stakeholder management capabilities.

These Will Help You Stand Out

  • Experience within financial services, banking, risk management, or regulatory reporting environments.
  • Experience migrating legacy ETL solutions to modern ELT architectures.
  • Knowledge of Teradata-to-SQL Server data migration and transformation strategies.
  • Experience building metadata-driven frameworks and operational monitoring solutions.
  • Experience with Power BI, paginated reporting, and business intelligence platforms.
  • Experience working in Agile environments using tools such as Jira and GitHub.
  • Familiarity with enterprise risk analytics and regulatory data platforms.

We're excited to meet people who share our mission and can make an impact in a variety of ways. Don't hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role.

Salary and Other Compensation

Applications will be accepted until July 22, 2026.

The annual salary for this position is between $88,000 - $127,000, depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits

Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

  • Medical/Dental/Vision/Life Insurance
  • Paid Holidays plus Paid Time Off
  • 401(k) Plan and Contributions
  • Long-term/Short-term Disability
  • Paid Parental Leave
  • Employee Stock Purchase Plan

Disclaimer

The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.


About Cognizant
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant.

Additional employment information
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, provincial or local laws.

Your path to Cognizant

Wondering what to expect after you apply? Here’s a peek at our recruitment process—and keep in mind that not all candidates advance through every step and the process may vary depending on your role and location.

Your Application Midnight Blue RGB

Step 1: Application

Find an open role that aligns with your skills and career goals and show us why you’re the person for the job. Consider joining our Talent Community if you don’t find the right opportunity.

Phone Call Midnight Blue RGB

Step 2: Recruiter call

If one of our recruiters sees a fit, they’ll set up a short introductory call to learn more about you and how your experiences and skills align with the role.

Step 3: Interview(s)

If you and our team would like to continue the process, you’ll meet with one of our hiring managers. Some roles may also require technical assessments and/or client interviews.

Step 4: Final decision

Our hiring team will then review each candidates’ potential to succeed in the role. This process may take some time because we want to get it right—but you can count on us to keep you updated.

Benefits that help you thrive and grow

Our teams achieve incredible things when they feel fully supported. That’s why our benefits program is built around the diverse needs of our people—so they can enjoy a fulfilling, balanced and healthy life.

Untitled Design 49
Financial wellbeing

Financial wellbeing

We regularly review market data to ensure compensation is competitive and reflects the value you bring. Your benefits extend beyond pay and may include retirement plans, financial education, discount programs, etc.

1 (1)
Physical and mental wellbeing

Physical and mental wellbeing

We empower you to prioritize your wellbeing through paid time off, flexible working where possible, healthcare plans, counselling, our Mental Health Allyship program and more. 

Your Career, Your Way
Your career, your way

Your career, your way

With 90% of our associates building skills through GenAI training, job shadowing, industry certifications and more, you have everything you need to build a full career.

Professionals
Real-world impact

Real-world impact

Think about the biggest brands you rely on. Chances are, they rely on us to help strengthen their business. Here, you’ll turn bold ideas into solutions that improve lives everywhere.

Haven't yet found the right opportunity?

Receive the latest updates on job opportunities, recruitment events and company news—tailored just for you!

Get the latest updates