Business Intelligence Analyst

Reporting & Data Analysis San Diego, California


Description

American Specialty Health Incorporated is seeking a Business Intelligence Analyst I to join our Information Management (IMD) department. This position will develop, implement, and support reporting, analytics, and business intelligence solutions to meet the information needs of the organization and its clients. Provides consulting services to the business users related to the use and management of data. Designs and maintains a library of reports to support client and internal operational needs. Effectively communicates results of analyses. Develops and documents technical specifications. Adhere to high standards of data integrity and reporting timelines.

Responsibilities

  • Manages assigned projects and supports activities of team. Ensures prompt completion of specific deliverables. Ensures accuracy and productivity in project completion and works cooperatively with all internal and external contacts. Analyzes, evaluates, and documents data requests of business stakeholders to understand and prioritize requests appropriately.
  • Support client telephone calls to identify technical needs of reports and establish working relationships with client technical teams.
  • Build and maintain relationships with account managers to meet client information objectives.
  • Apply critical thinking skills by interacting directly with the report requestor and implement the criteria and analysis.
  • Translates user non-technical requirements to existing data sources. Develop and maintain custom reports using T-SQL and Reporting Services as well as standard Microsoft tools such as Excel.
  • Develop stored procedures and views to support custom reporting.
  • Maintains assigned report requests, determines resource needs for requests and works with Management to prioritize.
  • Develops and maintains report schedules.
  • Performs analysis of data sources and designs processes to ensure data integrity, completeness, timeliness, and accuracy.
  • Documents business requirements in the form of specifications (operational and technical specifications) and obtains necessary input and approval.
  • Develops methods to efficiently transmit reports including web-based tools and standard report-based transmissions.
  • Produce data and analyses in format appropriate to request such as common delimited, CSV format, etc.
  • Work with EDI team to post files to internal and external FTP sites.
  • Contributes to the business analysis for reporting requirements.
  • Maintains a solid working knowledge of business intelligence tools and follows best practices.
  • Provide support for the development of a data warehouse.
  • Develop and maintain reporting solutions to support clients and for decision support purposes.
  • Migrate reports from multiple solutions to standard reporting toolset.
  • Assist in the development of automated and scalable data collection and reporting processes.
  • Identifies and evaluates recurring database issues, researches trends, and implements solutions.
  • Assist with a variety of other data collection, storage, and reporting processes as needed, which may include: consolidating data from disparate sources, such as Excel, Access, and text files so that they can be integrated into SQL databases.
  • Collaboratively work with assigned staff and ensures that accuracy and productivity meet/exceed company standards.
  • Coordinates workflow of department ensuring that productivity, quality, and timeliness standards are met.
  • Provides constructive feedback and conducts counseling and training sessions as required.
  • Interviews and recommends the hiring of new staff members as required.
  • Supports department functions as they interface with other departments to ensure efficient and effective teamwork within the organization as defined by management.
  • Serve as a reporting expert for the team and the organization, which may include developing report requests and interpreting data.
  • Generates and conducts quality review on ad-hoc and scheduled reports as needed.
  • Analyzes efficiency of current processes, makes recommendations and streamlines/automates processes.
  • Provides timely responses to internal and external inquiries.
  • Conduct training for team members and end-users when needed.

Qualifications

  • Bachelor’s degree in Computer Science, Informatics, Business, or other related quantitative field required.
  • Minimum of 4 years experience of SQL report writing with strong T-SQL skill set or comparable.
  • Minimum of 4 years of progressive work experience developing reports and strong work experience with reporting tools such as SSRS or comparable.
  • Minimum of 2 years of progressive work experience with SSIS or comparable.
  • Strong understanding of relational database architecture and business intelligence.
  • Experience with ad-hoc and custom reporting requests.
  • Highly proficient in Excel.
  • Proficient in Outlook.
  • Experience in a managed health care setting preferred.
  • Experience with ASH processes and systems a plus.
  • Excellent verbal and written communication skills required with ability to communicate effectively and partner with senior level staff to determine business goals and objectives, and ways to partner in order to achieve those objectives.
  • Ability to translate business requirements to technical specifications.
  • Knowledge of business operations, database structures, and reporting solutions to meet business needs.
  • Ability to think abstractly beyond basic data requirement.

Core Competencies

  • Demonstrated ability to interact in a positive, respectful manner and establish and maintain cooperative working relationships.
  • Ability to display excellent customer service to meet the needs and expectations of both internal and external customers.
  • Excellent listening and interpersonal communication skills to identify critical core competencies based on success factors and organizational environment.
  • Ability to effectively organize, prioritize, multi-task and manage time.
  • Demonstrated accuracy and productivity in a changing environment with constant interruptions.
  • Demonstrated ability to analyze information, problems, issues, situations and procedures to develop effective solutions.
  • Ability to exercise strict confidentiality in all matters.

Mobility

Primarily sedentary, able to sit for long periods of time with ability to travel within and outside the facility.

Physical Requirements

Ability to speak, see and hear other personnel and/or objects. Ability to communicate both in verbal and written form. Ability to travel within the facility. Capable of using a telephone and computer keyboard. Ability to lift up to 10 lbs.

Environmental Conditions

Within facility, normal office conditions, including lighting and ventilation. Minor noise from conversations and general office equipment (telephone, printer, etc.). When required to travel outside the facility, usual weather, traffic, and related conditions are applicable.

American Specialty Health is an Equal Opportunity/Affirmative Action Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law. 

Please view Equal Employment Opportunity Posters provided by OFCCP here.

If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact our Human Resources Department at (800) 848-3555 x6702.

ASH will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Company’s legal duty to furnish information.