Reporting to the Manager of Decision Support, the Information Specialist will be part of a BI developers team, responsible for designing, modeling, developing and supporting Database Management Systems (DBMS), and also supporting reporting, analytics as well as business intelligence/decision support solutions to meet the information needs and the strategic goals of the organization.
Database/Data Model Design & Development
Conceptualizes and influences application and interface projects, initiates, evaluates, and influences projects from the perspective of the entire organization. Evaluate current state and conceives desired future state, and conceives projects needed to close the gap between current state and future goals.
Develops and maintains data models and data dictionaries, data maps and other artifacts across the organization, including the conceptual and physical models, as well as metadata repository.
Documents business requirements in the form of specifications (functional and technical specifications), validates accuracy and obtains necessary input and approval.
Report Design & Development
Builds reporting solutions from start to finish, including database design, relational integrity constraints, OLAP, OLTP, cubes and normalization as required to support requests.
Generates reports using other (statistics) reporting tools such as SAS and Excel spreadsheets, scheduling and deploying reports on report manager.
Applies critical thinking skills by interacting directly with the requesting party to develop appropriate report requirements and parameters, suggesting appropriate content fields and design where appropriate, and implementing the report criteria and analysis of said report criteria to accurately produce the requested report/recommendations.
Ensures reports are optimized for efficiency and negative performance on production environment is mitigated.
Supports and follows information governance and data standardization procedures established by the organization. Documents reports library as well as external data imports and exports.
Performs other related duties as assigned or requested.
Bachelors of Science in a Computer Science related field with minimum 2 years data business intelligence report development and analysis experience is required.
Master' s degree or higher in Computer Science related field with minimum 2 years data business intelligence report development and analysis experience is preferred.
Minimum of 2 years of business intelligence/decision support experience or statistical analysis using Microsoft SQL suite, including SSRS, SSAS, and SSIS, SAS, experience with similar tools may be considered.
Minimum of 2 years healthcare experience (clinic, hospital or health system) including clinical workflow and clinical terminology preferred.
Experience with quality and clinical reporting in the healthcare industry.
Experience with Business Intelligence tools development.
Expert understanding of relational database, data model development, data warehousing and business intelligence.
Expert in database design, relational integrity constraints, OLAP, OLTP, cubes and normalization.
Experience in T– SQL and query optimization.
Understand ETL and expert experience in generating custom reports using SQL Server 2005/2008/2012, IBM Cognos BI 10.2 and Microsoft reporting tools SSRS, SSAS, and SSIS, including advanced functions, scheduling and deploying reports on report manager.
Solid understanding of Object Oriented Programming and experience in C#/VB/Java/other.
Understands the system development life cycle, software project management approaches and requirements, design, and test techniques. Sound Knowledge of data modeling and database design from conceptualization to database optimization.
Interested applicants please share your resume at firstname.lastname@example.org
"In our dealings with Dean Group, we have always been provided with quality personnel in a timely manner. It has always been a pleasure dealing with Dean for their expertise, personal commitment, and energy to meet our goals."