Job Description
We have a contract position that goes to the December 31st 2024. The position could be extended, or converted to a FTE. The position is for a Python / Pandas Automation Developer with strong experience in SQL programming. Experience with relational databases (Oracle, Teradata etc.), experience working with flat files (different delimiter, escape characters, common flat file issues)
Nice to have - Power BI, Power automate (MS environment), experience with APIs, experience with SFTP jobs, Snowflake
Candidates must sit in CA. The position is 100% remote and must work in Pacific hours.
Day-to-day 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).
- Ingest data 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
- Create Score cards for Health Information Exchanges and present them to HIEs.
- Work with different teams across the organization to get the answers to chase data needs.
- Re-engineer data processes in department.
Performance expectations/metrics
Expert in Python / Pandas coding, Coding in SQL, 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.
Internal/External Groups with which the Candidate will interface
- Required Skills/Experience: Expert in Python / Pandas, automation and Advanced SQL 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.
- Create Score cards for Health Information Exchanges and present them to HIEs.
Education Requirement
Computer Science or equivalent
Software Skills Required
Expert in Python, Advanced SQL, Automation, Running data analysis on RDBMS databases like Oracle, Teradata, Snowflake etc.
Excel, Power Point, Visio