ETL Developer/Data Engineer

3S Business Corporation Inc.

Cleveland, OH, United States

8 days ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

9 years minimum

Working hours

Shift work

Job source

www.dice.com

Tech stack

Query Performance Artificial Intelligence Microsoft Azure Cloud Computing Code Review Databases Extract Transform Load (ETL) Data Mapping Data Mining Python (Programming Language) SQL Databases SQL Server Reporting Services

+5 more

SQL Server Integration Services Stemming Transact-SQL Snowflake Data Pipelines

Job description

Performs advanced business analysis using various techniques, e.g., data mining, predictive modeling.
Ensures the use of business intelligence applications enhances business decision making capabilities. The role is collaborative with other departments, lead various large scale
high-profile projects, huge impact in business making decisions, and provide guidance to BI resources., * Design, develop and implement scalable and high-performance data pipelines that performs ETL loads into enterprise repository
Collaborate with various business units to gather requirements, transforms the requirements into technical solutions
Write efficient store procedures/packages, provide operational support, diagnose, and resolves production issues, superior troubleshooting skills
Develop code to extract data from various cloud environments (Azure, Snowflake) and stage the data on Prem
Create dataset from staged environment for AI team, upload the dataset to AI cloud environment
Collaborate with AI team to understand the data requirements, perform data mapping, extract the required data from multiple source systems
Proficient in writing advance T SQL s, writing store procs, developing SSRS reports, troubleshoot existing reports, suggest, and apply appropriate fixes
Independently review and schedule new jobs, resolve performance issues stemming from inefficient queries
Lead efforts in troubleshoot query performance issues, pro-actively collaborate with DBA team to resolve query/database locking
Review the existing integrations (ETL Extract Transform Load) of legacy/new systems process, suggest and lead design modifications
Lead effort in peer code review before promoting to production, ensures production stability is maintained
Support, maintain and document BI functionality, regularly review and update document on share-point