BI/Database Engineer

***MUST BE VACCINATED Or have exemption Medical or Religious-  Paperwork required 

Job Title: Database Engineer 

Job Summary

 responsible for the overall database architecture and performance capacity planning of the database.

Essential Functions and Work Responsibilities

Estimated Percent of time Spent – 100%

  • Designs and creates data models, develops and implements databases to support applications to accommodate a variety of user needs.
  • Analyzes and determines informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements and data output and reporting capabilities.
  • Defines logical attributes and inter-relationships and designs data structures to accommodate application needs.
  • Tests designed applications utilizing database management software or general programming software.
  • Gathers system and database metrics pertaining to the running of databases to identify and resolve problems; determines and develops performance enhancements with measurable benchmarks.
  • Works with DBA and Productions Services staff to monitor the running of databases to identify and resolve problems; continues performance enhancement with measurable benchmarks.
  • Researches, installs, and tests software updates and patches to supported databases and various applications.
  • Serves as a liaison with vendors and other third-party providers.
  • Functions as part of the Applications and Systems organization to provide Level III technical support to resolve complex problems with applications, database systems and database interface code.
  • Design, implementing and strategizing database systems and other system components, implement identified solutions, make suggestions for ensuring a cost-effective and efficient database infrastructure that provides the necessary data processing power essential to the business operations.
  • Owns the database design/modeling portion of  IT projects through the all project stages, preparing a technical design that reflects business requirements and is consistent with IT Strategy and overall IT Architecture.
  • Evaluate new technologies and develop project proposals for new IT services, including pilots and production applications and services.
  • Works with DBA and Productions Services staff to researche new technologies and present recommendations on major hardware and software purchases that reflects business requirements and is consistent with IT Strategy and overall IT architecture for the enterprise.
  • Works with DBA and Productions Services staff to provides best practice to follow for local and remote database systems including user administration, automation, patch management, backup and restore, capacity/log monitoring, clustering, replication and migration.
  • Recognizes and identifies potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion.
  • Generates, communicates, and trains development groups the Standard Operating Procedures (SOPs).
  • Works under minimal supervision with latitude for independent judgment.
  • May consult with senior peers on certain projects.
  • Mentors less senior Database Architects.
  • May act as a technical project leader or provide work leadership for lower level employees.
  • Does not include full supervisory responsibilities.
  • Other duties as assigned.

 

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

Education

  • Bachelors/Masters Degree in Computer Science, a related field or equivalent experience (Required) 

 

Licensure, Certification, Registration or Designation: (Nice To Have)

  • MCDBA – Microsoft Certified Database Administrator Credential

Work Experience and Qualifications

  • 5-9 years of progressively responsible database design and implementation experience

 

Other Knowledge Skills and Abilities Required

Computer Skills  

  • Must be computer proficient and possess experience with Microsoft Word, Excel, and Outlook.
  • Must be able to quickly learn specific software and new applications.

Other Skills and Abilities:

  • Able to establish and maintain cooperative and positive working relationships.
  • Organized, detail-oriented, diplomatic, proactive, self-motivated, dependable, and driven by excellence.
  • Even-tempered and able to balance multiple tasks in accordance with changing deadlines and priorities in a fast-paced environment.
  • Ability to work sensitively and effectively with individuals of diverse ethnic and cultural backgrounds.

Business Intelligence Analyst ll

Business Intelligence Analyst II

11100 E Bethany Dr, Aurora, CO 80014, USA Req #334
 Wednesday, April 6, 2022
The vision of Colorado Access is to have healthy communities transformed by the care that people want at a cost we can all afford.  Our mission is to partner with communities and empower people through access to quality, affordable care.

Under the supervision of the Manager of Business Intelligence , the Business Intelligence Analyst III is responsible for supporting organizational decision-making through complex analysis, reporting, research, and effective use of data generated from our information systems. They will be within the Business Intelligence Department, providing extracted data sets, in-depth complex analyses, and reports to support the reporting needs of multiple lines of business.

·        Serves as an integrated line of business team member ensuring that information needs are understood, complete specifications are identified, and the appropriate analysis, research, report, or other support is identified to address those needs. Analyzes and documents requirements through research, data gathering, and brainstorming activities.  Designs and documents customer reporting and analytic requests by defining, creating, evaluating, and selecting alternatives.  Key considerations in the selection process include:

o   Colorado Access, Business Intelligence, and Line of Business strategic plan alignment

o   Business problems and opportunities

o   Operational efficiency

o   Process improvement

o   Techniques used in analysis and design include, but are not limited to:

§  Report Mockups

§  Analytical Project Design

·        Transforms complex Business Intelligence requests, both internal and external, into useful products with actionable outcomes that utilize the most credible and efficient data source, subject to relevant materiality levels. Identifies and creates new data objects. Presents report results to Senior Management.

·        Identifies actionable issues through data interpretation and research.  Provides summary of trends, observations, and actionable items on complex reporting issues and development reports. Applies advanced data analysis and statistical techniques to answer any number of complex data questions and initiatives. Validates that output meets Line of Business needs. Partners with Line of Business Directors to “dig deeper” into output and identifies areas of further analysis.

·        Utilizes a variety of software applications and data sources to develop methodologies for the Business Intelligence department and the Analysis and Reporting Team.

·        Actively develops new tools and system enhancements, troubleshoots and solves data issues. 

·        Seeks out, identifies, documents, and initiates resolutions to data quality issues that are discovered during report and analysis development.

·        Participates in available training programs and maintains an individual training/education strategy with immediate supervisor.

·        In coordination with Department management, specific elements of the Company’s Strategic Plan will be identified as focus areas for this position and will be included as position responsibilities.

 

REQUIREMENTS:
 

Education: Bachelor’s degree in health care related area, statistics, computer systems, finance or accounting.  Equivalent combination of experience and/or education may substitute with a preference for four years progressive relevant work experience.

 

Experience: Minimum of seven years’ experience in healthcare data related field with at least three years of SQL experience.  Significant and demonstrated experience with advanced data reporting and analysis methods, data management and query tools including the use of Toad, Business Objects, Tableau, Python, or other similar tools required.

 

Knowledge, Skills, and Abilities: Expert understanding of health benefits, medical terminology, medical procedures, and managed care industry; expertise with CPT, ICD and other coding systems; demonstrated analytical, problem solving, and research ability as evidenced by experience in the identification of requirements and the definition, evaluation, and selection of appropriate solutions to business problems or opportunities.  Demonstrates support for the company’s mission, vision and values. 

Position requires excellent written and verbal communication skills.  Demonstrated ability for turning complicated verbal requests into reports and queries; ability to interpret complex data results and effectively summarize information that can be easily translated into company action.  Must have strong interpersonal and teamwork skills with good organizational and time management skills.  May be required to manage multiple priorities and projects with tight deadlines.  Must be proficient in MS-Office applications (Excel, Access, Word, Power Point); experience with analytics tools or languages such as SAS, Python or R is a plus. Experience with data management and query tools, such as Power BI and Tableau and SQL Experience is required.

 

Licenses/Certifications: A valid driver’s license and proof of current auto insurance will be required for any position requiring driving.

 

*Due to the pandemic, our employees are temporarily working at home. We require our workforce to reside in Colorado and telecommute, which may require you to come into the office as we serve our local communities.
 

COMPENSATION & BENEFITS: 
 

Compensation: $75,500.00 – $116,000.00. Pay rate/salary to be commensurate with experience. 
 

Benefits: In addition to being part of a mission driven organization that serves our community, eligible Colorado Access employees receive a generous benefits package, including:

  • Medical, Dental, & Vision starting the 1st day of the month following start date.  
  • Supplemental insurance such as critical illness and accidental injury. 
  • Healthcare and Dependent care flexible spending account options.
  • Employer Paid Basic Life Insurance and AD&D (employee, spouse and dependent). 
  • Short-term and Long-term Disability Coverage.
  • Voluntary Life Insurance (employee, spouse, dependent).
  • Paid Time Off
  • Retirement Plan
  • Tuition Reimbursement (based on eligibility). 
  • Annual bonus program (based on eligibility, requirements and performance).