Senior Data Engineer

Insight Global

Aurora, CO, United States

18 days ago

Role details

Contract type

Contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Compensation

$124,800.0 - $145,600.0

Working hours

Regular working hours

Job source

www.techcareers.com

Tech stack

Agile Methodology Microsoft Azure Information Systems Data Architecture Data Integration Extract Transform Load (ETL) Data Mart Data Transformation Data Vault Modeling DevOps R (Programming Language) Python (Programming Language)

+16 more

Microsoft SQL Server Microsoft Business Intelligence Systems Development Life Cycle Standard Sql SQL Databases SQL Server Analysis Services Transact-SQL Unstructured Data Enterprise Data Management Azure Data Factory Apache Spark Data Layers Data Lakes 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!