Position Details
We have a contract position that goes to the December 31st 2024. The position could be extended, or converted to a FTE.
Position Requirements and Responsibilities
-
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
-
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.
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. Interface with business customers.
-
Automate jobs using Python and Re-engineer data processes in department
-
Internal 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
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