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

THVjMGlwTmU2UklUZWJ0STNMWnppbDllNGc9PQ==
  • 1872 Consulting
  • Chicago, IL

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

Remote work,

Similar Jobs

Johnson & Johnson

AssociateArea Clinical Consultant San Francisco CA Johnson Johnson MedTech Heart Recovery Job at Johnson & Johnson

At Johnson & Johnson, we believe health is everything. Our strength in healthcare innovation empowers us to build a world where complex diseases are prevented, treated, and cured, where treatments are smarter and less invasive, and solutions are personal. Through our expertise... 

GRAY MATTER HEALTH

Administrative Assistant Job at GRAY MATTER HEALTH

 ...to come up with ideas for increase efficiency and effectiveness ~ Proficient in Microsoft Office Suite, Google Drive Suite, Zoom, Dropbox, Mac, and Windows. ~ Ability to quickly learn new software and systems. ~ Problem solver and critical thinker ~ Familiarity... 

JPMorgan Chase & Co.

Investment Banking - Financial Institutions Group - Analyst Job at JPMorgan Chase & Co.

 ...Job Description We are seeking a highly skilled and experienced Investment Banking Analyst to join our dynamic Financial Institutions Group (FIG) team, offering an exceptional opportunity to contribute to high-profile transactions and drive growth within a leading... 

Sheetz, Inc

Lead Team Member Job at Sheetz, Inc

 ...attitude and the ability to prioritize tasks and delegate effectively, check out our available Supervisor position and LETS MAKE SHEETZ HAPPEN! Be a leader by example to our store team members with high-energy hustle and a strong team mentality. Youll all work... 

Resource Informatics Group

Anaplan Architect Job at Resource Informatics Group

 ...enterprise-wide Anaplan implementations. ~ Proficiency in data integration tools and APIs (e.g., Anaplan Connect, Informatica, Mulesoft). ~ Excellent communication, problem-solving, and stakeholder management skills. Preferred Qualifications Experience...