Sign in

Technical Data Analyst 6075

Company:
Dedicated Tech Services, Inc.
Location:
Columbus, Ohio, United States
Posted:
October 22, 2018

Description:

U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Applicants only, no corp-to-corp candidates, third parties, or agencies please.

Required Skills and Experience:

• Data analysis experience

• Data profiling, mapping, cleansing, and quality experience

• Strong SQL query skills for relational databases (Postgres, Redshift)

• Ability to analyze business needs to determine technical requirements and communicate with engineers and business stakeholders.

• Understand data warehouse concepts, schemas, relational and dimensional data models.

• Organization skills to understand project status, answer support questions, and handle multiple, sometimes conflicting, priorities and requests.

• Agile

Desired Skills and Experience:

• Data modelling

• Alation data catalog

• Healthcare/clinical data experience; Varian/Onco EMR; EDI 837/835

• HIPAA/PHI/HiTrust privacy/security understanding

• Jira and Confluence

• Jupyter notebooks

• Scrum, Kanban, and agile processes and methods

• Acceptance test driven development (ATDD) requirements methods

Job Description:

We are seeking a Technical Data Analyst to join our team and work at our client location in a long-term, right-to-hire position. You will work in an exciting, collaborative, and diverse environment in which you’ll be a key member of the team, exercising your functional, interpersonal, communication, and technical skills while having full accountability for requirements deliverables and artifacts. Specifically, you will:

• Daily Operations

o Execute queries to ensure all files were received from vendors as expected, all data was ingested, exports occurred, and data quality counts are matching expectations.

o This role will be the initial triage point for all issue resolution with vendors and customers if data was not imported or exported as expected. Contact vendors to arrange for data to be re-sent and communicate with downstream customers as to the status of issues resolution. Escalate to management, stakeholders, engineering, and infrastructure staff as necessary.

o Ensure data quality by analyzing counts of data sent, processed, and received. Identify and investigate data anomalies in the data warehouse and create defect cards for corrections of code and/or data.

• Pre-WIP workflow

o Based on roadmap items, business needs, and upcoming projects, decompose epics into user stories that include technical requirements for development; sources of information will be product owner and tech lead. Lead team JAD discussions, and issue sizing and prioritization to answer questions about requirements to ensure defect-free completed work.

o For small projects, work directly with stakeholders and other technical teams to plan sequencing and timeline for development and testing activities.

• Acceptance of cards

o For completed work, perform issue acceptance activities, ensuring requirements were met, check non-prod data to ensure correct processing.

• Process documentation

o Document standard operating procedures and team processes; organize the team document repository.

o Create process models and diagrams to communicate internal application processes for business stakeholders.

o Using data catalog tool, document, annotate, and describe data assets for others to understand available data and metadata for feasibility analysis.