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
$ 195KJob 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
- 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