Data & Automation Engineer

Full-time

Description

DEPARTMENT : Professional Services

REPORTS TO : VP OF STRATEGIC INSIGHTS & ANALYTICS

LOCATION : Chicago IL

FLSA CLASSIFICATION : EXEMPT

THE ORGANIZATION

Through clinical services education and research The Family Institute at Northwestern University is one of the nations leading relationship-based behavioral health organizations committed to strengthening and healing children and adolescents couples families and individuals. When you join The Family Institute you are joining a team of over 230 collaborators comprised of clinicians educators researchers therapists-in-training partners and administrators across three service sites. We are a strong independent organization focused on advancing the world of behavioral health.

Learn more about our culture.

THE ROLE

We are seeking a Data & Automation Engineer to join the Analytics team at The Family Institute at Northwestern University. This role designs and implements scalable data and workflow automation to support education programs clinical services and shared services (HR finance facilities and IT). The ideal candidate will have deep experience in Power Platform (Power BI Power Automate Power Apps Microsoft Lists) a strong understanding of data architecture and a proven ability to translate organizational needs into actionable tools and insights in a HIPAA / FERPA-constrained environment.

This position will increase operational efficiency enable data-driven decisions and reduce manual work across departments. The engineer will report to and partner closely with the VP of Strategic Insights & Analytics to prioritize projects and deliver solutions with enterprise-level impact.

ESSENTIAL JOB RESPONSIBILITIES

Data Architecture & Reporting

• 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).

Workflow Automation & Process Improvement

Solution Governance & Compliance

Collaboration Intake & Data Governance

Innovation & Continuous Improvement

SUMMARY OF QUALIFICATIONS

Knowledge and Skills

MINIMUM HIRING SPECIFICATIONS

Requirements

PHYSICAL AND MENTAL REQUIREMENTS

EQUAL OPPORTUNITY EMPLOYER

The Family Institute is an equal opportunity employer. We are committed to equal employment opportunity regardless of race color ancestry religion sex national origin sexual orientation age citizenship marital status disability gender identity Veteran status or any other protected class. We strive to create a working environment that is free of all forms of discrimination and one that promotes human dignity and mutual respect among all staff. We believe every member of our organization enriches our diversity by exposing us to a broad range of ways to understand and engage with the world to identify challenges and to discover design and deliver solutions.

If you are a candidate with a disability and require reasonable accommodation to complete this application please direct your inquiries to the Recruiter.

Compensation is based on a number of factors including but not limited to : scope and responsibilities of the position; a candidates applicable work experience key skills and qualifications as well as internal and external market considerations. The pay range for this full-time exempt position is $105297.00 - $144727.00 / year. The Family Institute provides competitive benefits including health a 403(b) retirement savings plan generous time off and professional development. For a more inclusive list of benefits please visit our Careers page at

Key Skills

Continuous Integration,APIs,Automotive software,Test Cases,Electrical Engineering,Junit,Distributed Control Systems,Testng,Java,Test Automation,Programmable Logic Controllers,Selenium

Employment Type : Full-Time

Experience : years

Vacancy : 1

Yearly Salary Salary : 105297 - 144727