Dice Job Listing: Python/Pandas Automation Developer
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Zeektek, is seeking the following. Apply via Dice today!
Job Details:
Remote Role but must work in California - Contract to Permanent Job
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 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 the 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 the department.
- Internal Customer facing lead / contributor.
- Ability to navigate and identify organization resources / subject matter experts to obtain knowledge in a decentralized organization.
- Python / Pandas Developer Must work in California but Remote ok if you live in CA.