The Family Institute at Northwestern University · 1 day ago
Data & Automation Engineer
Chicago, IL
Full-time
Hybrid
Mid, Senior Level
$105K/yr - $145K/yr
5+ years expThe Family Institute at Northwestern University is a leading behavioral health organization dedicated to strengthening relationships through clinical services, education, and research. They are seeking a Data & Automation Engineer to design and implement scalable data and workflow automation solutions that enhance operational efficiency and support various departments within the organization.
Health CareMedicalNon Profit
Responsibilities
Design scalable, governed data architectures to support education, clinical, and shared services reporting
Build, optimize, and maintain Power BI semantic models and report suites; enforce consistent metric definitions via shared datasets and certification
Implement data quality checks (e.g., anomaly detection, completeness, referential integrity) and lineage & documentation (e.g., dataset descriptions, field definitions)
Lead the automation of high-volume or manual workflows using Power Automate and Copilot agents to intelligently route tasks, summarize inputs, and recommend next steps based on historical patterns
Develop and maintain Power Apps, Microsoft Lists, and Microsoft Forms to streamline data collection and operational processes
Collaborate with HR, Finance, Facilities, and IT (shared services) to design cross-departmental automation pilots that increase efficiency and reduce redundancies
Establish solution lifecycle standards (design - build - deploy - maintain) to ensure automations and reports are sustainable, documented, and supportable
Apply security and compliance best practices — including data loss prevention (DLP), role-based access, and least-privilege principles — across Power BI, Power Platform apps, and related data sources; ensure compliance with HIPAA, FERPA, and TFI policies
Maintain clear documentation (data flows, dependencies, ownership) and handoff guides to reduce risk and enable continuity
Run a transparent intake and prioritization process (request app, SLAs, scoring) with the VP of Strategic Insights & Analytics to manage the project pipeline
Partner with stakeholders in Clinical Operations, Education, HR, Finance, Facilities, and IT to map processes and deliver sustainable, high-impact solutions
Contribute to data governance by defining metrics, ownership, and review cadences, and by promoting consistent definitions across departments
Develop training and adoption resources (quick-start guides, FAQs, Copilot assistants, office hours) to drive self-service and long-term solution success
Stay current with Power Platform, Power BI, Microsoft Fabric, and emerging AI capabilities; recommend approaches that incorporate Copilot agents to improve scalability, usability, and cost-efficiency
Create quick-start guides, embedded help, and short how-to videos; enable super-users/champions and host office hours
Perform other duties as assigned by manager for business necessity
Qualification
Required
Extensive experience with Power BI, including building, optimizing, and troubleshooting semantic models and reports
Proficiency in Power Automate, Power Apps, Microsoft Forms, and Microsoft Lists
Experience with ETL processes, integrating data from multiple sources, including cloud-hosted applications and APIs
Familiarity with SQL or other data querying languages
Proven ability to develop workflow automations and streamline operational processes, including leveraging AI and/or leveraging Copilot agents to enhance decision-making, reduce manual effort, and intelligently guide users through complex workflows
Strong communication skills and the ability to collaborate effectively across technical and non-technical teams
Demonstrated project management skills, including scoping, execution, and delivery of analytics or automation projects
Ability to work independently and prioritize multiple initiatives
Bachelor's degree in Data Science, Computer Science, Information Systems, or related field, or equivalent work experience; Master's degree preferred
5-7 years of experience
Must be able to compose written reports clearly and effectively
Must be able to be in a stationary position due to attention to computer screen
The ability to communicate information and ideas so others will understand. Must be able to exchange accurate information in these situations
The ability to observe details at close range (within a few feet of the observer) to perform work-related duties
Must be able to apply established protocols in a timely manner
Must be able to determine solutions to problems
Must be able to operate successfully while handling multiple projects
Preferred
Experience in healthcare, education, or nonprofit settings
Knowledge of data warehousing (e.g., Azure Synapse, Amazon Redshift) and data governance best practices
Advanced analytics skills (Python, R, or SAS)
Experience with machine learning or predictive analytics
Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, Power Platform certifications, Certified Analytics Professional)
Benefits
Health
A 403(b) retirement savings plan
Generous time off
Professional development
Company
The Family Institute at Northwestern University
The Family Institute is a relationship-based behavioral health organizations.
51-200 employees
H1B Sponsorship
The Family Institute at Northwestern University has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (2)
2023 (1)
2022 (3)
2021 (2)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
ANTHONY (TONY) FIORE, CPA, MBA
Chief Financial Officer
Anthony Chambers, PhD, ABPP
Chief Academic Officer
Recent News
2025-05-17
Company data provided by crunchbase