Sr. ETL Developer / Data Engineer
Candidate Must relocate and be onsite 3 days a week in Brecksville, Ohio. Must be willing to go perm after 6 months, client will sponsor Sr. ETL Developer/Data Engineer Candidate must be onsite 3 days a week (just south of Cleveland, OhioMust be able and willing to convert after 6 months without a fee. (they will sponsor) Looking for strong:7+ years of experienceETLSQL (SSIS, SSRS & T/SQL) AzureSome PythonHeavy DataPrefer Healthcare
Title: Sr. Date Engineer / ETL Developer
Must have Heavy SQL Server and ETL
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 scalehigh-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 PremCreate 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