Integration Architect

Jefferson Health; Washington (Washington County); On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Medical insurance

Tuition assistance

Retirement plans

Job summary

Thomas Jefferson University in Fort Washington, PA, seeks an Integration Architect to lead enterprise data governance, design data ecosystems, and guide modernization using Microsoft Fabric components.

You will partner with executives to translate complex data requirements into actionable frameworks, mentor teams, and ensure data quality, security, and cost optimization.

Qualifications

• Bachelor’s degree or higher in a related field.
• 7+ years in data architecture/solution design in BI/analytics domains.
• Hands-on with DAX, SQL, and Python or Spark.
• Strong ability to translate complex business processes into data models.
• Advanced knowledge of BI applications and modeling concepts.
• Proficiency in SQL, ETL, data integration and semantic modeling.
• Familiarity with CI/CD/DevOps for data solutions.
• Excellent written and verbal communication across teams.

Responsibilities

• Design scalable, secure data solutions using Microsoft Fabric components.
• Develop and maintain data models, pipelines and semantic layers.
• Lead data platform modernization, migration to Fabric.
• Collaborate with analysts/engineers to translate needs into blueprints.
• Ensure data governance, quality, security across projects.
• Tune performance and optimize data workflows and reporting.
• Mentor architects/engineers and contribute to standards.

Skills

Data architecture

SQL

Python

Spark

DAX

BI modeling

Cloud data services

Data governance

Education

Bachelor’s degree in Computer Science/Information Systems/Finance or related field

Tools

Microsoft Fabric

Azure data services

Data Factory/Synapse

Job description

## Integration ArchitectApplylocations: Montgomery County, PAtime type: Full timeposted on: Posted Todayjob requisition id: REQ-0032574**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 AmericaNationally 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### Why work here?In keeping with Jefferson's Mission, We Improve Lives, it is our goal to recruit, retain, develop and reward highly-qualified employees. If you are enthusiastic, caring and dedicated to service excellence, we invite you to consider joining Jefferson. Jefferson encourages its employees to expand their knowledge and develop their careers through growth opportunities and continuing education.