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. Preferred candidates will 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
Candidate Interface
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. 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.
Zeektek