Data & Insights Architect

Northwestern University; Chicago (IL); On-site; USD 95,000 - 105,000; Full time

Job summary

Northwestern University is seeking a data analytics and data science professional to manage Kellogg’s career outcomes data, ensuring data integrity and timely delivery of official reports to senior stakeholders. The role oversees the Career Management System for 2,300 students, handling data standards, reporting workflows, and cross-campus collaboration.

Using Python, SQL, and Power BI, you will build dashboards and analytical products that inform operations and strategy, with emphasis on

Qualifications

• Bachelor’s degree in a quantitative field.
• 4+ years of experience in data analytics/data science.
• Advanced proficiency in Python and SQL.
• Experience designing and maintaining data pipelines and structured reporting processes that ensure data integrity, reproducibility, and auditability.
• Strong foundation in statistical analysis, predictive modeling (including risk classification and longitudinal analysis), and data validation methodologies.
• Experience developing reports, dashboards, and data visualizations using business intelligence tools (e.g., Power BI, Tableau, or Cognos BI) to support executive decision-making.
• Experience developing reproducible analytical workflows using tools such as R Markdown, Quarto, or Jupyter
• Demonstrated ability to translate complex analytical findings into clear, actionable insights for non-technical stakeholders.
• Strong project management skills with the ability to manage multiple priorities independently in a deadline-driven environment.
• Excellent written and verbal communication skills, including the ability to present analytical findings effectively to diverse audiences.

Responsibilities

• Design, build, and maintain scalable data pipelines integrating multiple enterprise systems.
• Architect automated, version-controlled analytics workflows ensuring reproducibility and auditability.
• Develop production-ready reproducible analytical products using R Markdown, Quarto, and Jupyter for reporting automation.
• Ingest, transform, model, and visualize structured and unstructured data.
• Engineer robust data validation frameworks and automated quality monitoring.
• Publish technical artifacts and ensure secure, reliable data infrastructure in partnership with IT.
• Lead end-to-end analytical lifecycle from problem framing to stakeholder delivery.
• Administer surveys with rigorous controls to maintain definitional integrity and comparability.
• Apply statistical modeling and longitudinal methods to uncover performance drivers and trends.
• Communicate findings through data storytelling and executive-ready presentations.

Skills

Python

SQL

Power BI

Tableau

Cognos BI

R Markdown

Quarto

Jupyter

Data storytelling

Communication skills

Education

Bachelor’s degree in a quantitative field

Tools

12Twenty

Azure

Git

Job description

Northwestern University is seeking a data analytics and data science professional to manage Kellogg’s career outcomes data, ensuring data integrity and timely delivery of official reports to senior stakeholders. The role oversees the Career Management System for 2,300 students, handling data standards, reporting workflows, and cross-campus collaboration.

Using Python, SQL, and Power BI, you will build dashboards and analytical products that inform operations and strategy, with emphasis on