Data Architect

---

Job description

We Are Hiring: Job Title: Data Architect
Department: Enterprise Data Warehouse
Schedule: 40 hours weekly, Full-Time, Day
Location: Regional Medical Lab, 41st Mingo, Tulsa, OK
As an Associate with Ascension St John, you will have the opportunity to collect and analyze Laboratory Services-related data from multiple sources for the development of reports and statistical information.
What You Will Do: Ensure that the data assets of an organization are supported by its information technology architecture.

• Recommend strategies based on changing business needs for supported area.
• Advise management on approaches to optimize business success.
• Evaluate applicability of leading edge technologies and use information to significantly influence future business strategy.
• Analyze complex business and competitive issues and discern the implications for systems support.
• Identify, define, direct, and perform project issue analysis to resolve issues, including analysis of the technical and economic feasibility of proposed data solutions.
• Design projects with broad implication for the business and/or the future architecture, successfully addressing cross-technology and cross-platform issues.
• Select tools and methodologies for projects.
• Negotiate terms and conditions with vendors.
• Effectively communicate highly technical information to numerous audiences, including senior management, the user community, and less-experienced staff.
• Develop partnerships with senior users to understand business needs and define future data requirements.

What You Will Need: Education:

• High school diploma/GED with 2 years of experience, or Associate's degree, or Bachelor's degree required.

Work Experience:

• 3 years of experience preferred.

Additional Preferences:

• Proficient in Informatica PowerCenter 10.4.0 and SQL Management Studio 2014 or above, dealing with very large volumes of data.
• Design, develop, implement Informatica based ETL solutions … mappings, sessions, workflows, code, test ETL packages, triggers, stored procedures, views, and SQL transactions, cardinality, levels of granularity, normalized vs de-normalized, database and Informatica optimization techniques.
• Experience working with complex SQL queries like Hierarchical, Aggregate Queries.
• Develop and implement an efficient migration process to move ETL from development to test and production environments.
• Collaborate with Business Analysts, Data Architects, ETL Architects, as well as technical and non-technical people in all levels of the organization, to ensure business requirements.
• Support data architecture, data integration, business intelligence and data analysis tools.
• Support project documentation.
• Participate in on-call rotation and off-hours/weekend support as needed

Why Join Our Team: Ascension is a faith-based healthcare organization dedicated to transformation through innovation across the continuum of care. As one of the leading non-profit and Catholic health systems in the U.S., Ascension is committed to delivering compassionate, personalized care to all. In FY2020, Ascension provided $2.4 billion in care of persons living in poverty and other community benefit programs. Ascension includes more than 160,000 associates and 40,000 aligned providers across a national network of ministries. We offer rewarding careers across more than 2,600 sites of care - including 146 hospitals and more than 50 senior living facilities - in 19 states and the District of Columbia."}" data-sheets-userformat="{"2":6975,"3":{"1":0},"4":{"1":2,"2":},"5":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"6":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"7":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"8":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"11":4,"12":0,"14":{"1":2,"2":0},"15":"Arial"}">Beginning as a 50-bed hospital in 1926, Ascension St. John has expanded to include multiple hospital locations, incorporating the skills of more than 7,000 employees throughout northeastern Oklahoma. We offer generous paid time off for work-life balance, a collaborative work environment, professional development opportunities, and more to help our associates flourish personally and professionally. If you are looking for a rewarding career in healthcare, we invite you to apply today.

When you join Ascension, you join a team of over 150,000 individuals across the country committed to a Mission of serving others and providing compassionate, personalized care to all. Our inclusive culture, continuing education programs, career coaches and benefit offerings are just a few of the resources and tools that team members can use to create a rewarding career path. In fact, Ascension spent nearly $46 million in tuition assistance alone to support associate growth and development. If you are looking for a career where you can grow and make a difference in your community, we invite you to join our team today.

Equal Employment Opportunity Employer:
Pay Non-Discrimination Notice:

For further information regarding your EEO rights, click on the following link to the "EEO is the Law" poster:

EEO is the Law Poster Supplement

Please note that Ascension will make an offer of employment only to individuals who have applied for a position using our official application. Be on alert for possible fraudulent offers of employment. Ascension will not solicit money or banking information from applicants."}" data-sheets-userformat="{"2":,"3":{"1":0},"5":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"6":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"7":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"8":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"9":0,"10":1,"11":4,"12":0,"16":10,"23":1}" data-sheets-textstyleruns="{"1":0,"2":{"2":{"1":2,"2":}}}{"1":18}{"1":389,"2":{"2":{"1":2,"2":0}}}{"1":390,"2":{"2":{"1":2,"2":},"9":1}}{"1":482}{"1":483,"2":{"2":{"1":2,"2":},"9":1}}{"1":484}{"1":595,"2":{"2":{"1":2,"2":0}}}{"1":596,"2":{"2":{"1":2,"2":},"9":1}}{"1":660}{"1":661,"2":{"2":{"1":2,"2":0}}}{"1":662,"2":{"2":{"1":2,"2":},"9":1}}{"1":694}" data-sheets-hyperlinkruns="{"1":389,"2":""}{"1":481}{"1":595,"2":""}{"1":659}{"1":661,"2":""}{"1":693}">Ascension St. John is an Equal Employment Opportunity (EEO) and Affirmative Action employer. Associates and Applicants receive fair and impartial consideration without regard to race, color, religion, national origin, citizenship, gender identity, sexual orientation, age, physical or mental disability, veteran status, genetic data, or other legally protected status.

Pay Non-Discrimination Notice:

f

For further information regarding your EEO rights, click on the following link to the "EEO is the Law" poster:

f

EEO is the Law Poster Supplemen t

Please note that Ascension will make an offer of employment only to individuals who have applied for a position using our official application. Be on alert for possible fraudulent offers of employment. Ascension will not solicit money or banking information from applicants.
E-Verify Statement:
E-Verify
Right to Work"}" data-sheets-userformat="{"2":,"3":{"1":0},"5":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"6":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"7":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"8":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"9":0,"10":1,"11":4,"12":0,"16":10,"23":1}" data-sheets-textstyleruns="{"1":0}{"1":138,"2":{"2":{"1":2,"2":},"9":1}}{"1":146}{"1":147,"2":{"2":{"1":2,"2":},"9":1}}" data-sheets-hyperlinkruns="{"1":138,"2":""}{"1":146}{"1":147,"2":""}{"1":160}">This employer participates in the Electronic Employment Verification Program. Please click the E-Verify link below for more information.

E-Verify