Zensar Technologies · 4 hours ago
DATABASES-Architecture & Design-MS SQL
United States
Full-time
Remote
Senior Level, Lead/Staff
10+ years expZensar Technologies is committed to designing and managing digital solutions for leading enterprises. They are seeking a Database Architect with extensive experience in MS SQL to design and build data models and support business intelligence projects.
ConsultingIT ManagementOutsourcingSoftware
Responsibilities
At least 10+ years experience writing advanced stored procedures using Microsoft SQL. SQL proficiency should include ability to read and understand complex stored procedures and be able to translate data flow to others as well as the ability to create complex data flows using only SQL stored procedures
Experience designing and building relational and dimensional data models to support business intelligence projects. Experience in a DWH environment with large tables a plus
Experience pulling data from an Event driven application and modeling that data into relational models. Experience parsing JSON to materialize data a plus
10+ years experience evaluating vague or incomplete business requirements and being able to translate into a working business intelligence data model which can be used for decision support, analytics and reporting
Qualification
Required
At least 10+ years experience writing advanced stored procedures using Microsoft SQL
SQL proficiency should include ability to read and understand complex stored procedures and be able to translate data flow to others as well as the ability to create complex data flows using only SQL stored procedures
Experience designing and building relational and dimensional data models to support business intelligence projects
Experience in a DWH environment with large tables a plus
Experience pulling data from an Event driven application and modeling that data into relational models
Experience parsing JSON to materialize data a plus
10+ years experience evaluating vague or incomplete business requirements and being able to translate into a working business intelligence data model which can be used for decision support, analytics and reporting
Company
Zensar Technologies
Zensar Technologies is a software company that provides information technology and business process outsourcing services.
10001+ employees
H1B Sponsorship
Zensar Technologies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (195)
2024 (147)
2023 (120)
2022 (195)
2021 (135)
2020 (139)
Funding
Current Stage
Public CompanyTotal Funding
$9MKey Investors
Epiris
2015-10-10Post Ipo Equity
2003-07-09IPO
1997-09-01Private Equity· $9M
Leadership Team
Manish Tandon
CEO & Managing Director
Nagesh Nagineni
Practice Leader and CTO for AES, Data and Analytics Services @Zensar Technologies
Recent News
Business Standard India
2025-10-29
Livemint.com
2025-09-26
Company data provided by crunchbase