Data Engineer

Role:Data Engineer Duration: 6-12 Months Location: Remote Project Scope: Contract to hire - ETL Person leaving so this will essentially be backfilling them Going to be filled through the new CoE - Center of Excellence Has around 15 members right now State of Arkansas project – Medicaid Decision Support System Currently in Informatica/SQL and will be moving all ETL to Azure Data Factory/Snowflake as a database Must-Haves: · 5 + years of data engineering experience · Experience creating pipelines in ADF · Understanding of other ETL tools (i.e. SSIS or Informatica) · Strong SQL skills Job Description: As a member of the Optum Data Management team, the Data Engineer supports the Arkansas Medicaid Decision Support System (DSS) by developing and maintaining workflows, identifying, and resolving data quality issues, and optimizing processes to improve performance. The Data Engineer will also support intrastate agencies by monitoring automated data extracts and working directly with state partners to create new extracts based on business specifications. The preferred candidate will be a creative thinker who is comfortable working independently or in teams. They will be a quick learner who is confident they can master a complex ETL model with little guidance. The candidate will be detail-oriented, well organized, and able to manage multiple assignments at once. Minimum Qualifications: · 5+ years of Data engineering experience with a focus on Data Warehousing · 2+ years of experience creating pipelines in Azure Data Factory (ADF) · 5+ years developing ETL using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools. · 5+ years of experience with Relational Databases, such as Oracle, Snowflake, SQL Server, etc. · 3+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL · 2+ years of experience with GitHub, SVN, or similar source control systems · 2+ years of experience processing structured and un-structured data. · Experience with HL7 and FHIR standards, and processing files in these formats. · 3+ years analyzing project requirements and developing detailed specifications for ETL requirements. · Excellent problem-solving and analytical skills, with the ability to troubleshoot and optimize data pipelines. · Ability to adapt to evolving technologies and changing business requirements. · Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Preferred Qualifications: · 2+ years of batch or PowerShell scripting · 2+ years of experience with Python scripting. · 3+ years of data modeling experience in a data warehouse environment · Experience or familiarity with Informatica Intelligent Cloud Services (specifically Data Integration) · Experience designing and building APIs in Snowflake and ADF (e.g. REST, RPC) · Experience with State Medicaid / Medicare / Healthcare applications · Azure certifications related to data engineering or data analytics -- -- --- ---- Thanks & Regards, Ujwala Pinninti Thoughtwave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6302168656, EXTN: 156 Email: ujwala@thoughtwavesoft.com Website: www.thoughtwavesoft.com Linked in: https://www.linkedin.com/in/ujwala-pinninti-675285213/ 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.