AMADA Senior Care Mesa
Senior Data Integration Developer
AMADA Senior Care Mesa, Cambridge, Massachusetts, us, 02140
Position DescriptionThis is a fully benefited, full-time Harvard University position that has been funded through December 31, 2025. There is the possibility of renewal, contingent on funding, university priorities and satisfactory job performance.
Harvard University Information Technology (HUIT) is a community of Information Technology professionals committed to delivering service and technological solutions in support of teaching, learning, research and administration. We are recruiting an IT workforce that has both breadth in their ability to collaborate and innovate across disciplines ? and depth in specific areas of expertise. HUIT offers opportunities for IT professionals to learn and work in a unique technology landscape and service-focused environment. If you are a technically proficient, nimble, user-focused, and accountable IT professional who also connects with the importance of collaborating well in a team environment, we are looking for you!
The Administrative Data Management and Reporting Ecosystem (ADMIRE) project is designed to create a comprehensive data strategy that enables the institution to leverage administrative data to inform decisions, make predictions, and otherwise understand our operations. The demand for high-quality, normalized, and interconnected data has continued to increase, with the emergence of generative artificial intelligence putting a spotlight on the challenges of data quality and data governance. This project prioritizes the foundational technology and related services that will enable such initiatives to move forward easily in the future. The ADMIRE project will enable us to leverage the full value of our digital assets for an enterprise-wide approach to data governance, create a modern data ecosystem, and incorporate best practices into our data management capabilities.
The key success factor for the project is to be able to build robust data ingestion pipelines from the source systems (using GoldenGate) and SaaS systems (using API). The project will also migrate the Informatica PowerCenter workflows and mappings to Informatica Cloud (IDMC). We are going to significantly re-architect our existing code for which we need a mid-level, savvy, experienced data integration engineer. This is a great opportunity to modernize and build a data ecosystem for Harvard University.
Principal Duties and include:
Play a lead role in managing a practice for university-wide replication solution.Design;
and develop scalable data replication pipelines utilizing continuous or batch processing frameworks (e.g., Oracle GoldenGate, Informatica Mass Ingestion, API, Streaming).Design, develop, test and deploy complex ETL processes
Be able to provide long-term roadmaps for data ingestion and engineering space.Work closely with source system (ERP) staff to ensure integrity of data in replicationSolid experience in Informatica ETL tool, scripting and SQL skillsEnsure efficiency, reliability and scalability of ETL workflows for large datasetsTroubleshoot and resolve issues related to data integration and ETL workflows.Implement and adhere to best practices for data quality and consistency.Conduct unit testing, integration testing, and performance testing for ETL processes.Perform on-call duty on a rosterBasic QualificationsMinimum of five years? post-secondary education or relevant work experienceAdditional Qualifications and SkillsFamiliarity with
modern data warehousesInformatica Cloud ? IDMC productsOracle OCI and GoldenGate technologies
Oracle ODI knowledge is a plusCertificates and LicensesCompletion of Harvard IT Academy specified foundational courses (or external equivalent) preferredWorking ConditionsWork is performed in an office settingAdditional InformationPlease provide a cover letter with your application.
Please note:Harvard University requires pre-employment reference and background screening.We are unable to provide work authorization and/or visa sponsorship.This position has a 180-day orientation and review period.The health of our workforce is a priority for Harvard University. With that in mind, we strongly encourage all employees to be up-to-date on CDC-recommended vaccines.
Accessibility:Harvard University welcomes individuals with disabilities to apply for positions and participate in its programs and activities. If you would like to request an accommodation or have questions about the physical access provided, please contact our University Disability Resources Department.BenefitsWe invite you to visit Harvard's Total Rewards website (
https://hr.harvard.edu/totalrewards
) to learn more about our outstanding benefits package, which may include:Paid Time Off:
3-4 weeks of accrued vacation time per year (3 weeks for support staff and 4 weeks for administrative/professional staff), 12 accrued sick days per year, 12.5 holidays plus a Winter Recess in December/January, 3 personal days per year (prorated based on date of hire), and up to 12 weeks of paid leave for new parents who are primary care givers.Health and Welfare:
Comprehensive medical, dental, and vision benefits, disability and life insurance programs, along with voluntary benefits. Most coverage begins as of your start date.Work/Life and Wellness:
Child and elder/adult care resources including on campus childcare centers, Employee Assistance Program, and wellness programs related to stress management, nutrition, meditation, and more.Retirement:
University-funded retirement plan with contributions from 5% to 15% of eligible compensation, based on age and earnings with full vesting after 3 years of service.Tuition Assistance Program:
Competitive program including $40 per class at the Harvard Extension School and reduced tuition through other participating Harvard graduate schools.Tuition Reimbursement:
Program that provides 75% to 90% reimbursement up to $5,250 per calendar year for eligible courses taken at other accredited institutions.Professional Development:
Programs and classes at little or no cost, including through the Harvard Center for Workplace Development and LinkedIn Learning.Commuting and Transportation:
Various commuter options handled through the Parking Office, including discounted parking, half-priced public transportation passes and pre-tax transit passes, biking benefits, and more.Harvard Facilities Access, Discounts and Perks:
Access to Harvard athletic and fitness facilities, libraries, campus events, credit union, and more, as well as discounts to various types of services (legal, financial, etc.) and cultural and leisure activities throughout metro-Boston.Work FormatHybrid (partially on-site, partially remote)
Commitment to Equity, Diversity, Inclusion, and BelongingHarvard University views equity, diversity, inclusion, and belonging as the pathway to achieving inclusive excellence and fostering a campus culture where everyone can thrive. We strive to create a community that draws upon the widest possible pool of talent to unify excellence and diversity while fully embracing individuals from varied backgrounds, cultures, races, identities, life experiences, perspectives, beliefs, and values.
EEO StatementWe are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.#J-18808-Ljbffr
Harvard University Information Technology (HUIT) is a community of Information Technology professionals committed to delivering service and technological solutions in support of teaching, learning, research and administration. We are recruiting an IT workforce that has both breadth in their ability to collaborate and innovate across disciplines ? and depth in specific areas of expertise. HUIT offers opportunities for IT professionals to learn and work in a unique technology landscape and service-focused environment. If you are a technically proficient, nimble, user-focused, and accountable IT professional who also connects with the importance of collaborating well in a team environment, we are looking for you!
The Administrative Data Management and Reporting Ecosystem (ADMIRE) project is designed to create a comprehensive data strategy that enables the institution to leverage administrative data to inform decisions, make predictions, and otherwise understand our operations. The demand for high-quality, normalized, and interconnected data has continued to increase, with the emergence of generative artificial intelligence putting a spotlight on the challenges of data quality and data governance. This project prioritizes the foundational technology and related services that will enable such initiatives to move forward easily in the future. The ADMIRE project will enable us to leverage the full value of our digital assets for an enterprise-wide approach to data governance, create a modern data ecosystem, and incorporate best practices into our data management capabilities.
The key success factor for the project is to be able to build robust data ingestion pipelines from the source systems (using GoldenGate) and SaaS systems (using API). The project will also migrate the Informatica PowerCenter workflows and mappings to Informatica Cloud (IDMC). We are going to significantly re-architect our existing code for which we need a mid-level, savvy, experienced data integration engineer. This is a great opportunity to modernize and build a data ecosystem for Harvard University.
Principal Duties and include:
Play a lead role in managing a practice for university-wide replication solution.Design;
and develop scalable data replication pipelines utilizing continuous or batch processing frameworks (e.g., Oracle GoldenGate, Informatica Mass Ingestion, API, Streaming).Design, develop, test and deploy complex ETL processes
Be able to provide long-term roadmaps for data ingestion and engineering space.Work closely with source system (ERP) staff to ensure integrity of data in replicationSolid experience in Informatica ETL tool, scripting and SQL skillsEnsure efficiency, reliability and scalability of ETL workflows for large datasetsTroubleshoot and resolve issues related to data integration and ETL workflows.Implement and adhere to best practices for data quality and consistency.Conduct unit testing, integration testing, and performance testing for ETL processes.Perform on-call duty on a rosterBasic QualificationsMinimum of five years? post-secondary education or relevant work experienceAdditional Qualifications and SkillsFamiliarity with
modern data warehousesInformatica Cloud ? IDMC productsOracle OCI and GoldenGate technologies
Oracle ODI knowledge is a plusCertificates and LicensesCompletion of Harvard IT Academy specified foundational courses (or external equivalent) preferredWorking ConditionsWork is performed in an office settingAdditional InformationPlease provide a cover letter with your application.
Please note:Harvard University requires pre-employment reference and background screening.We are unable to provide work authorization and/or visa sponsorship.This position has a 180-day orientation and review period.The health of our workforce is a priority for Harvard University. With that in mind, we strongly encourage all employees to be up-to-date on CDC-recommended vaccines.
Accessibility:Harvard University welcomes individuals with disabilities to apply for positions and participate in its programs and activities. If you would like to request an accommodation or have questions about the physical access provided, please contact our University Disability Resources Department.BenefitsWe invite you to visit Harvard's Total Rewards website (
https://hr.harvard.edu/totalrewards
) to learn more about our outstanding benefits package, which may include:Paid Time Off:
3-4 weeks of accrued vacation time per year (3 weeks for support staff and 4 weeks for administrative/professional staff), 12 accrued sick days per year, 12.5 holidays plus a Winter Recess in December/January, 3 personal days per year (prorated based on date of hire), and up to 12 weeks of paid leave for new parents who are primary care givers.Health and Welfare:
Comprehensive medical, dental, and vision benefits, disability and life insurance programs, along with voluntary benefits. Most coverage begins as of your start date.Work/Life and Wellness:
Child and elder/adult care resources including on campus childcare centers, Employee Assistance Program, and wellness programs related to stress management, nutrition, meditation, and more.Retirement:
University-funded retirement plan with contributions from 5% to 15% of eligible compensation, based on age and earnings with full vesting after 3 years of service.Tuition Assistance Program:
Competitive program including $40 per class at the Harvard Extension School and reduced tuition through other participating Harvard graduate schools.Tuition Reimbursement:
Program that provides 75% to 90% reimbursement up to $5,250 per calendar year for eligible courses taken at other accredited institutions.Professional Development:
Programs and classes at little or no cost, including through the Harvard Center for Workplace Development and LinkedIn Learning.Commuting and Transportation:
Various commuter options handled through the Parking Office, including discounted parking, half-priced public transportation passes and pre-tax transit passes, biking benefits, and more.Harvard Facilities Access, Discounts and Perks:
Access to Harvard athletic and fitness facilities, libraries, campus events, credit union, and more, as well as discounts to various types of services (legal, financial, etc.) and cultural and leisure activities throughout metro-Boston.Work FormatHybrid (partially on-site, partially remote)
Commitment to Equity, Diversity, Inclusion, and BelongingHarvard University views equity, diversity, inclusion, and belonging as the pathway to achieving inclusive excellence and fostering a campus culture where everyone can thrive. We strive to create a community that draws upon the widest possible pool of talent to unify excellence and diversity while fully embracing individuals from varied backgrounds, cultures, races, identities, life experiences, perspectives, beliefs, and values.
EEO StatementWe are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.#J-18808-Ljbffr