Skip to main content

This job has expired

Data Architect

Employer
Northeastern University
Location
Massachusetts, United States
Salary
Salary Not specified
Date posted
Jul 29, 2021


Data Architect

About Northeastern:
Founded in 1898, Northeastern is a global research university and the recognized leader in experience-driven lifelong learning. Our world-renowned experiential approach empowers our students, faculty, alumni, and partners to create impact far beyond the confines of discipline, degree, and campus.

Our locations—in Boston; Charlotte, North Carolina; London; Portland, Maine; San Francisco; Seattle; Silicon Valley; Toronto; Vancouver; and the Massachusetts communities of Burlington and Nahant—are nodes in our growing global university system. Through this network, we expand opportunities for flexible, student-centered learning and collaborative, solutions-focused research.

Northeastern's comprehensive array of undergraduate and graduate programs— in a variety of on-campus and online formats—lead to degrees through the doctorate in nine colleges and schools. Among these, we offer more than 195 multi-discipline majors and degrees designed to prepare students for purposeful lives and careers.

About the Opportunity:
The Northeastern community has a tradition of giving back, and each day, we witness the impact of our community's remarkable generosity. Our students are pursuing co-ops in all corners of the globe, growing their cultural fluency and preparing to thrive in the world. Our faculty are delivering leading-edge scholarship, teaching and mentoring tomorrow's leaders. And our researchers are pioneering new lines of inquiry, accelerating discovery in emerging fields. Northeastern University Advancement and the Advancement Resources team play an integral role in engaging the Northeastern community to create a strong, more sustainable, and bright future.

Responsibilities:
The Advancement Information Systems Data Architect will be responsible for designing, developing, and managing data models for enterprise level reporting systems. The Data Architect will design, implement and execute scalable integrations between university enterprise applications that enforce data quality and adhere to strict consistency standards. They will serve as an engineer/expert in ETL/Integrations, Data Warehousing, Business Intelligence, Master Data Management, and database design. The Data Architect will work with staff throughout Advancement to understand and analyze business requirements and translate those requirements into effective data integration and data exchange programs and processes. They will assist with reviewing, researching, and resolving data errors or missing data.

The Data Architect will design and develop ETL programs to extract data from various source systems, transform as required, and load data into specified target systems using best-in-breed tools such as Informatica and OWB. They will maintain enterprise-wide integrity of data by ensuring that data currency and data cleansing procedures are implemented and followed.

The Data Architect will serve as the primary advocate for data stewardship and data processing best practices within Advancement Information Systems. They will set and maintain standards and best practices as the principal data architect and assist in research, testing of new functionality, data cleanup/archiving, data lifecycle management, and other tasks as necessary.

Qualifications:
  • Bachelor's Degree in computer science, information systems, or related IT field with coursework in an information technology specialization related to data modeling.
  • 5+ years of experience in an information technology area related to data architecture & data modeling.
  • 5+ years of experience with enterprise-level ETL tools/platforms such as Informatica, Power Center, Cast Iron, Oracle Warehouse Builder (OWB), Oracle Data Integrator, etc.
  • 5+ years of experience working with complex relational databases, including normalization of data models.
  • 5+ years of experience with Data Warehousing data population techniques for target structures such as Snowflake Schemas
  • Highly developed knowledge of Data Warehouse design principles with dimensional data modeling for Business Intelligence tools.
  • In-depth knowledge of PL/SQL with experience in constructing effective and efficient database triggers and stored procedures.
  • Knowledge of performance tuning, database monitoring, SQL optimization, data archiving, table partitioning, indexes, etc.
  • Experience in enterprise-level data migration/upgrade projects
  • Experience in database administration and analyzing impact of underlying data structural changes.
  • Experience in managing metadata and supporting data governance initiatives.
  • 2+ years of experience with Customer Relationship Management platforms
  • Effective written and verbal communication skills, including presentation skills
  • Self-motivated, able to work independently, and capable of responsibly maintaining schedules for time-sensitive projects.
  • Strong attention to detail and organizational skills.
  • Experience with Salesforce.com and its suite of products (Marketing Cloud, Service Cloud, Tableau, etc.) preferred
  • Experience with Ellucian's Banner Advancement and/or Ellucian's Banner Student preferred

    Salary Grade:
    13

    Northeastern University is an equal opportunity employer, seeking to recruit and support a broadly diverse community of faculty and staff. Northeastern values and celebrates diversity in all its forms and strives to foster an inclusive culture built on respect that affirms inter-group relations and builds cohesion.

    All qualified applicants are encouraged to apply and will receive consideration for employment without regard to race, religion, color, national origin, age, sex, sexual orientation, disability status, or any other characteristic protected by applicable law.

    To learn more about Northeastern University's commitment and support of diversity and inclusion, please see www.northeastern.edu/diversity.



    To apply, visit https://careers.pageuppeople.com/879/cw/en-us/job/506860

    jeid-4710491fb9e35b4982f6157a4c54f85c

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert