Data Architect

Excelgens, Inc
Chicago, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 195K

Job location

Chicago, United States of America

Tech stack

Azure
Databases
Data Architecture
ETL
Data Warehousing
Database Schema
Software Debugging
Microsoft SQL Server
SQL Azure
NoSQL
Scrum
SQL Stored Procedures
SQL Server Integration Services
Azure
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