Job Information
Trinity Health Solution Architect (Data Engineering) - REMOTE in Livonia, Michigan
Employment Type:
Full time
Shift:
Day Shift
Description:
(Sorry we cannot sponsor an H1b visa nor support a STEM OPT EAD for this role.)
POSITION PURPOSE/SUMMARY
Responsible for facilitating and leading the design, development and integration of new or improved product capabilities in collaboration with Product Management, Service Optimization and Product Engineering organizations. Responsible for the assessment of business requirements; collection and identification of technical specifications; and the subsequent development of technology solutions that require development to be viable (i.e., business applications, purchased applications, developed applications and applications integration).
This position requires advanced technical skills to design, code, and test complex data transformations to build data assets in current and future technical environments. This role requires a good understanding of healthcare business and EPIC EMR (Clarity). This role will also function as a mentor to fellow Junior Data Engineers in helping to create a sustainable data warehouse ecosystem and propose best practice standards to support and improve the data migration life cycle.
Provides vision and create solutions that meet current and future business requirements; model the pieces of an infrastructure and their points of integration; prove the feasibility of a design; create the design artifacts that are required to deliver and to maintain the infrastructure; guide a solution through to its completion; and ultimately can be implemented and supported in production, as well as relevant to the business end users. Assists in near/mid-term roadmap creation, to address gaps and move the organization toward the future state architecture to support future business growth and innovation.
ESSENTIAL FUNCTIONS
Knows, understands, incorporates, and demonstrates the Trinity Health Mission, Vision, and Values in behaviors, practices, and decisions.
Establishes and documents product specific standards, near/mid-term strategy, and roadmaps in support of Trinity standards and strategy, acting as product specific subject matter expert.
Researches software and hardware components or services, identifies the technologies to employ based on price, performance, service agreements and organizational constraints.
Participates and leads research and development efforts (proofs of concept, prototypes), as subject matter expert, when introducing new technologies.
Responsible for creating and maintaining architectural diagrams and technical documentation.
Defines business, computational, and technical requirements for new capabilities based on business/functional requirements defined by Product Management and customers.
Designs proposed application architecture and interface requirements for new capabilities in collaboration with other solution architects, enterprise architects Product Engineering, Product Management and Service Optimization.
Leads teams in the design and building of new capabilities and reporting solutions; new applications development, third-party application integration.
Provides input for work plans and resource requirements. Provides technical expertise to propose level of effort estimates, work breakdown structures and technical resource planning for proposed and current work.
Interfaces with Enterprise Architecture and other solution architects to align solutions with existing platforms and products.
Participates in various phases of the software development lifecycle to perform QA/architectural review functions and to ensure adherence to Trinity Health technology standards and product specific solutions architecture.
This position is a key role with the Data Engineering team to lead and contribute to building scalable products that support Trinity Health's strategic vision/growth and business community.
Develop functional requirements for product development.
Develop Informatica workflow, stored procedure, and complex SQL for data migration and validation work.
Develop Shell scripts.
Develop Azure pipelines for data migration in the cloud.
Translate business requirements to functional requirements and design scalable products.
Assist with UAT, issue triage, and production deployment.
Works with Product Management, Product Engineering and Service Optimization to ensure technology solutions are production ready and meet the defined specifications, and that the solution can be maintained via production support methodologies and resources; following established Change Management procedures.
Reviews the ongoing implementation solution for improvement opportunities.
Provides instructional training and conducts informational presentations.
Keeps current and informed of related technologies and best practices within the industry.
Serves as technical design owner and point of contact for product specific solutions.
Reinforces the vision and direction of Trinity Health, TIS, and the Product Management organization.
Cultivates working relationships within the Product Management, Product Engineering and Service Optimization organizations, and with the business units, that are positive, professional and collaborative. Interfaces with director level and staff, and both business and technical positions.
Knows, understands, incorporates and demonstrates the Trinity Health Mission, Vision and Values in leadership behaviors, practices and decisions.
Performs other duties as assigned.
Maintains a working knowledge of applicable Federal, State and local laws/regulations; the Trinity Health Integrity and Compliance Program and Code of Conduct; as well as other policies and procedures in order to ensure adherence in a manner that reflects honest, ethical and professional behavior.
[pay range $101,551.9428-$167,560.7056]
MINIMUM QUALIFICATIONS:
Bachelor's degree in healthcare or information technology and a minimum of ten (10+ prefered) years of progressively responsible experience in information technology or an equivalent combination of education and experience.
Five (5) years of progressive experience with comprehensive knowledge of hardware, software, application, and systems engineering in at least two (2) IT disciplines (i.e., as strategic planning, solution architecture, technology architecture, network management, security management, change management, application development, middleware design, information analysis, database management, project management, and operations management).
Advanced technical knowledge and understanding of multiple architectures, applications, systems design, entity relationships, and integration.
Ability in different data modeling methodologies including STAR, Snowflake, and 3NF.
Demonstrated thorough understanding of modern enterprise architecture.
Knowledge of healthcare processes and data linkages across clinical, financial, and patient administrative areas in acute care and outpatient settings.
Demonstrated knowledge of healthcare nomenclature and clinical and financial business processes preferred; EPIC EMR Clarity experience preferred.
Ability to understand how parts interact with the whole (big picture thinking). Knowledge of multiple components of enterprise architecture. Demonstrated knowledge of business re-engineering principles and processes. Basic knowledge of financial analysis and models.
Minimum five (5) years of experience in design and development of processing, reporting, analytic, and application solutions to support end-user decision-making.
Writing functional specifications and design specifications
Developing data enhancement processes and applications
Developing and integrating standard structures, processes, and delivery methods, and other comprehensive end user solutions
Experience with multiple technical architectures, and languages
Change management process development and enforcement
Minimum of ten (10) years of experience working as a Sol Architect/Data Engineer in a large data warehouse and business intelligence environment.
Minimum of five (5) years of experience working with data development technologies such as Informatica, Data Stage, Cloud pipelines (synapse/fabric)
Minimum of five (5) years of experience writing and tuning stored procedures and advanced SQL.
Excellent organization, analytical, interpersonal, written and verbal communication skills.
Must possess the ability to work collaboratively across product management methodology (Management, Engineering and Optimization) teams.
Must be comfortable operating in a collaborative, shared leadership environment.
A personal presence which is characterized by a sense of honesty, integrity and caring with the ability to inspire and motivate others to promote the philosophy, mission, vision, goals and values of Trinity Health.
Technical Skills
Teradata/Oracle/DB2 (7+ years)
SQL (7+ years writing advanced SQL and stored procedures)
Performance Tunning (5+ years)
UNIX/Linux (5+ years)
Informatica PwC/IDQ (5+ years)
Cloud/Azure Synapse/Fabric (3 years)
Python/Spark (5 years)
Clinical/healthcare Data Knowledge – EMR, able to understand healthcare nomenclature.
HL7/FHIR
PHYSICAL AND MENTAL REQUIREMENTS AND WORKING CONDITIONS
This position operates in a typical office environment. The area is well-lit, temperature-controlled and free from hazards.
Incumbent communicates frequently, in person and over the telephone, with people in a number of different locations on technical issues.
Manual dexterity is needed in order to operate a keyboard. Hearing is needed for extensive telephone, video conferencing and in person communications.
The environment in which the incumbent will work requires the ability to concentrate, meet deadlines, work on several projects at the same period and adapt to interruptions.
The incumbent must be capable of traveling up to 20% in the course of completing project assignments (mayn’t be applicable based on job duties and expectations).
Ability to meet established deadlines.
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of duties so assigned.
Our Commitment to Diversity and Inclusion
Trinity Health is one of the largest not-for-profit, Catholic healthcare systems in the nation. Built on the foundation of our Mission and Core Values, we integrate diversity, equity, and inclusion in all that we do. Our colleagues have different lived experiences, customs, abilities, and talents. Together, we become our best selves. A diverse and inclusive workforce provides the most accessible and equitable care for those we serve. Trinity Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by law.
Our Commitment to Diversity and Inclusion
Trinity Health is a family of 115,000 colleagues and nearly 26,000 physicians and clinicians across 25 states. Because we serve diverse populations, our colleagues are trained to recognize the cultural beliefs, values, traditions, language preferences, and health practices of the communities that we serve and to apply that knowledge to produce positive health outcomes. We also recognize that each of us has a different way of thinking and perceiving our world and that these differences often lead to innovative solutions.
Our dedication to diversity includes a unified workforce (through training and education, recruitment, retention, and development), commitment and accountability, communication, community partnerships, and supplier diversity.
EOE including disability/veteran