Data Warehouse Architect

Description

Summary

The Data Warehouse Architect participates in data analysis to ensure the business is provided accurate, consistent, and relevant information with which to make critical business decisions. This position reports to the Manager of Finance.

Responsible for the design, model, and implementation of data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

Responsible for collecting and analyzing financial, operational, and marketing data and offering detailed analysis and solutions that can be acted upon. The ideal candidate will be comfortable working with large and disparate data sets to solve complicated problems which often require thinking outside of the box. This will be achieved through developing and maintaining a comprehensive understanding of our company and the healthcare industry.

Essential Duties and Responsibilities

• Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
• Develop database architectural strategies at the modeling, design, and implementation stages to address business or industry requirements.
• Develop data models for applications, metadata tables, views or related database structures.
• Assists team members, colleagues, and senior management with their strategic data needs by providing organized and actionable data.
• Manages, develops, and collaborates with colleagues to accomplish goals in a team driven setting.
• Responsible for sourcing data from multiple systems for the purposes of reporting and using data aggregation skills to make data reportable and provide actionable insights.
• Strong business acumen. Financial reporting experience a plus, but not required.
• Proven ability to manage complex projects to successful completion.
• Prepare and analyze data to be used in creation of budgets and forecasts for multiple entities. Conduct variance analysis and historical trend analysis on various data sets and operational metrics, including, but not limited to revenue, marketing, and expense drivers.
• Data aggregation and statistical analysis using standardized data visualization tools and coding languages such as SAS, Tableau, SQL, Python, HTML.
• Responsible for collaborating with other analytics and reporting colleagues, to develop, test and modify reports, spreadsheets and dashboards as assigned.
• Responsible for the preparation and delivery of standardized monthly, quarterly, and annual reports, including operational, marketing, and financial data.
• Solicits and supports input from team members at all levels within the organization.
• Recognizes areas for internal improvement and assists in developing plans for implementation.
• Ad-Hoc and various other tasks as assigned.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The 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.

Requirements

To perform the job successfully, an individual should demonstrate the following competencies:

• Technical Skills - Strives to continuously build knowledge and skills, shares expertise with others.
• Customer Service - Responds promptly to customer needs.
• Interpersonal Skills - Maintains confidentiality.
• Oral Communication - Responds well to questions; participates in meetings.
• Written Communication - Presents numerical data effectively.
• Teamwork - Balances team and individual responsibilities; contributes to building a positive team spirit.
• Quality Management - Demonstrates accuracy and thoroughness.
• Business Acumen - Understands business implications of decisions; displays orientation to profitability.
• Cost Consciousness - Works within approved budget; develops and implements cost saving measures; contributes to profits and revenue; conserves organizational resources.
• Diversity - Promotes a harassment-free environment.
• Ethics - Keeps commitments; works with integrity and ethically; upholds organizational values.
• Organizational Support - Follows policies and procedures.
• Judgment - Exhibits sound and accurate judgment; supports and explains reasoning for decisions; includes appropriate people in decision-making process; makes timely decisions.
• Motivation - Sets and achieves challenging goals; demonstrates persistence and overcomes obstacles.
• Planning/Organizing - Prioritizes and plans work activities; uses time efficiently; organizes or schedules other people and their tasks.