Technosmarts
Data Analyst 4
Technosmarts, Los Angeles, California, United States,
JOB TITLE:
Data Analyst 4
SHIFT (START/END TIME):
Regular Shift – Weekdays 8 AM to 5 PM PST;
No OT required
WORK LOCATION IF NOT REMOTE:
Remote.
Candidates MUST reside in CA.
JOB DESCRIPTION / 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.
Completing all required training.
Checking / getting all required system accesses.
Performance expectations/metrics for this individual and their team:
Expert in Python, Pandas and SQL coding, 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, 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.
PREFERRED SKILLS/ EXPERIENCE
Power BI reporting and dashboards
Healthcare Domain, HL7 V2 , HL7 V3 data formats
SOFTWARE SKILLS REQUIRED
Expert in Python/Pandas and SQL. Automation of jobs, Running data analysis on RDBMS databases like Oracle, Teradata, Snowflake etc.
Excel, Power Point, Visio
EDUCATION REQUIREMENT
Computer Science or equivalent
#J-18808-Ljbffr
Data Analyst 4
SHIFT (START/END TIME):
Regular Shift – Weekdays 8 AM to 5 PM PST;
No OT required
WORK LOCATION IF NOT REMOTE:
Remote.
Candidates MUST reside in CA.
JOB DESCRIPTION / 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.
Completing all required training.
Checking / getting all required system accesses.
Performance expectations/metrics for this individual and their team:
Expert in Python, Pandas and SQL coding, 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, 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.
PREFERRED SKILLS/ EXPERIENCE
Power BI reporting and dashboards
Healthcare Domain, HL7 V2 , HL7 V3 data formats
SOFTWARE SKILLS REQUIRED
Expert in Python/Pandas and SQL. Automation of jobs, Running data analysis on RDBMS databases like Oracle, Teradata, Snowflake etc.
Excel, Power Point, Visio
EDUCATION REQUIREMENT
Computer Science or equivalent
#J-18808-Ljbffr