Data Engineer

Sr.Data EngineerRosemont,IL (5 Days Onsite)Contract/Fulltime

Job DescriptionSenior-Level Data Engineer:

Bachelors with 7+ or Masters with 5+ experience in Computer Science, Engineering, Math or other quantitative field.7+ Experience with developing Batch

ETL/ELT

processes using SQL Server and

SSIS

ensuring all related data pipelines meets best-in-class standards offering high performance.7+ experience writing and

optimizing SQL

queries and stored Procedures for Data Processing and Data Analysis.7+ years of Experience in designing and building complete

data pipelines,

moving and transforming data for ODS, Staging, Data Warehousing and Data Marts using

SQL Server Integration Services

(ETL) or other related technologies.7 + years' experience Implementing

Data Warehouse solutions

(Star Schema, Snowflake schema) for reporting and analytical applications using SQL Server and SSIS ,or other related technologies.5+ years' Experience with

large-scale data processing

and

query optimization

techniques using TSQL.5+ years' Experience with implementing

audit ,

balance

and

control

mechanism in

data solutions3+ year experience with any

source control

repos like GIT, TFVC or Azure DevOps , including

branching

and merging and implement

CICD

pipelines for database and ETL workloads.2+ experience working with

Python

Pandas libraries to process semi structured data sets, and load them to SQL Server DB.Strong understanding of

DW concepts

including

3NF

and

Dimensional data models .5+ years' experience with

Data Modeling

techniques in Data Warehousing projects using any tool like Erwin, Visio, ER studio.Has in-depth knowledge of

ETL Design Patterns , Optimal

Data Flow

mechanisms and

SQL development

best practices.Perform

peer reviews

and take

ownership

of the data processes to ensure

quality of data

in data warehouse, downstream data marts.Experience working on

Banking

and

Financial domain

is preferred.Experience with mentoring team members, guide them to follow best pra

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.