Data Engineering Position | REMOTE | Analytics

MatchPoint Solutions is a fast-growing, young, energetic global IT-Engineering services company with clients across the US . We provide technology solutions to various clients like Uber, Robinhood, Netflix, Airbnb, Google, Sephora, and more! Data Architect

Remote
Department: Information Technology Services / Data & Analytics

Reports To: Director of Enterprise Data Architecture / Chief Data Officer

The Data Architect serves as the primary architect for the institution's enterprise data models, data warehouse schemas, and domain data flows. This role translates complex university operations-ranging from student admissions and financial aid to research administration and alumni development-into scalable, high-performance conceptual, logical, and physical data structures. The architect ensures all data design supports institutional reporting, predictive analytics, and emerging AI/ML initiatives while adhering to FERPA, regulatory compliance, and university data governance standards.

Data Modeling & Architecture

Build, maintain, and document enterprise-level conceptual, logical, and physical data models (3NF, Dimensional/Kimball, and Data Vault) spanning major campus domains (Student, HR, Finance, Research, Advancement).
Model integration pipelines across core Higher Ed systems (e.g., Ellucian Banner, Workday, PeopleSoft, Slate CRM, Canvas LMS, Salesforce).
Establish standard data definitions, canonical schemas, and business-friendly semantic layers to power institutional research, executive dashboards, and self-service analytics.
AI & Modern Data Readiness: Architect clean, well-structured data foundation layers optimized for cloud data warehouses (Snowflake, BigQuery, Redshift, Azure Synapse) and down-stream machine learning/AI applications.

Governance, Security & Quality

FERPA & Compliance: Ensure all designed schemas enforce strict security controls, row/column-level permissions, and alignment with FERPA, HIPAA, and institutional data privacy rules.
Data Standards & Metadata: Partner with Data Stewards to create and maintain institutional data dictionaries, business glossaries, and lineage diagrams.
Serve on the Architectural Review Board to review source-system schema changes, vendor software integrations, and custom application designs before implementation.

FTE calculations, census reporting, financial aid packaging) into technical specification models.
Partner closely with Data Engineers, DBAs, and Institutional Research (IR) teams to ensure physical deployment matches architectural blueprints.

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field (Master's preferred).

6+ years of professional experience in enterprise data modeling (Relational and Dimensional).
~3+ years of direct experience designing data structures within a Higher Education environment.

Deep familiarity with core Higher Education data domains (e.g., Student Lifecycle, Course Registration, Financial Aid, University Advancement/Donations, Sponsored Research Administration).
Data modeling experience across medallion arch in a lakehouse (critical must have). Core domains like HR, Fin, Student etc.

Advanced proficiency with enterprise data modeling tools (e.g., Understanding, documenting, and diagramming complex systems.
Strong expertise in cloud data platform architectures (Snowflake, AWS, Azure).
Advanced SQL, ELT/ETL design concepts, and metadata management solutions.

Banner/PeopleSoft) to modern cloud ERPs (e.g., Workday Student) or cloud data platforms.
Certification in Data Management/Architecture (e.g., Experience architecting data models for LLMs, RAG applications, or predictive retention models.
MatchPoint Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.