Datawaterhouse Business System Analyst

Trinity ERP, LLC; San Jose (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading company seeks a Lead Business Analyst in San Jose, responsible for partnering with business owners to gather and document analytic requirements. The role involves extensive collaboration on data integrity, programming, and analysis, requiring excellent problem-solving and communication skills. Ideal candidates possess 6-8 years of healthcare data experience and a BA/BS in a related field, along with proficiency in data modeling and SQL.

Qualifications

• 6-8 years' experience in healthcare data analysis and business requirements.
• Experience with programming languages and management care operations.
• Excellent oral and written communication skills.

Responsibilities

• Acts as lead business analyst across business and technical teams.
• Analyzes complex business user needs and documents information requirements.
• Supports validation and testing of data structures and definitions.

Skills

Analytical skills

Problem-solving

Data modeling

Planning and organizational skills

Communication

Education

BA/BS in related field

Tools

Teradata SQL

SAS

Business Objects

OLAP

Job description

Responsible for partnering with business owners and stakeholders to gather and document analytic requirements supporting the enterprise data warehouse.

Primary duties may include, but are not limited to:

• Acts as lead business analyst by working across business and technical teams to support enhancement projects/programs, lights-on activity, and issues/defects within the analytic environment.
• Establishes and maintains excellent knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues.
• Analyzes more complex business user needs, documents information requirements, facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.
• Ensures proper data definitions, ownership, use and integrity of data.
• Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.
• Supports the validation and testing of data structure design, definitions and mapping, including business rules.
• Facilitates calls with business stakeholders to discuss data requirements.
• Delivers quality results while working on multiple project assignments.
• Instructs, directs and reviews work of less experience data warehouse analysts.
• Maintains information policies and procedures to support current and future data information needs
• Completes metadata assessment and reviews feedback to determine changes needed.
• Collaborates with IT resources on the creation and maintenance of the content of the data warehouse, establishes and maintains strong knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues, completes metadata assessment and reviews feedback to determine changes, ensures that data definitions are clear and current, and communicates changes to data definitions to all users.

Qualifications

• Requires BA/BS in related field.
• 6-8 years’ experience in healthcare data analysis, business requirements, data modeling, and working with automated data warehouse systems.
• Any combination of education and experience, which would provide an equivalent background.
• Experience with programming languages and various statistical programs in addition to general knowledge of major components of managed care operations required.
• Excellent analytical, problem-solving and PC skills required.
• Demonstrated ability to lead and plan large-scale projects required.
• Experience in Teradata SQL, SQL, SAS, Business Objects, and OLAP preferred.
• Excellent analytical, communication, problem-solving, and planning and organizational skills required.
• Demonstrated ability to lead and plan complex, large-scale projects required.
• Excellent oral and written communications skills.
• Financial data knowledge for all data types.
• Methodologies: Rational, Agile and Waterfall
• Business process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD/JRP Sessions, Gap Analysis and Impact Analysis.