Data Architect

Excelgens, Inc
Chicago, IL, United States
2 months ago

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

  1. Responsible for designing databases and ensuring their stability, reliability, performance
  2. Writing and troubleshooting Stored Procedures
  3. Design and implementing enterprise data models (conceptual, logical and physical)
  4. Hands-on experience in designing and implementing hybrid cloud solutions on Azure
  5. Supporting development teams from a database perspective
  6. Provide guidance and mentoring to others

Requirements

  1. Familiarity with Microsoft Azure, Azure Sql, Azure Data Flow
  2. Strong working experience designing ETL solutions (Azure Data Factory & SSIS)
  3. Expert-level knowledge of SQL Server 2014, 2016 and Azure SQL Database
  4. Expert at writing Stored Procedure and troubleshooting
  5. Must be a self-starter requiring minimal supervision and possesses excellent organizational and interpersonal skills
  6. Experience applying SAFe/Scrum/Kanban methodologies
  7. Experience designing data warehousing solutions
  8. In-depth understanding of database structure principles
  9. Erwin Data Modeling experience a plus
  10. Accounting and/or Tax knowledge background a plus
  11. 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.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · WWC Europe 2026

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

Videos

See all

Related articles

See all