• Salesforce Data Architect

    Insight Global (University Park, PA)


    Job Description

    One of our large education clients is looking for a Salesforce Data Architect to join their team. This is a fully remote (working EST), 12-month contract to hire opportunity.

    Key Responsibilities:

    Architectural Leadership & Strategy

    • Architect and implement an enterprise-grade data migration framework to support Penn State University’s varied and complex systems and processes.

    • Help develop robust ER data models that ensure data integrity, accuracy, and compliance.

    • Help review / complete data migration mapping spreadsheets / criteria with functional teams.

    • Establish architectural standards, governance practices, and a “golden source” data strategy aligned with institutional goals and higher ed data needs.

    Informatica ETL & Integration

    • Design, develop, and optimize ETL workflows transforming, cleansing, and unifying data across disparate systems.

    • Ensure rigorous data validation, logging, error handling, and operational monitoring to maintain data quality throughout migration processes.

    • Knowledge of the Informatica platform including its capabilities and limits preferred.

    Project Leadership & Collaboration

    • Lead cross-functional teams (data engineers, admins, business stakeholders), managing timelines, risks, and deliverables with clarity.

    • Translate complex business requirements into scalable, reliable technical solutions.

    • Manage stakeholder communication: set expectations, report progress, escalate risks, and ensure transparent decision-making.

    Operational Oversight & Documentation

    • Oversee migration execution: scheduling, job monitoring, troubleshooting failures, root cause analysis, and applying corrective actions

    • Maintain detailed technical documentation—ETL mappings, data dictionaries, architecture diagrams, runbooks, and support manuals.

    • Coordinate with IT teams to ensure alignment with university-wide data security, compliance, and disaster recovery standards.

    Continuous Improvement & Innovation

    • Evaluate existing data systems and propose enhancements for scalability, performance, and governance.

    • Stay current with emerging data technologies, Informatica and Salesforce best practices, and higher education industry trends.

     

    We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

    Skills and Requirements

    10 years of experience as a data architect/engineering with Salesforce

     

    experience designing ETL workflows

     

    experience working with cross-functional teams