Data Architect
Excelgens, Inc
Chicago, IL, United States
2 months ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$147,900.0 - $195,000.0
Working hours
Regular working hours
Job source
Tech stack
Microsoft Azure
Databases
Data Architecture
Extract Transform Load (ETL)
Data Warehousing
Database Schema
Software Debugging
Microsoft SQL Server
SQL Azure
NoSQL
Scrum Methodology
SQL Stored Procedures
+6 more
SQL Server Integration Services
Azure Data Factory
HybridCloud
Er-Win
Cosmos DB
Service Stack
Job description
Data Architect Lto support the internal GTP Tax Platform initiative by building data models in Erwin, writing/debugging stored procedures and troubleshooting. Our Technology stack is: Microsoft SQL Server (MSSQL), Azure, CA ERWin, SQL Server 2016, SQL Server 2017. RESPONSIBILITIES
- Responsible for designing databases and ensuring their stability, reliability, performance
- Writing and troubleshooting Stored Procedures
- Design and implementing enterprise data models (conceptual, logical and physical)
- Hands-on experience in designing and implementing hybrid cloud solutions on Azure
- Supporting development teams from a database perspective
- Provide guidance and mentoring to others
Requirements
- Familiarity with Microsoft Azure, Azure Sql, Azure Data Flow
- Strong working experience designing ETL solutions (Azure Data Factory & SSIS)
- Expert-level knowledge of SQL Server 2014, 2016 and Azure SQL Database
- Expert at writing Stored Procedure and troubleshooting
- Must be a self-starter requiring minimal supervision and possesses excellent organizational and interpersonal skills
- Experience applying SAFe/Scrum/Kanban methodologies
- Experience designing data warehousing solutions
- In-depth understanding of database structure principles
- Erwin Data Modeling experience a plus
- Accounting and/or Tax knowledge background a plus
- No-SQL databases such as Azure Cosmos DB a plus
Benefits & conditions
-
$147,900-195,000 per year Our talented Integrated Center of Excellence (ICOE) Data & AI team is made up of globally recognized experts - and there’s room for more analytical and ambitious data professionals…
-
22 hours ago + *
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on careerjet.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
BB
Benedikt Bischof
about 4 years ago
AJ
Austin Joy
What Are The Top Skills Required For Azure Developers?
over 4 years ago
EM
Eli McGarvie
Data Engineer Salary UK
about 3 years ago
LM
Luis Minvielle
The Most Popular IT Jobs on the Market
over 2 years ago
MH
Michael Hunger
Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?
7 months ago
LM
Luis Minvielle
Top-Paying Tech Jobs (with Salaries)
over 2 years ago