Data Analyst, Enterprise Data Warehouse

Location: Hybrid/RemoteDivision: Information Technology, Enterprise Data WarehouseAbout The Salvation ArmyFor more than 130 years, The Salvation Army (TSA) has had the privilege of serving vulnerable people in communities across Canada and Bermuda. Last year, we helped over 2.6 million people, providing necessities of life such as food, clothing, and shelter. And our work goes well beyond that to including supporting people through unemployment, loneliness, finding church community, and responding to family challenges. We continually adapt to meet emerging needs.These are exciting times at The Salvation Army as we launch a significant digital and business transformation. We are in the midst of revolutionizing our core capabilities to maximize service and mission outcomes. This will include an integrated platform for relationship and people management, learning, intranet and data warehouse. In order to achieve all this, we are now recruiting for a Data Analyst.What You’ll DoReporting to the Director, Data Management you will support Data Modeler work for Implementation of the Territorial Data Warehouse within The Salvation Army’s digital transformation programWork with the Business teams and business analysts on the extraction, analysis, and interpretation of relevant data points from different source systems to map them to Territorial Data Warehouse models (source to target data mapping)Support data migration efforts required for the implementation of the Territorial Data Warehouse, work with internal stakeholders and System Integrators in gathering business requirements for data migration needs and data mapping requirements?Undertake essential data integrity, complex queries, analytic and report generation tasks and conduct data consistency and quality checksIdentify, solve and/or escalate issues/risks/decision and implement the approved actions and workarounds required to mitigate risk/issues in order to minimize the impact on the projectSupport data governance initiative and collaborate with Data StewardsCollaborate with Territorial Headquarters, Divisional Headquarters, Ministry Units and frontlines to meet their reporting and analytical needs: gather reporting and data requirements, map data - source to target, analyze, profile, validate data, assess data quality, provide data quality benchmarking, support data extraction, conversion, and integrationWhat You Bring A university degree in computer science or approved equivalent combination of education and experienceKnowledge of BI/Analytics platforms required. Certification in Tableau is preferredCertification in Snowflake is an asset7-10 years of work experience in data analysis including:5-7 years of experience in data ingestion and extraction from the Enterprise Data Warehouse (EDW)3-5 years of experience in data quality, data migration and data integration2-3 years of experience in data governanceExperience of working in complex, multi-systems / companies and in high priority and highly visible projects?Experience of working within delivery teams on projects of significant size, in an agile environmentExperience working in an Agile environment?Proficiency in Microsoft Office, Tableau/Power BI, Data QualityExperience working with Microsoft SQL Server and SnowflakeProficiency in writing data queries (SQL)Excellent analytical and problem-solving skillsWhat We PromiseBelonging to a creative, dynamic team of IT professionals where what you do will make a difference in your own backyard and across Canada & BermudaContinuous learning and growth through challenging workThe chance to be part of a leading digital and business transformation for over 100,000 employees and volunteersAn opportunity to launch and/or grow your career with a huge, stable, international not-for-profit organizationWe live our Core Values as a faith & values-based organization, we hire and serve people of all backgrounds, faiths, and traditions – there’s a place for everyone to belong hereHow We HireWe are committed to creating a workplace where people experience meaningful work, a sense of hope and optimism, an environment of trust, and inspired results. If this sounds like an environment in which you would like to work, apply today!We embrace equity, diversity, justice, inclusion and belonging and we’re committed to building a team that represents many backgrounds, perspectives and skills, representative of the communities we serve. The more inclusive we are, the better our work and workplace will be.The Salvation Army will provide reasonable accommodation upon request. Please let us know if you have a need for any accommodation.We thank all applicants and will contact candidates selected for next steps. Internal Applicants, please speak with your manager about your intentions prior to submitting your application. Job Posting closes on June 19, 2023 to internal candidates.