Data Architect job description

Job brief

The Data Architect performs a variety of tasks to deliver data warehousing solutions that exceed customer expectations in content, accuracy, reliability and performance. This individual will participate in the data warehouse architecture, data modeling, extract transform and load (ETL) processes as well as work with other team members in troubleshooting and assuring quality of the data warehouse. The primary responsibility of the Data Architect will be to design and develop the processes required to extract, transform, cleanse, and load the data into the enterprise data warehouse and data marts. This person will also have a role in the design of the data and systems architecture for the data warehouse including normalized and dimensional data modeling; working to develop solutions to address data warehouse query performance and quality issues including data profiling; develop/enhance the data warehouse technical standards, and consult with others on optimal use of the EDW solve business problems.

Responsibilities

• Design, establish and maintain a data warehouse and cube services including ETL processes from Electronic Medical Record and other data sources. Tune to optimize performance and stability
• Design and develop flexible data solutions to meet ever-changing company needs.
• Design and develop integration/connections to various external data sources to feed data warehouse or other internal data stores
• Design and develop integrations/connections to various internal systems to support business processes such as Call Center Management, Customer Service and key operational applications.
• Oversee application development in Microsoft SharePoint and other platforms to collect and provide data needed for operational requirements.
• Establish and maintain a report center for dissemination of standard reports, key performance indicators, trending, scorecards, history, etc.
• Develop mobile business intelligence solutions for information dissemination to field staff and management.
• Collaborate with Performance Improvement, Quality Systems, and stakeholders to analyze and define data requirements needed to support the business processes; verify accurate data reporting; and integrate the data requirements throughout the data systems
• Oversee the development standardized reports in collaboration with stakeholders
• Develop Business Intelligence based cubes, standard queries and data sets for BI reporting in collaboration with Performance Improvement, Business Intelligence and stakeholders
• Facilitate data auditing and accuracy processes
• Collaborate with IT systems group to provide a secure infrastructure that supports data related systems; database replication; data warehouse and cube; SharePoint integration; Business Intelligence tools for end users.
• Keep up to date with eye, organ, and tissue industry regulations, standards, guidance and requirements such as those promulgated by CMS, FDA, UNOS, AOPO, HIPAA, AOPO, and AATB; as related to primary job function
• Establish and maintain standard processes, procedures, and change management, as applicable, for functions within the DSM scope of accountability
• Manages performance of direct report(s) consistent with expectations.
• Perform other duties as assigned.

Requirements

• Demonstrated extensive experience and expertise in all the above listed Duties and Key Responsibilities. As this is a small team, the ability to make a strong, hands on contribution is essential.
• A minimum of 5 years’ experience in business analysis and technical architecture roles in complex business environments.
• Excellent communication skills, both written and oral.
• Demonstrated strong problem solving, analytical skills, and strategic thinking.
• Excellent interpersonal skills, including stakeholder management, training, presentation and public speaking.
• Demonstrated, quality focused, track record of successful projects.
• Ability to be flexible and adaptable in the face of changing organizational priorities and ambiguous environments.
• Degree qualification in a relevant discipline is essential. Microsoft SharePoint training and certification would be highly desirable.
• Ability to research and quickly assimilate relevant new technologies, concepts, architectures and features is essential.
• Perform Unit Testing and assist Enterprise Quality Assurance and User Acceptance testing teams
• Demonstrated advanced technical and analytical skills.
• Experience reviewing documentation for the user (i.e. installation, use, and customization of products and services) as necessary.
• Possesses deep, specialized knowledge of Domain/Area/Team applications and their development throughout all phases of the lifecycle
• Possesses strong communication and interpersonal skills.
• Degree in a technical discipline OR equivalent work history.