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

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

Idaho Staffing

Network Engineer - Manager Job at Idaho Staffing

 ...Job Posting Analyze current network, troubleshoot, diagnose, and rectify issues as required. Monitor performance and status of the...  ...Qualifications Bachelors Degree in computer Science, Engineering or equivalent experience (wireless networking). Trained in MikroTik... 

Staff Pad

Pediatric Dentist - 750,000 Associate Dentist - Shreveport/Bosier, LA Job at Staff Pad

 ...Join a top pediatric dentistry group in Shreveport-Bossier, Louisiana, offering an exceptional opportunity for a Pediatric Dentist. This thriving practice boasts unrivaled support from internal staff, ensuring efficiency and success from the top down. With a strong market... 

Boston Public Schools

Guild - Principal Clerk School Secretary Grade 23E (SY25-26) (Boston) Job at Boston Public Schools

 ...Reports to: School Leader/Headmaster General Description: Under general supervision, the School Secretary serves as the primary administrative support to the principal or headmaster, performing complex clerical work requiring independent judgment and utilizing current... 

ChristianaCare

Director Patient Escort/Patient Transportation Job at ChristianaCare

 ...creating innovative, effective, affordable systems of care that our neighbors value. Supporting this mission, we seek a Director Patient Escort Services. We seek a strong people and process leader who will plan, organize, and execute coordinating the activities of the... 

Ashley | The Wellsville Group

Warehouse Associate Job at Ashley | The Wellsville Group

 ...directly supports our 5 Star customer experience. What We Offer : Competitive Salary:$16.00-$17.00/hour Schedule: Monday through Friday, 7:00am-3:30pm Comprehensive Benefits : Health, dental, and vision insurance, paid time off, and 401(k) with company...