SQL Business Intelligence Analyst

Location: Baltimore, MD
Date Posted: 06-02-2017
TITLE: Business Intelligence Analyst
REPORTS TO: Chief Information Officer FLSA: Exempt

The Business Intelligence Analyst is responsible for developing and deploying operational, analytics, and dashboard reporting based on the needs as determined by the organization.  The position will analyze requirements for the design in collaboration with the Healthcare Business Analyst and subsequently develop, implement, and document activities as well as schematics for ongoing use.  In addition, the position will review current schemas for opportunities for automation and optimization to ensure an efficient and effective data environment.    
As a Business Intelligence Analyst you will play an integral role in providing relevant data to support the mission and vision of the organization with the use of various industry standard automated tools (SQL, i2i, SSRS, etc.)
Planning and Organizing
  • Prioritize relevant activities based on multiple priorities to achieve assigned responsibilities within agreed upon timeframes.
  • Provide support to the development of training materials and training activities related to the reporting tools and applications.
  • Participate in the formulation of development procedures, standards, deployment/retirement and archiving as related to the reporting tools and applications.
  • Collaborate with team members to provide feedback on overall reporting process and propose areas for improvement or risk.
  • Provide consistent feedback to the Healthcare Business Analyst, data requestor, and other team members.
  • Communicate ongoing status of activities as it impacts data quality and project deadlines.
  • Where needed participate in meetings with data requestors, Healthcare Business Analysts, and analytics team.
Attention to Detail
  • Review and validate customer data as it is collected.
  • Ensure integrity of data collection and utilization.
  • Perform data profiling to identify and understand anomalies
  • Proven experience with data reporting using various development tools, for example SSRS, SSIS, SSMS, SSAS, Microsoft BI, and PowerPivot.
  • Expertise in relational and multidimensional database schemas
  • Strong analytical and SQL skills
  • Ability to translate complex technical terminology, concepts and issues in terms understandable to technical and non-technical management and resources staff
  • Strong interpersonal skills to resolve problems in a professional manner as well as participate in working groups.
  • Ability to handle multiple priorities and meet deadlines.
  • Experience with data modeling/related and ETL concepts preferred
  • Knowledge of agile and/or other development principles
  • Excellent problem solving skills
  • Bachelor’s degree specializing in MIS, Engineering, or equivalent work experience.
  • A minimum of 2-4 years MS SQL development experience is required.
  • 2-4 years’ report development experience with MS Reporting Services (SSRS) preferred.
  • Health care industry experience is highly preferred. 
  • Experience within an FQHC environment is desirable.
Work is typically performed in an office environment.
The specific statements shown in each section of this description are not intended to be all-inclusive. They represent typical elements considered necessary to successfully perform the job.
this job portal is powered by CATS