Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Business Intelligence Analyst II


Posted: 8/10/2019
Job Reference #: *36AC42EA91EE5D53
Keywords: consulting

Job Description

Requisition Number

Post Date

Business Intelligence Analyst II

San Diego



American Specialty Health, Inc. is seeking an expereinced Business Intelligence Analyst II to join our growing organization. This position is a key part of the Reporting, Analytics & Evaluation team which is responsible for delivering best-in-class analytical data solutions. This position will develop, implement, and support reporting, analytics and business intelligence solutions to meet the information needs of the organization and its clients while provideing consulting services to the business users related to the use and management of data. This position will also design and maintain a library of reports to support client and internal operational needs, effectively communicates results of analysis, develop and document technical specifications all while adhering to high standards of data integrity and reporting timelines. As a company that heavily relies on cutting-edge IT operations to serve its members, ASH is seeking ambitious individuals with a strong team mentality and a genuine passion for software engineering.

You are invited to learn more about American Specialty Health's events on our events page.


  • 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. Assist in the development of automated and scalable data collection and reporting processes.
  • 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.
  • Identifies and evaluates recurring database issues, researches trends, and implements solutions.
  • Ability to analyze internal team processes, identify opportunities for improvement, and implement 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. Conduct training for team members and end-users when needed.
  • 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.


  • Bachelor’s degree in Computer Science, Informatics, Business, or other related quantitative field.
  • Minimum of 6 years experience of SQL report writing with advanced T-SQL skill set.
  • Minimum of 6 years of progressive work experience developing reports and advanced work experience with reporting tools including but not limited to SSRS.
  • Minimum of 4 years of progressive work experience with SSIS and SQL Visual Studio.
  • Advanced understanding of relational database architecture and business intelligence.
  • Experience with Ad-hoc and custom reporting requests.
  • Advanced Excel skills.
  • Experience in a managed health care setting preferred.
  • Experience with ASH processes and systems a plus.
  • Experience with agile development/SCRUM 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.
  • Strong leadership skills and ability to work collaboratively with a team.
  • 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.