Data Analyst Intern

**Overview:** *Supporting the Vision, Values, Purpose and Commitment of Olive Fertility Centre:* At Olive Fertility, our primary focus is helping people build their families through exceptional, patient-centered care. We rely on rigorous data analysis to advise our medical and leadership teams, optimize our laboratories, and ultimately improve patient outcomes. **The Opportunity** We are currently expanding our network and standardizing our analytics infrastructure. We are seeking a Data Analyst Intern for a 4-month term to work directly with our lead Data Analyst. *Please note: This is a backend-heavy analytical role.* Rather than building dashboards from scratch, your primary focus will be writing advanced SQL to integrate new clinic data into our existing, master visualization templates. **The Project** Your primary project will be building the bridge between raw clinical EMR databases and our executive analytics layer. You will write advanced SQL in AWS Athena to extract, clean, and map disparate medical records into our centralized reporting schema. The data models you build will directly power the Power BI dashboards our Clinical Directors use to track critical KPIs, from laboratory efficiency to pregnancy rates. **Key Areas of Involvement Include**: · **Rigorous Validation:** Habitually checks that SQL outputs perfectly match real-world data before finalizing. · **Edge-Case Problem Solving:** Anticipates and handles data anomalies or missing fields to ensure downstream templates don't break. · **Clean Code Practices:** Consistently formats, comments, and organizes SQL scripts for easy maintainability and version control. **Qualifications:** **Technical Requirements:** · **Advanced SQL Proficiency**: Capable of writing complex queries using CTEs, Window Functions, and multi-table JOINs. · **Comfortable with Data Wrangling**: Able to map and transform messy, inconsistent raw data into a strict, standardized schema. · **Cloud Data Warehouse Experience**: Familiarity with querying and navigating cloud environments, specifically AWS Athena. **Other Qualifications** · Experience parsing and flattening semi-structured data in SQL. · Prior exposure to healthcare data, EMR/EHR systems, or handling sensitive PHI. · Basic familiarity with Power BI Desktop. · Presto experience is a plus. **Education, Training and Experience:** · Grade 12 graduation · Data sciences student or graduate **Skills and Abilities:** · Polite and friendly demeanour · Quick with tasks and accurate · Ability to discuss intimate topics related to infertility in a professional, compassionate manner · Professional, friendly demeanour that can effectively defuse difficult situations and put patients at ease · Ability to communicate effectively both verbally and in writing · Ability to work independently and as a member of a multi-disciplinary team · Demonstrated ability to organize and prioritize work in an environment subject to changing deadlines, stress and interruptions · Proficiency in the use of personal computers and applicable software applications · Physical ability to carry out the duties of the position · Excellent attendance record · Ability to speak and write fluently in English Pay: From $24\.00 per hour Work Location: In person