Data Analyst III - Python, Pandas, Power BI, Flat Files

We have a 6 month contract to hire for a highly skilled Data Analyst with 8–10 years of experience. This fully remote, CA-based role focuses on developing and automating data extracts using Python, Pandas, and SQL, ingesting and processing flat files, and building Power BI dashboards. The ideal candidate has strong experience with relational databases (Snowflake, Teradata, Oracle), data pipeline automation, and healthcare data analytics. Shift is 8-5pm PST. MUST HAVES: Expert in Python / Pandas, SQL, automation Operations – Coding in Python and SQL. Run, monitor, automate, oversee data processing jobs Data File / Flat file parsing. Ingesting data from flat files in database. Sending data extract in agreed file format to internal / external vendors. Working with flat files using different delimiters. Data Analysis using Python/SQL on data stored in RDBMS like Oracle, Snowflake, Teradata, SQL Server. Research data needs, location, completeness, accuracy of data. Interface with business customers. Automate jobs using Python and Re-engineer data processes in departmentInternal Customer facing lead / contributor Ability to navigate and identify organization resources / subject matter experts to obtain knowledge in a decentralized organization Ability to multitask on multiple projects in parallel NICE TO HAVES: Healthcare experience Experience with Power BI reporting/dashboards About this role: Provider Performance and Analytics team is engaged with many data exchange projects with external and internal entities to help in providing excellent provider / member care. Responsibilities: • Create and maintain complex data extracts in agreed upon file layouts and send to internal / external teams at specific frequency using Python, SQL, Excel, flat files (csv etc). Working with flat files using different delimiters. • Ingest data in different format from different internal teams / external vendors in our databases. • Automate data extract jobs / reports using Python scripts. • Supporting ad hoc requests from management to run data analysis and provide requested information. • Creating dashboards / reports using Power BI • Work with different teams across the organization to get the answers to chase data needs. • Re-engineer data processes in department. • Contractor will interact with Health Net of CA Business teams, Corporate teams, External Vendors including but not limited to Health Information Exchanges, Homeless entities, BH entities, Justice involved entities, Jurisdiction entities, Cozeva. Performance expectations: • Expert in Python, Pandas and SQL coding, create/ingest data extract from databases in agreed upon file layouts and send to internal / external teams at specific frequency. • Lead / Own a project and communicate with internal teams and external vendors. • Ability to multitask on multiple projects