Associate Data Architect - 2897 (Remote) jobs in United States
cer-icon
Apply on Employer Site
company-logo

CES · 1 month ago

Associate Data Architect - 2897 (Remote)

positionUnited States
timeFull-time
remoteRemote
senioritySenior Level, Lead/Staff
date10+ years exp

CES is a company with over 26 years of experience in Software Product Development and Digital Transformation Consulting Services. They are seeking an Associate Data Architect to lead the SQL workload migration lifecycle, which includes auditing, documenting, and migrating SQL objects and datasets.

Cyber SecurityInformation Technology
check
H1B Sponsor Likelynote

Responsibilities

Audit all tables, views, stored procedures, functions, SQL Agent jobs, and dependencies
Document schema relationships, data flows, lineage, and interdependencies
Identify and document business use cases and downstream consumers for each SQL object
Meet with affiliate teams to validate use cases and uncover undocumented dependencies
Recommend Azure-based targets: Azure SQL, Managed Instance, Data Lake/OneLake, Fabric Lakehouse/Warehouse, or SharePoint
Redesign structures where appropriate—do not blindly lift-and-shift
Provision or coordinate provisioning of cloud targets
Execute extraction, migration, validation, reconciliation, and post-migration support
Repoint downstream services or coordinate with BI/Power Platform/ETL owners
Produce final-state architecture diagrams, data models, use-case maps, and consumer catalogs
Support retirement sequencing and SQL server decommissioning

Qualification

SQL Server engineeringT-SQL proficiencyAzure SQL experienceData migration experienceRelational design understandingAgile structure experienceData governance knowledgeDiagramming skillsFluent EnglishDocumentation skills

Required

Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent
10+ years SQL Server engineering, migration, or data architecture experience
Strong T-SQL proficiency and ability to reverse-engineer undocumented systems
Experience with Azure SQL, Managed Instance, Data Lake, Fabric Lakehouse/Warehouse
Understanding of relational design, normalization, and referential integrity
Ability to map upstream/downstream dependencies
Fluent English (reading, writing, speaking)
Strong documentation skills
Ability to work independently within an Agile structure

Preferred

Azure Data Fundamentals
Azure Administrator Associate
Fabric Analytics Engineer Associate
Experience migrating SQL workloads to Azure or Fabric
Knowledge of Power BI dataset modeling and Power Platform usage
Familiarity with data governance and lineage tracking
Diagramming with Lucidchart or Visio
Experience coordinating multi-team cutovers

Company

CES

twittertwittertwitter
Glassdoor3.9
company-logo
CES is an information technology and business process management company.
dateFounded in 1996
location
Bolingbrook, Illinois, USA
people-size1001-5000 employees
web-link
https://cesltd.com

H1B Sponsorship

CES 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 (14)
2024 (10)
2023 (7)
2022 (13)
2021 (11)
2020 (15)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Raju Vedala
Chief Executive Officer
linkedin

Recent News

shropshirestar.com
Shrewsbury firm CES named SunPower 'premier partner' to drive UK solar energy growth
2025-09-20
The Hollywood Reporter
Cannes Film Market, CES Join Forces for Film Innovation Award
2025-05-17
shropshirestar.com
Shropshire's 'green economy' set to grow to £1.3 billion over next five years - according to new figures
2025-04-30
Company data provided by crunchbase