Data Analyst

Job Summary:

• 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.

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.
• Computer Science or equivalent.
• Expert in Python, Advanced SQL, Automation, Running data analysis on RDBMS databases like Oracle, Teradata, Snowflake etc.
• Excel, Power Point, Visio.

Preferred Skills/Experience:

• Power BI reporting and dashboards.
• Healthcare Domain, HL7 V2 , HL7 V3 data formats.
• Computer Science or equivalent.

Location:

TELECOMMUTE, Missouri

Job Type:

Contract

Salary:

$51 - 61 per hour

Work Hours:

8am to 5pm

Education:

Bachelors

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.

Qualifications:

• Experience level: Experienced
• Education: Bachelors