Job Description

Data Architect Snowflake & SQL Server Focus
Chicago, IL Hybrid schedule: 1-2 days onsite, 3-4 days remote
Summary
This position is responsible for architecting, implementing, and optimizing the data platforms. This position plays an integral role in the maintenance, support, and enhancements of custom and 3rd party, business critical applications, databases, and data integration processes. The role establishes architectural standards for SQL Server and Snowflake data warehouse environments and dependent data flows. This role shares operational support of data platforms with DBAs and provides subject matter expertise for data structure, storage, and movement to various projects.
What you'll be doing
Direct and oversee the architecture and development of data systems to meet application and reporting requirements
Support highly-available relational database and cloud data warehouse technologies
Monitor database systems, optimize database query performance, and ensure data security and durability
Document, refine, and standardize data pipelines from core application to downstream systems to meet integration specifications
Maintain metadata repositories and data diagrams to meet data governance standards
Review and establish best practices and processes for database object creation, deployment, and change control
Ensure data systems are secure by design
Troubleshooting, fault analysis, and issue resolution
Implementation and maintenance of high availability and disaster recovery solutions such as SQL Server replication, AlwaysOn Availability Groups, and Log Shipping
Investigate and resolve reported application issues, escalating issues as necessary to application owners
Provide On-Call support on a rotating basis which requires the flexibility to work off hours
Skills we're seeking
7+ years of experience with Database/DW Engineering
2+ years of experience with Database/DW Architecture
Must have strong SQL Server experience
Must have at least some Snowflake experience more the better
Nice to have experience
Data architecture experience in Azure environments ideally hybrid cloud environments
Data governance and data security experience
Experience architecting or leading data transformation projects
#J-18808-Ljbffr

Job Tags

Part time, Remote work,

Similar Jobs

Hive Group LLC

TSA Program Support Job at Hive Group LLC

...General Application TSA Program Support Location: Various TSA Sites in the DC Metro Area (Hybrid/Onsite Roles May Apply) Clearance Requirement: Public Trust or higher (may vary by role) Employment Type: Full-Time (Contingent Upon Contract Award) Position Overview...

National Radio Astronomy Observatory

Green Bank Observatory Director Job at National Radio Astronomy Observatory

...Description National Radio Astronomy Observatory Title: Green Bank Observatory Director Location: Green Bank Observatory, GREEN... ...advanced instrumentation access to the astronomy community as well as to other basic and applied research communities, as part of...

Lancesoft INC

Hybrid-Trauma Registrar- 1 day a week onsite. Job at Lancesoft INC

Job Description Job Description Work Experience: 1-3 years One year coding experience OR previous working with trauma registry databases and handling medical information in a health care setting. Required Licenses: CSTR-Certified Specialist Trauma Registries...

12261049 Canada Inc

Part-Time French Tutor/Teacher Job at 12261049 Canada Inc

...Description Job Description Company description Scholars of Brampton Central is a brand new location and we are looking for a French teacher who is flexible to tutor anywhere from JK to High School. Job description Scholars of Brampton Central is seeking a...

Bridgeprep Academy, Inc.

High School ELA Teacher Job at Bridgeprep Academy, Inc.

...Description Job Description Description: To ensure high-quality instruction linked to the school and district strategic goals for all students. To... ...and school-wide meetings and functions. Engage in summer and year-long district, school, and personal learning...

Data Architect Snowflake & SQL Server Focus (Chicago) Job at 1872 Consulting, Chicago, IL

bmg2emM1cmlRMmw4RFFHNHl4SStHaS8yV2c9PQ==