Sr ETL Data Engineer - Need 9+ Years of Experience- W2 Only

Sr. ETL Developer/Data Engineer

Candidate must be onsite 3 days a week (just south of Cleveland, Ohio

Must be able and willing to convert after 6 months without a fee. (they will sponsor)

Looking for strong:

• 9+ years of experience
• ETL
• SQL (SSIS, SSRS & T/SQL)
• Azure
• Some Python
• Heavy Data
• Prefer Healthcare

Title: Sr. Date Engineer / ETL Developer

# Open: 1

Location: just south of Cleveland, OH

Remote / Hybrid Schedule: 3 day onsite and 2 remote (they can choose which)

Hours | shift | On Call | Timezone: 8-5 EST hours

Team: Database and Business Analytics

Duration: 6+ months with possibility to extend or convert (they will sponsor but must be able to convert after 6 months)

Start: ASAP

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.

Job Responsibilities (listed in order of importance and/or time spent)

• 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