The Data Analyst is responsible for supporting the business community needs for data collection, analysis, and reporting from a variety of sources including mainframe files, data warehouse reports, and vendor extracts. The Data Analyst will collect, organize, and analyze data for easy use by internal business and analytical clients, and serve as an expert on data availability and quality. In addition this position includes providing technical support for scheduling, job setup, coordinating with programmers to analyze batch requests and developing automated schedules.
Essential Functions:
- Collects and organize data from mainframe files, data warehouses, vendor extracts, departmental spreadsheets and databases, and internet/intranet sites for easy use by internal business and analytical clients.
- Ensure the integrity of all data for the purposes of maintaining regulatory compliance, triaging data problems directly to the vendors and clients.
- Communicates status to management or lead.
- Create and maintain databases as a tool for delivering data to internal clients.
- Translate customer business requirements needs into a final product.
- May provide guidance to less experienced data analysts.
- At a more complex level prepares production jobs for processing, and assures quality control by verifying results of the computer run in accordance with established procedures.
- Assures quality control by verifying results of the computer run in accordance with established procedures.
- Troubleshoots and resolves escalated job failures and anomalies.
- Recommends and assists in the development and implementation of maintenance policies.
- Reviews and ensures adequacy of technical operating instruction manuals, system documentation, standards and procedures.
- Attends and participates in release, publication, solutioning and project meetings and activities.
- Responsibilities impact the achievement of key department and/or functional objectives.
- Contributes to the achievement of department objectives.
- Erroneous decisions or failure to achieve department objectives would normally affect expenditures and resources.
- Involves interpreting and analyzing established concepts.
- Exercises judgment to make decisions for less defined issues and selects methods and techniques for obtaining solutions.
- Requires moderately complex decision-making.
- Develops solutions to complex problems.
- May refer to established precedents and policies when making decisions.
- Requires significant analysis to develop solutions for complex problems.
- Provides professional/technical guidance to team members.
- Influences others regarding existing concepts, processes and/or methodology.
- Participates in determining objectives of assignment.
- Works under limited direction.
- Plans schedules and arranges own activities in accomplishing objectives.
- Work is reviewed by management at key intervals for advice and guidance prior to completion.
- Provides periodic informal work guidance/direction to, and training of team members.
- Provides performance input and recommendations to management for development/training plans.
- Does not have formal supervisory responsibilities.
Qualifications:
Basic Qualifications:
- Eight (8) to ten (10) years of experience required, including mainframe, large databases or data warehouses, JCL, schedulers, data analysis and production of datasets.
- Two (2) or more years of experience in SAS and large databases/sets or data warehouses.
- Bachelor's degree or equivalent experience in healthcare, finance, information systems or related area or equivalent experience.
- May have post-graduate education or training
- Expert understanding of databases, data relationships, quality and integrity.
- Expert with query tools such as SQL and WinSQL.
- Proficient with Microsoft Excel.
- Extensive use of shared server files, other in-house applications, file transfer and encryption programs.
- Requires strong communication skills, ability to keep up with technological changes, techniques and improvements, and apply those to current environment, strong customer service focus, and good organizational and time management skills.
- Excellent knowledge of internet, intranet, mainframe, and PC environments.
- Proven ability to work with customers to understand business requirements and translate those needs into a final product.
- Requires an understanding of financial information systems.
- Problem solving skills including the ability to research and initiate a data extract and report that answers key questions not answerable using known sources.
- Requires that analyst be an expert on data availability and quality, have a strong understanding of the business requirements, and the creativity to develop workable solutions for a wide ranges of customers.
External hires must pass a background check/drug screen.
We are proud to be an equal opportunity/affirmative action employer.