Data Architect - Snowflake & SQL Server Focus
1872 Consulting
Data Architect – Snowflake & SQL Server Focus 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. 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 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 Data architecture experience in Azure environments – ideally hybrid cloud environments Data governance and data security experience Experience architecting or leading data transformation projects 1872 Consulting
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Architect - Snowflake & SQL Server Focus in Chicago, IL vacancy
- SNOWFLAKE DATA ARCHITECT Location: Chicago IL (Day One Onsite) Duration: Contract/Fulltime Job Description: Must have total 12+ years of working... ...as a Snowflake Data Architect. Expertise in Snowflake, IICS, SQL is must. Mandatory to work from Chicago location Expertise in...SQLFull timeContract workWork experience placement
- ...Job Title: Data Architect (Snowflake & DBT) Location: Chicago, IL About the Role: We are seeking a skilled Data Architect with deep... ...tools (e.g., Airflow, Prefect). ~ Proficient in SQL; experience with Python is a plus. ~ Experience with BI/...SQLWork experience placement
Lorven technologies
Chicago, IL1 day ago - Data Architect Location: Chicago Hybrid onsite 3x a week (local... ...familiarization -Snowflake: primary database This... ...design and implementation. Focus of role is on... ...AirFlow, DBT, Linux Strong server-side programming... ...(ETL) Write Snowflake SQL including stored procedures...SQLContract workTemporary workFor contractorsLocal area
- ...Data Solutions Architect The Data Solutions Architect is a hands... ...JavaScript, Python, SQL, XQuery, Scala, etc.... ...organization with a focus on efficient execution... ...Oracle, Postgres, SQL Server. Experience with database... ...databases such as Snowflake, MongoDB, Cosmos,...SQLFor contractorsWork experience placementShift work
Software Technology Inc
Chicago, IL3 days ago $112.7k - $193.2k
Master Data Management Technical Lead Architect Optum Insight is improving the flow... ...). This role will focus on Informatica MDM,... ...develop and optimize SQL and Python-enabled automation... .... Troubleshoot server or software issues... ..., ADF, Databricks, Snowflake, Data Lake, or...SQLMinimum wageFull timeWork experience placementWork at officeLocal areaRemote work- Data Specialist Locations: Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken... .... Knowledge of RDBMS platforms (SQL Server, DB2, etc.) with experience in generating DDL. The enterprise data architect is a pivotal role focused on designing, modeling, and mapping...SQLContract work
$93.6k - $154.44k
Data Architect I Ann & Robert H. Lurie Children's Hospital of Chicago provides superior pediatric... ...principles with customer service focus of innovation, service excellence and teamwork... ...language. Knowledge\Experience with SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI)....SQLHourly payFull timePart timeWork at officeFlexible hours- Senior SQL Server & Healthcare Data Consultant PCG Consulting International partners with healthcare organizations... ..., and billing systems. The role will focus on extracting, validating, and... ...Working closely with Healthcare Data Architects, Paragon consultants, Revenue Cycle...SQLCasual workRemote work
- ...Position: MS SQL Server Azure DBA Location: Chicago, IL Duration: 6-12 Months Rate: DOE US Citizens Only. Good Knowledge on MS SQL Server 2017 and above database administration. Working Knowledge of cloud migration and HA/DR set up....SQL
Georgia IT Inc
Chicago, IL1 day ago - ...Database Architect Chicago, IL 6 Months+ No C2C, any visa is okay... ...~5+ years experience supporting MS SQL 2014+ servers as a DBA ~3+ years experience working... ...and experience with BI databases like Snowflake is a plus ~ Knowledge and experience...SQL
3B Staffing LLC
Chicago, IL1 day ago - Sr Data Engineering Architect Our talented Data & AI team is made up of globally recognized experts - and there's... ...intelligence and reporting solutions using Python, SQL, Microsoft Azure Data Services, Fabric, Databricks, and Snowflake.• Stay abreast of the latest advancements...SQL
- SQL Server DBA - Remote Experience with SQL server patching on Cluster and Standalone servers in production and non-prod environments. Experience with Database refresh, build, and migration. Experience with Mirroring or Always-on setup. Experience with SSRS, PBIRS, SSAS...SQLRemote work
$111k - $186.7k
...promises. Kemper is seeking an SQL Server DBA. This Database... ...to support database design, data modeling, schema changes, release... ...environments, with a strong focus on Microsoft SQL Server. Extensive... ...Specialty, AWS Certified Solutions Architect, or other database/cloud-...SQLPermanent employmentFull timeTemporary workFor contractorsCasual workWork at office- ...services client. This role will focus on analyzing existing... ...high-performance, compliant data models. The ideal candidate will... ...8-10 years of experience in SQL Server development/DBA, data modeling... ...Exposure to cloud data platforms (Snowflake, Databricks) Familiarity with...SQLTemporary workWork experience placementInternshipLocal area
- Healthcare Data Architect PCG Consulting International partners with healthcare organizations to solve complex operational, technology, and... ...hospital EHR platforms (Paragon preferred). Advanced SQL Server and database analysis skills. Experience with ETL architecture...SQLRemote work
- ...are seeking a Senior Database Architect who combines deep expertise... ...looking vision for AI-native data architecture. You'll lead the... ...Analyze and decompose large SQL Server stored procedures (1,000+ lines... ...PostgreSQL, MongoDB/Cosmos DB, Snowflake, and vector databases (...SQLFlexible hours
WEX
Chicago, IL1 day ago $123.1k - $186.3k
...Data360 (formerly known as Data Cloud) Success Architect, you will play a crucial role... ...business processes focusing on data & integration architecture... ...with large data such as Snowflake, Databricks, AWS, Google Cloud... ...as Python, Java, .Net, SQL Note: This role is office-...SQLWork experience placementWork at officeRemote workFlexible hours3 days per week- ...Description CapTech Data Architects match our clients’ business... ...with non-technical executives focusing on value of modern enterprise... ...warehouse tools including Snowflake and DataBricks ~ Advanced... ...standard languages including SQL and Python ~ Ability to think...SQLFull timeWork at officeRemote workVisa sponsorshipWork visaFlexible hours
CapTech Consulting
Chicago, IL11 days ago - ...About the job Lead Data Architect Job Title: Lead Data Architect Location: Chicago... ..., and Cart domains, with current focus on brand onboarding, re-architecture, database... ...Mesh, Lakehouse, Data Vault ~ Advanced SQL (querying, transformation, performance...SQL
Glint Tech Solutions LLC
Chicago, IL3 days ago - ...Job Description Snowflake Platform Engineer(Snowflake... ...Engineering team. The role focuses on Snowflake... ...Python, JavaScript, and SQL. 4. Develop Azure DevOps... ...10-13 years of overall data warehouse development/administration... ...2. Snowflake SnowPro Advanced Architect CertificationSQL
Purple Drive
Chicago, IL2 days ago - ...delivered by several Product Teams focused on different domains -... ..., Loyalty, Search and Browse, Data Integration, Cart. Current... ...Responsibilities We are looking for Data Architect who will be responsible for... ...Proficiency in SQL to perform complex queries, data...SQL
Luxoft
Chicago, IL20 days ago $100k - $120k
Data Modeler - BI Analytics - Onsite (Full Time) Base pay range... ...Multidimensional, Star, Galaxy and Snowflake Schema. Extensive experience... ...and Data Analysis using SQL scripts, Excel techniques. Must... ...relational database: Oracle/SQL Server/Teradata. Performance tuning,...SQLFull time- ...Skills 7+ years of experience with Data Modeling, Data Warehousing,... ...working with Business Architects, System Architects, Engineering... ...Management Systems (RDBMS) and SQL. Strong collaboration skills with... ...curious, and collaborative with a focus on quality. Skilled in...SQLWork experience placement
$135k - $190k
...world combine experience across technology, data sciences, consulting, and customer... ...and traditional database systems such as SQL Server, Oracle, or MySQL.Experience implementing... ...plus, but not required.Experience with Snowflake and zero-copy architecture patterns is a...SQLContract work$150k - $185k
DATA AI ARCHITECTWHO IS SPR?SPR helps companies implement... ...developers, designers, architects, consultants, thinkers,... ...| Experienced with SQL, python skills (R is a... .../SQL Databases (SQL Server, Postgres, Oracle, MySQL... ...Data Analytics Platforms (Snowflake, Databricks, Apache...SQLTemporary workCasual workFlexible hours$140k - $170k
Research Platform Architect The Federal Reserve Bank of St. Louis is seeking... ...and developers worldwide. The Data Architect will lead the design... ...publications. This role focuses on designing scalable data platforms... ...stack tools, data governance, SQL and other query tools and...SQLFull timeWorldwideFlexible hours- Media Data Management Work location: Local to Chicago, 2 days in the office on flexible schedule... ...for action, strong attention to detail, focus on risk management and possess a... ...are required: Structured Query Language (SQL) High level of competency with Windows operating...SQLFor contractorsWork at officeLocal areaRemote workFlexible hours
- TIAA is seeking a data analyst in Chicago to enhance data-driven decision-making. Responsibilities include collaborating... ...and over 5 years of experience in financial services, focusing on data visualization, SQL, and analysis. Competitive salary range is available, with...SQL
- ...decipher complex logic, and assess current data models * Partner with business... ...related field * 8-10 years of experience in SQL Server development/DBA, data modeling, and... ...Tableau) * Exposure to cloud data platforms (Snowflake, Databricks) * Familiarity with...SQLHourly payContract work
- ...Sr. Financial Analyst - Data Analytics Focus The Senior Financial Analyst Data Analytics role requires... ...to effect company change. Leverage Snowflake and other data sources to automate... ...creating dashboards. Must be comfortable with SQL (writing queries). At least 1+ year of...SQL
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Architect - Snowflake & SQL Server Focus. Be the first to apply!
Related searches
- data center architect Chicago, IL
- database designer Chicago, IL
- data integration architect Chicago, IL
- big data architect Chicago, IL
- data architect Chicago, IL
- remote data architect Chicago, IL
- data loss prevention engineer Chicago, IL
- data Chicago, IL
- sap data migration Chicago, IL
- test data management Chicago, IL