Integration Architect

Job Details
This position provides strategic leadership in the design and governance of enterprise data ecosystems. They define and drive data management strategies, policies, and standards to ensure data integrity, compliance, and optimal use across the organization. This role oversees the implementation of advanced tools and technologies, guiding teams in building scalable, secure, and integrated data solutions. Partnering with executives and stakeholders, the senior architect translates complex data requirements into actionable frameworks that enable innovation and informed decision-making.

Job Description

Summary
This position provides strategic leadership in the design and governance of enterprise data ecosystems. They define and drive data management strategies, policies, and standards to ensure data integrity, compliance, and optimal use across the organization. This role oversees the implementation of advanced tools and technologies, guiding teams in building scalable, secure, and integrated data solutions. Partnering with executives and stakeholders, the senior architect translates complex data requirements into actionable frameworks that enable innovation and informed decision-making.

Job Duties

• Design scalable and secure data solutions using Microsoft Fabric components (OneLake, Data Factory, Power BI, Synapse).
• Develop and maintain robust data models, pipelines, and semantic layers to support analytics and reporting.
• Lead technical implementation of data platform modernization initiatives, including migration to Fabric.
• Collaborate with business analysts and data engineers to translate business needs into data architecture blueprints.
• Ensure adherence to data governance, quality, and security standards across projects.
• Conduct performance tuning and cost optimization of data workflows and reporting assets.
• Provide technical mentorship to architects and engineers; contribute to architectural reviews and standards.

Minimum Qualifications

• Bachelor's Degree Business, Computer Science, Finance, Information Systems or related field.
• 7 years proven experience in data architecture or solution design within BI, analytics, or data engineering domains and hands-on experience with DAX, SQL, and at least one scripting language (Python or Spark).
• Ability to understand complex business processes, rules, and business acumen to become a subject matter expert.
• Advanced knowledge of business intelligence applications and modeling concepts.
• Proficiency in SQL, ETL packages, strategic design of extractions, and data integration process.
• Strong knowledge of Microsoft Fabric and Azure data services.
• Proficiency in dimensional modeling, ELT/ETL processes, and semantic modeling.
• Understanding of CI/CD and DevOps practices for data solutions.
• Strong communication and cross-functional collaboration skills.

Preferred Qualifications

• 7 years experience with finance, healthcare, retail, insurance, or other data-intensive industries.
• Exposure to hybrid or multi-cloud data environments.
• Familiarity with modern data architecture patterns (e.g., lakehouse, data mesh).

Physical Demands
Lift and carry 25 lbs. frequent sitting/standing, frequent keyboard use, *patient care providers may be required to perform activities specific to their role including kneeling, bending, squatting and performing CPR.

Job Description Disclaimer: This position description provides the major duties/responsibilities, requirements and working conditions for the position. It is intended to be an accurate reflection of the current position, however management reserves the right to revise or change as necessary to meet organizational needs. Other responsibilities may be assigned when circumstances require.

Work Shift
Workday Day (United States of America)

Worker Sub Type
Regular

Employee Entity
Thomas Jefferson University
Primary Location Address
1100 Virginia Drive, Fort Washington, Pennsylvania, United States of America

Nationally ranked, Jefferson, which is principally located in the greater Philadelphia region, Lehigh Valley and Northeastern Pennsylvania and southern New Jersey, is reimagining health care and higher education to create unparalleled value. Jefferson is more than 65,000 people strong, dedicated to providing the highest-quality, compassionate clinical care for patients; making our communities healthier and stronger; preparing tomorrow's professional leaders for 21st-century careers; and creating new knowledge through basic/programmatic, clinical and applied research. Thomas Jefferson University, home of Sidney Kimmel Medical College, Jefferson College of Nursing, and the Kanbar College of Design, Engineering and Commerce, dates back to 1824 and today comprises 10 colleges and three schools offering 200+ undergraduate and graduate programs to more than 8,300 students. Jefferson Health, nationally ranked as one of the top 15 not-for-profit health care systems in the country and the largest provider in the Philadelphia and Lehigh Valley areas, serves patients through millions of encounters each year at 32 hospitals campuses and more than 700 outpatient and urgent care locations throughout the region. Jefferson Health Plans is a not-for-profit managed health care organization providing a broad range of health coverage options in Pennsylvania and New Jersey for more than 35 years.


Jefferson is committed to providing equal educational and employment opportunities for all persons without regard to age, race, color, religion, creed, sexual orientation, gender, gender identity, marital status, pregnancy, national origin, ancestry, citizenship, military status, veteran status, handicap or disability or any other protected group or status.


Benefits

Jefferson offers a comprehensive package of benefits for full-time and part-time colleagues, including medical (including prescription), supplemental insurance, dental, vision, life and AD&D insurance, short- and long-term disability, flexible spending accounts, retirement plans, tuition assistance, as well as voluntary benefits, which provide colleagues with access to group rates on insurance and discounts. Colleagues have access to tuition discounts at Thomas Jefferson University after one year of full time service or two years of part time service. All colleagues, including those who work less than part-time (including per diem colleagues, adjunct faculty, and Jeff Temps), have access to medical (including prescription) insurance.

For more benefits information, please click here