Data Analyst II (Data Warehouse/ETL) RealMed
THIS JOB HAS EXPIRED Availity delivers revenue cycle and related business solutions for health care professionals who want to build healthy, thriving organizations. Availity has the powerful tools, actionable insights and expansive network reach that medical businesses need to get an edge in an industry constantly redefined by change.
The Data Analyst II is responsible for the design of the ETL (extract, transform, and load) processes, data profiling, and data quality processes created for Availity internal and external business partners. The position will contribute to the development of data models and ETL processes. Incumbents may be called upon to serve multiple roles, such as, working directly with clients and leadership at various levels within the organization and with outside parties to research and identify operational business requirements with sufficient detail and clarity to allow the development of the data or reporting solution needed. This position is mainly focused on data mappings (source to target) in support of the ETL Developers and will have opportunities to learn other skillsets such as business intelligence reporting and/or ETL development.
Meet with customers, Product Support, Business Development or IT Development groups to determine the project requirements and negotiate timelines and deliverables.
Develop source to target mapping documentation supporting ETL processes
Perform complex data analysis across platforms using Entity Relationship Diagrams (ERDs).
Assist with special projects as assigned to contribute to Availity?s overall business goals. Projects could include ad hoc reporting, searches and reviews, program evaluation, quality initiatives, analysis, development, etc.
Work with the ETL Architect to handle, clean, and merge data using ETL (Extract, Transform, and Load) standards and methodologies.
Ensure newly generated data is mapped to Data Mart, ODS, and/or Data Warehouse.
Identify problems and inaccuracies in databases. In collaboration with the Data Steward, assist in developing decision rules for handling data problems.
Apply rules consistently to correct data problems.
Develop and maintain protocols for how to handle, process, and clean data.
Work with Data Steward document how data problems were identified and corrected.
Support the work load and priorities of other Data Analysts which includes CR?s, support tickets and ad hoc requests as needed.
Develop and maintain the workflow processes for all reporting requests
Support processes and standards that result from purchasing any third party tool. Best practice approaches and processes should be taken into consideration.
WORK EXPERIENCE & SKILLS (Required)
Minimum of 5 years? experience in a data warehouse environment with SQL and data analysis experience
Mastery of SQL language.
Experience in an Oracle production environment.
Experience using TOAD for Data Analysis
Strong and recent experience supporting the design and development of data models for a data warehouse environment
Strong relationship management and collaboration skills.
Excellent written and verbal communication skills.
Ability to work with a minimal amount of direction while being pro-active in keeping their management informed of project related issues.
Ability to establish and maintain effective working relationships.
Demonstrated ability to use discretion and make sound decisions.
Ability to work under pressure. Maintains composure and professionalism in an interrupt-driven environment. Must be able to multi-task.
Must be flexible and embrace change.
Knowledge of relational databases; design, structure, data associations, and query language.
Proficient with Microsoft Office software to include; Outlook, Word, Excel, and Access.
Excellent problem solving, organizational, and priority management skills.
WORK EXPERIENCE & SKILLS (Preferred)
Experience with Oracle databases
Experience with accounting processes and software (i.e. Great Plains)
ETL tools such as Informatica and SSIS.
Experience with Cognos 10.x
EDUCATION AND CERTIFICATION (Required)
Bachelor?s degree or the equivalent in work experience.
EDUCATION AND CERTIFICATION (Preferred)
Extensive knowledge of the health care industry specifically claims processing systems, provider office operations, and customer service processes in a health care company.
Experience working in an entrepreneurial company
||Jacksonville, FL |
THIS JOB HAS EXPIRED