Data Solutions Analyst

Get AI-powered advice on this job and more exclusive features. Ottawa Community Housing Corporation (OCH) provided pay range This range is provided by Ottawa Community Housing Corporation (OCH). Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range CA$43.75/hr - CA$53.26/hr Direct message the job poster from Ottawa Community Housing Corporation (OCH) Join us at Ottawa Community Housing, where we are more than a home to about 33,000 tenants across approximately 15,000 homes. As Ottawa's largest social and affordable housing provider, ranking second largest in Ontario and fourth largest in Canada, we're committed to enhancing tenant well-being through partnerships with local service providers and support agencies. At OCH, diversity and equal opportunities are at the core of our workplace culture. We strive to mirror the vibrant communities of our city and have been honoured as the National Capital Region's Top Employer every year since 2018. WE ARE PROUD BECAUSE EVERY DAY WE MAKE A DIFFERENCE Together, we're transforming tenants' lives by “providing more than a home, because we care”. What we offer: Joining OCH means making a meaningful difference every day. We provide opportunities to positively impact your community in multiple ways. Recognizing that our employees are the cornerstone of our organization, we offer a comprehensive and competitive compensation and benefits package, flexible work options, professional development opportunities, health and wellness programs, and more. What we seek: OCH is currently seeking a dedicated Data Solutions Analyst. Under the guidance of the Manager, Data Programs, the Data Solutions Analyst is responsible for the execution of Ottawa Community Housing’s (OCH) data strategy. The position helps build and maintain a data-driven culture by developing, implementing, and managing scalable and secure data solutions across the organization. The Analyst collaborates with internal departments and stakeholders to resolve data integration challenges, enable insights and automation, and ensure the effective use of OCH’s data lake environment. As a Data Solutions Analyst, some of the things you will do include: Data Engineering & Architecture Design, implement, and optimize data pipelines (ETL), ingestion flows, and transformation processes using Microsoft Azure Data Factory (Data Factory) and Data Flows Gen2. Build and manage Lakehouse tables within OneLake to support analytical and operational workloads. Administer and monitor Fabric environments, including workspace management, pipeline scheduling, and storage governance. Integrate source systems (structured and semi-structured) and develop schema designs to ensure data quality and scalability. Support CI/CD practices for reusable, automated data workflows. Prepare clean, governed datasets and maintain clear documentation for BI developers and analysts. Assist with Power BI report development, including data modelling, DAX measures, and performance optimization to ensure reports are insightful and user-friendly. Support data governance practices such as metadata management, data cataloging, lineage tracking, and secure access configuration in Fabric. Translate business questions into clear data tasks and visualizations that drive decision‑making. Stakeholder Collaboration & Continuous Improvement Collaborate with IT teams and business subject‑matter experts to ensure solutions are aligned, scalable, and secure. Understand operational and strategic data use cases across departments and provide practical, scalable solutions that meet their needs. Act as a trusted advisor to stakeholders, ensuring data solutions are intuitive, actionable, and aligned with business priorities. Promote a culture of continuous improvement and innovation in data practices across OCH. Internal / External Accountabilities Promptly reports all workplace accidents or incidents and unusual or dangerous work conditions Represents OCH in a professional manner and treats all work‑related contacts with respect and courtesy Works in collaboration with other staff in a team approach to service delivery Works in alignment with OCH vision, mission, values, interests, plans and objectives Performs work in accordance with applicable health, safety and privacy legislation, policies and procedures, and all other legislation, policies and procedures relevant to area of work. As a Data Solutions Analyst you can look forward to: A hybrid workplace with unique and ever‑changing work tasks every new day Opportunities for growth and career development Using your expertise to help bring positive changes to communities that need it the most What you bring: Education & Experience: Post‑secondary degree or diploma in Computer Science, Data Analytics, Information Systems, or a related field. Minimum 3 years of professional experience in data engineering, analytics, or business intelligence roles. Proven experience with Azure cloud technologies, including Data Factory, Power BI Lakehouse, and OneLake. Exposure to Microsoft Fabric and complementary tools like Databricks or Snowflake Experience with ETL/ELT design, data modeling, and pipeline orchestration. Exposure to DevOps practices, Git version control, and deployment pipelines Certifications such as DP‑203, DP‑600, or related AI/Cloud credentials is an asset. Strong understanding of data lakehouse architectures, security principles, and governance. Familiarity with SQL, DAX, Power Query, and KQL (Kusto Query Language). Knowledge of data governance, privacy, and compliance standards. Understanding of Agile methodologies and data governance principles. Skills and abilities: Strong analytical and problem‑solving skills with attention to detail. Excellent communication and interpersonal skills with a collaborative client‑focused mindset. Ability to work independently and adapt in a fast‑paced, evolving environment. Entrepreneurial mindset with a passion for enabling data‑driven decision‑making. Oral fluency and reading and writing abilities in English is required. Oral fluency and reading and writing abilities in French is an asset. Other requirements: Satisfactory Criminal Records Check Must posses a valid "G" driver's license or equivalent and may require access to a vehicle for business purposes. Work conditions: This is a full‑time hybrid position with on‑site attendance as required. OCH is committed to providing accommodations for people with disabilities. If you require an accommodation, please notify Human Resources and we will work with you to jointly address your needs. Apply now Seniority level Associate Employment type Full‑time Job function Analyst, Information Technology, and Strategy/Planning Industries Non‑profit Organizations Referrals increase your chances of interviewing at Ottawa Community Housing Corporation (OCH) by 2x. Get notified about new Data Analyst jobs in Greater Ottawa Metropolitan Area. #J-18808-Ljbffr