Data Analyst

Job Summary

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). Working with flat files using different delimiters.
• Ingest data in different format 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
• 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, SQL, automation
• 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/Pandas and SQL. Automation of jobs, 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

Alexandria, California

Job Type

Contract

Salary

$46 - 56 per hour

Work Hours

8am to 5pm

Education

Bachelors

Qualifications

• Experience level: Experienced
• Education: Bachelors