Position Summary

The Data Integration Architect is primarily responsible for designing and development, of solutions for the data warehouse. The primary focus of the data warehouse includes data and analytics that support business operations including Clinical, Patient Accounting, and Corporate functions.

This role is cloud facing and requires hands on experience in building and managing data engineering code in modern cloud-based technologies such as Google Big Query or equivalent. We are looking for a high energy individual willing to learn and evolve and would like to contribute to high impact healthcare environment.

Strong data modeling and data warehouse design experience is a must.

People who are experienced in Teradata BTEQ, Oracle PL/SQL, SQL Server T-SQL or Netezza can also be considered if they are willing to work hard and learn Google Big Query can also be considered

Duties and Responsibilities

Responsible for Architecture and design of various Data Integration projects
Manage project plans and assigned resources, to ensure timely delivery
Create best practices in design and architecture that complies with Tenet standards
Participates in solution design, providing oversight and guidance related to data design and usage.
Monitor and measure data architecture processes and standards to ensure value is being driven and delivered as expected.
Establish data architecture strategy, best practices, standards, and roadmap
Collaborates with team members, customers, and partners to facilitate understanding of project, produce an efficient and effective solution, consistently at or ahead of established deadline.
Coaches/mentors others to guide those though specific projects, policies, procedures, and solutions.
Knowledge of emerging technologies and methodologies that can be applied, to reduce cost and drive efficiencies.
Assembling large, complex sets of data that meet non-functional and functional business requirements
Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using GCP and SQL technologies
Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics
Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues

Qualifications

Strong SQL and relational database design/development skills
Strong hands-on data warehousing development experience: Teradata BTEQ, Oracle PL/SQL, SQL Server T-SQL or Netezza can also be considered if they are willing to work hard and learn Google Big Query
5+ years of experience in Data warehousing, Business intelligence and ETL.
7+ years of experience in information technology
Lead teams within a matrixed organization
Effective communication and interpersonal skills
Experience with analytics and data warehousing
Experience in building data models for data warehouse
Ability to build and optimize data sets, ‘big data’ data pipelines and architectures
Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions
Excellent analytic skills associated with working on unstructured datasets
Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata
Development experience with cloud-based modern data warehouses such as Google Big Query or equivalent.
Excellent written and verbal communications skills
Strong interpersonal skills- ability to communicate with all levels of customers, vendors, and IT resources

Preferred

Prior experience with health information systems and/or patient financial service systems preferred
Applicants should also have a demonstrated understanding and experience using software and tools including big data tools like Kafka, Spark; relational SQL databases including Big Query or equivalent; workflow management and pipeline tools such as Airflow, and object function/object-oriented scripting languages including Scala, C++, Java and Python.
Working knowledge of hospital information systems and understanding of health care system integration
Cerner, Meditech, CPSI, Allscripts, EPIC, McKesson, NextGen data integration experience a plus
Knowledge of healthcare industry and working with various billing, registration and EMRs is strongly preferable.
Possesses sound analytical, problem solving, and critical thinking skills. Assignments may be complex in nature and modifications may be broader than the application itself. Must have the ability to think creatively and incorporate current technical solutions with the end user in mind. Assigned projects may be complex in nature and impact more than one system application

Data Integration Architect

About Tenet Healthcare