Data & Automation Engineer

Primary Responsibilities

Data Architecture & Reporting 

1. Design scalable, governed data architectures to support education, clinical, and shared services reporting.  
2. Build, optimize, and maintain Power BI semantic models and report suites; enforce consistent metric definitions via shared datasets and certification.   
3. Implement data quality checks (e.g., anomaly detection, completeness, referential integrity) and lineage & documentation (e.g., dataset descriptions, field definitions). 

Workflow Automation & Process Improvement 

1. 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.  
2. Develop and maintain Power Apps, Microsoft Lists, and Microsoft Forms to streamline data collection and operational processes.  
3. Collaborate with HR, Finance, Facilities, and IT (shared services) to design cross-departmental automation pilots that increase efficiency and reduce redundancies. 

Solution Governance & Compliance 

1. Establish solution lifecycle standards (design ? build ? deploy ? maintain) to ensure automations and reports are sustainable, documented, and supportable.  
2. 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.  
3. Maintain clear documentation (data flows, dependencies, ownership) and handoff guides to reduce risk and enable continuity. 

Collaboration, Intake & Data Governance 

1. Run a transparent intake and prioritization process (request app, SLAs, scoring) with the VP of Strategic Insights & Analytics to manage the project pipeline.  
2. Partner with stakeholders in Clinical Operations, Education, HR, Finance, Facilities, and IT to map processes and deliver sustainable, high-impact solutions.  
3. Contribute to data governance by defining metrics, ownership, and review cadences, and by promoting consistent definitions across departments.  
4. Develop training and adoption resources (quick-start guides, FAQs, Copilot assistants, office hours) to drive self-service and long-term solution success. 

Innovation & Continuous Improvement 

1. 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.   
2. Create quick-start guides, embedded help, and short how-to videos; enable super-users/champions and host office hours. 
3. Perform other duties as assigned by manager for business necessity 

Summary of Qualifications

Knowledge and Skills 

1. Extensive experience with Power BI, including building, optimizing, and troubleshooting semantic models and reports. 
2. Proficiency in Power Automate, Power Apps, Microsoft Forms, and Microsoft Lists. 
3. Experience with ETL processes, integrating data from multiple sources, including cloud-hosted applications and APIs.   
4. Familiarity with SQL or other data querying languages.   
5. 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.  
6. Strong communication skills and the ability to collaborate effectively across technical and non-technical teams.   
7. Demonstrated project management skills, including scoping, execution, and delivery of analytics or automation projects.?  
8. Ability to work independently and prioritize multiple initiatives.? 
9. Experience in healthcare, education, or nonprofit settings, preferred.?  
10. Knowledge of data warehousing (e.g., Azure Synapse, Amazon Redshift) and data governance best practices, preferred.?  
11. Advanced analytics skills (Python, R, or SAS), preferred.? 
12. Experience with machine learning or predictive analytics, preferred.?  
13. Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, Power Platform certifications, Certified Analytics Professional), preferred. 
14. Perform other duties as assigned by manager for business necessity.  

Minimum Hiring Specifications

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