Senior Data Engineer

Insight Global
Aurora, United States of America
2 days ago

Role details

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

Job location

Aurora, United States of America

Tech stack

Agile Methodologies
Azure
Information Systems
Data Architecture
Data Integration
ETL
Data Mart
Data Transformation
Data Vault Modeling
DevOps
R
Python
Microsoft SQL Server
Microsoft Business Intelligence
Systems Development Life Cycle
Standard Sql
SQL Databases
SQL Server Analysis Services
T-SQL
Unstructured Data
Enterprise Data Management
Azure
Spark
Data Layers
Data Lake
PySpark
Data Pipelines
Legacy Systems

Job description

A Higher Education client of Insight Global is seeking a Senior Data Engineer with at least seven years of experience designing, building, and supporting modern enterprise data platforms. This individual will be responsible for designing, developing, and maintaining enterprise data warehouses, data marts, semantic models, and scalable data integration frameworks that support structured, semi-structured, and unstructured data. The ideal candidate will have strong experience with Python, SQL, R, Spark Scala, PySpark, SparkSQL, Azure cloud infrastructure, MSBI, SQL Server, T-SQL, and SQL Server Analysis Services (SSAS), along with expertise in data modeling, ETL/ELT development, and modern data architecture., In this role, the Senior Data Engineer will gather business and technical requirements, develop and deploy data lake, lakehouse, and data warehouse solutions, and support the migration of legacy platforms to Azure. Responsibilities also include designing dimensional models, star schemas, and data vault architectures; implementing data transformation, cleansing, and quality assurance processes; supporting Agile development methodologies and modern SDLC/ALM practices; and providing ongoing maintenance, modernization, and support for legacy MSBI environments. The successful candidate will possess excellent problem-solving and customer service skills, work closely with cross-functional stakeholders.

Requirements

  • Bachelor's degree in business, information systems, or related fields - may be substituted with appropriate years of experience in similar domains.
  • 7+ years of experience with Data Modeling (Relational and Dimensional) and ETL/ELT (Extract-Transform-Load), Pipeline development and orchestration, foundation data layer solution architecture
  • Experience with most or all of the following: including SQL, Python, R, Spark Scala, PySQL, SparkSQL, Azure infrastructure, MSBI
  • Strong SQL experience: SQL Server, T SQL, and SQL Server Analysis Services
  • Azure Data Engineering experience (Azure Data Factory, SQL database, DevOps) and experience with migration to Azure from legacy platforms

Benefits & conditions

This position is a 6 month contract role with possibility of extensions and/or conversion, and can pay between $60-70/hour with medical benefits and 401k options offered on contract. If interested, please apply!

Apply for this position