Data Engineer

Role- Data Engineer Duration- 6 Months Location- Remote2/C2C): 63-68/ hr. Tech (Qualification) Notes: Snowflake, Azure, Data Pipelines, Data Warehouse, ETL, Python, Creating Stored Procedures, Data Models, CI/CD pipelines At least 5 years of experience Healthcare data understanding Description: Do you want to impact decisions to help people live healthier lives? Are you an innovative Data Engineer who thrives on developing new solutions to solve tough challenges? We want to achieve more in our mission of health care, and so we have to be really smart about the business of health care. At Optum, we're changing the landscape of our industry. You will put your Data Engineering skills to work as you empower business partners and team members improve healthcare delivery. You will research cutting edge big data tools, and design innovative solutions to solve business problems that only a Data Engineer can. You'll be in the driver's seat on vital projects that have strategic importance to our mission of helping people live healthier lives. Yes, we share a mission that inspires. And we need your organizational talents and business discipline to help fuel that mission. You will be part of the team who is focused on building a cutting-edge data analytics platform to support reporting requirements for the business. As a Senior Data Engineer, you will be responsible for the development of complex data sources and pipelines into our data platform (i.e. Snowflake) along with other data applications (i.e. Azure, Airflow, etc.) and automation. This is a fully remote role based in the United States. Your counterpart team is located in Dublin, Ireland office. While there is no requirement to work in shift hours, there might be an occasional call with Dublin team which can require flexible working. Primary Responsibilities: • Create & maintain data pipelines using Azure & Snowflake as primary tools • Create SQL Stored procs, Macros to perform complex transformation • Creating logical & physical data models to ensure data integrity is maintained • CI CD pipeline creation & automation using GIT & GIT Actions • Tuning and optimizing data processes • Design and build best in class processes to clean and standardize data • Code Deployments to production environment, troubleshoot production data issues • Modelling of big volume datasets to maximize performance for our BI & Data Science Team • Create Docker images for various applications and deploy them on Kubernetes Qualifications: Required Qualifications: • Computer Science bachelor's degree or similar • Min 3-6 years of industry experience as a Hands-on Data engineer • Excellent communication skills • Excellent knowledge of SQL, Python • Excellent knowledge of Azure Services such as - Blobs, Functions, Azure Data Factory, Service Principal, Containers, Key Vault etc. • Excellent knowledge of Snowflake - Architecture, best practices • Excellent knowledge of Data warehousing & BI Solutions • Excellent Knowledge of change data capture (CDC), ETL, ELT, SCD etc. • Knowledge of CI CD Pipelines using GIT & GIT Actions • Knowledge of different data modelling techniques such as Star Schema, Dimensional models, Data vault • Hands on experience on the following technologies: o Developing data pipelines in Azure & snowflake o Writing complex SQL queries o Building ETL/ELT/data pipelines using SCD logic o Exposure to Kubernetes and Linux containers (i.e. Docker) o Related/complementary open-source software platforms and languages (e.g. Scala, Python, Java, Linux) • Previous experience with Relational Databases (RDBMS) & Non- Relational Database • Analytical and problem-solving experience applied to a Big Data datasets • Good understanding of Access control and Data masking • Experience working in projects with agile/scrum methodologies and high performing team(s) • Exposure to DevOps methodology • Data warehousing principles, architecture and its implementation in large environments • Very good understanding of integration with Tableau Preferred Qualifications: • Design and build data pipelines (in Spark) to process terabytes of data • Very good understanding of Snowflake integration with data visualization tool such as Tableau • Orchestrate in Airflow the data tasks to run on Kubernetes/Hadoop for the ingestion, processing and cleaning of data • Terraform knowledge and automation • Create real-time analytics pipelines using Kafka / Spark Streaming • Work on Proof of Concepts for Big Data and Data Science • Understanding of United States Healthcare data -- ---- Thanks & Regards, Tejash - Technical Recruiter Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6304918494 EXTN: 157 Email :tejash@thoughtwavesoft.com Website:www.thoughtwavesoft.com https://www.linkedin.com/in/tejash-chettipalli-342aa2246 A Certified Minority Business Enterprise, Disadvantaged Business Enterprise, SAM.gov, SOC2 & ISO2005, Vendors for: · STATES: IL, PA, TN, AK, OR, CT, GA, VA, ID, IA, UT, FL, MN & CO · NATIONAL LABS: ARGONNE & FERMI · COUNTIES: HENNEPIN, MN, FULTON & GA · PUBLIC SCHOOLS: ATLANTA. SECURITY NOTICE: This communication, including any accompanying document(s), is for the sole use of the intended recipient and may contain confidential information. Unauthorized use, distribution, disclosure or any action taken or omitted to be taken in reliance on this communication is prohibited, and may be unlawful. If you are not the intended recipient, please notify the sender (admin@thoughtwavesoft.com) by return e-mail or telephone (630-448-6681) and permanently delete or destroy all electronic and hard copies of this e-mail.