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

Y201MUE2T3FmZlJZK2JSTDFxT25sY2NiUFE9PQ==
  • 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

Part time, Remote work,

Similar Jobs

Ottawa Area ISD

Teacher: SCI post-secondary (job share) - half-time position (Allendale) Job at Ottawa Area ISD

 ...needs students. Description : Individual needed to work with post-secondary aged students with severe cognitive impairments and autism. Highly individualized strategic instruction along with personalized whole child plans will be developed to promote skills... 

HomeBuys, Inc.

Distribution Center Associate Job at HomeBuys, Inc.

 ...General Description The Distribution Center (DC) Associate is responsible for carrying out the logistics of sorting, pricing, counting, and packing merchandise. A qualified candidate for the DC Associate has an excellent work ethic and is always looking for tasks to... 

Air Evac Lifeteam

Helicopter Pilot: FAA Class II Medical Certificate Job at Air Evac Lifeteam

 ...school diploma or equivalent Other: 230-pound weight limit dressed in flight suit and boots Upload your Pilot License and FAA Medical Certificate Global Medical Response teams deliver compassionate, quality medical care, primarily in the areas of... 

Mission Recruiting

Attorney | Data Privacy and Governance | 147518 Job at Mission Recruiting

 ...Job Description Job Description A leading global law firm with strong New York roots is seeking a dedicated Data Privacy and Information Governance Officer to join its Office of General Counsel . This is a unique opportunity to lead and advance firm-wide data... 

Genpact

Entry level support Technician, Aerospace Job at Genpact

 ...an example of how were scaling advanced technology solutions to help global enterprises work smarter, grow faster, and transform at...  ...Facebook . Inviting applications for the role of Entry Level Support Technician, Aerospace! In this role, Support Technicians work...