Genesis HealthCare Careers

BI - DB Report Developer (Full Time)

Albuquerque, New Mexico
Information Systems

Job Description

  1. Collaborates with systems development team members on requirements, design, analysis, and development of dashboards, reports and data extracts

  2. Experience with and understanding of dimensional data modeling techniques, data warehousing design and concepts, and design of dashboards and KPIs

  3. Contributes to an overall data management roadmap and establishes processes and standards for governing the identification, collection, and use of corporate metadata

  4. Proactively assesses and defines governance, stewardship, and frameworks for managing data across the organization

  5. Designs and supports multi-dimensional models, including the construction of data views, dimensions, measures, filters, hierarchies and cubes while adhering to enforced development methodologies.

  6. Provides data modeling and architecture expertise for various projects.

  7. Develops and promotes consistent data management methodologies and standards and adherence to best practices

  8. Responsible for the mapping of data sources, data movement, interfaces, and analytics with the goal of ensuring data quality

    1. Collaborates with Database Administrator and other team members to understand dimensional requirements and translate into functional specifications

    2. Develop, maintain and manage reporting, analytics, dashboards and other BI solutions using applicable software including but not limited to SSRS, Jasper or Dundas

    3. Setup and maintain technical documentation and standards

  9. Accurately scopes, defines and estimates work effort and resource plan for assigned projects.

  10. Outstanding written and oral communications skills, and group facilitation capabilities

  11. Functions as an effective team member through good communication and cooperation to meet departmental goals and continually shares knowledge with team members and ensures appropriate knowledge transfer.

  12. Promotes a collaborative team environment that fosters creativity and innovation.

  13. Ensures customer satisfaction by managing software/report requests, questions, and issues accurately and in a timely fashion.

  14. Ability to effectively multi-task and work in a fast-paced agile environment.

  1. Develop and maintain database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, etc.)

  2. Responsible for writing scripts / creating database projects to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, etc.

  1. Provide primary support for the internally developed data repositories

  2. Ability to develop simple to highly complex reports and data extracts to user specifications

  3. Perform / participates in code reviews

  4. Develop technical solutions to support and streamline data reporting requests

Assumes task/projects as needed for overall success of the team and to step out of the job responsibilities when necessary to benefit the team and company.




  1. 1. Bachelor's degree or equivalent experience is required.

  2. 2. Minimum 5 years' experience in the IT industry with at least 2-4 years of hands-on work experience in developing solutions such as data marts, reports, dashboards, scorecards using Microsoft SQL Server 2008 or higher, SSRS, and SSIS

  3. 3. Understanding of relational and multi-dimensional database structures and schemas and reporting architectures.

  4. 4. Experience in conducting data analysis, complex report design/development, and developing data extracts.

  5. 5. Advanced experience with database technologies such as Microsoft SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server

  6. 6. Ability to gather requirements from users and develop those requirements into reports and/or data extracts.

  7. 7. Experience with various reporting toolsets which include: SSRS, Jasper, Dundas, and others.

  8. 8. Strong SQL skills including complex query building and query performance tuning

  9. 9. Effective problem solving and decision-making capabilities.

  10. 10. Ability to quickly learn new tools and technology.

  11. 11. Excellent communication, interpersonal, and relationship building skills conducive to team development.

  12. 12. Ability to work in an agile, collaborative team-based environment.

  13. 13. Ability to work under tight deadlines while participating in 1-2 projects at a time and responding to changing business and technical priorities

  14. 14. Ability to prioritize tasks efficiently with high level of attention to detail

  15. 15. High level of professionalism, integrity and commitment to quality and a demonstrated initiative and positive can-do attitude.

  16. 16. Proactively works issues and tasks with minimal guidance while keeping team informed.

Ability to follow instructions and to accept constructive feedback.

Position Type: Full Time
Req ID: 299665
Center Name: Genesis HealthCare