Data Warehouse Architect - Baton Rouge, United States - Premier Health Consultants

Description

Job Type

Full-time

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.
• Professionalism - Reacts well under pressure; accepts responsibility for own actions; follows through on commitments.
• Quality - Monitors own work to ensure quality.
• Adaptability - Changes approach or method to best fit the situation; able to deal with frequent change, delays, or unexpected events.
• Dependability - Keeps commitments; commits to long hours of work when necessary to reach goals.

Education and/or Experience Bachelor's degree in a technical field such as Computer Science, Accounting, Finance, Economics, Mathematics; 3+ years' experience. Master's degree preferred. Healthcare experience is a plus. Experience with data visualization programs, such as Tableau, is highly desired.

Language Skills Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Reasoning Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Computer Skills To perform this job successfully, an individual should have knowledge of Microsoft Office products. Strong knowledge of data aggregation tools such as Excel and Tableau. Strong knowledge of programming languages such as SQL, Python and/or Java. Proficient in relevant data management applications.

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands to handle or feel; reach with hands and arms and talk or hear. The employee may be required to occasionally lift, push, or pull up to 50 pounds.

Work Environment The work environment characteristics described here are representative of those an

employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually quiet to moderate. The employee may be exposed to infectious or contagious diseases and a variety of electromechanical hazards. The employee may also handle emergency and/or crisis situations.

The above job description is intended to describe the general nature and level of work being performed in the described position. This document is not intended to be an exhaustive list of all position duties and skills required of the individual classified in this position.