Description
Duties and Responsibilities
Data Modelling and Extract,
Transform and Load (ETL):
- Design and implement robust data models
to support analytics and reporting requirements.
- Develop and maintain scalable ETL
processes from various sources, including multiple ERP systems, into a
data warehouse.
- Implement best practices for data
transformation and cleansing to ensure data integrity and reliability.
Data Ingestion and Automation
data pipelines
- Implement data validation and quality
checks to ensure accuracy and completeness.
- Design, build, and maintain automated
data pipelines to streamline data processing and transformation.
- Utilize orchestration tools to schedule
and monitor pipeline workflows.
- Collaborate with data analysts to
understand data requirements and support their analysis needs.
- Optimize data structures and queries to
enhance performance and usability for analytical purposes.
Data Warehousing
- Design and optimize data warehousing
solutions to support business intelligence and analytics needs.
- Implement data modelling techniques to
organize and structure data for optimal querying and analysis.
Optimization and Performance
Tuning
- Troubleshooting and fixing issues on
existing reports/dashboards while also continuously building improvements.
- Optimize dashboard performance and ensure
responsiveness for large datasets and complex queries.
- Identify and address performance
bottlenecks through optimization techniques and best practices.
Design, Data Visualization and
Dashboards
- Create visually compelling reports and
dashboards using industry-standard tools.
- Create and design user centered reports
and dashboards with ability to provide the most important insights to
different user groups.
- Work closely with stakeholders to
understand reporting requirements and deliver actionable insights through
visualization.
Competencies
- Personal Motivation and Drive: Is self-directed in one’s approach to work, but asks for help
when needed; holds oneself accountable; undertakes self-development
activities; seeks to build and master new skills; looks for and takes
advantage of opportunities within the organization
- Collaboration & Effective Communication: Establishes and maintains effective relations with coworkers,
partners & stakeholders and external parties; works collaboratively
with others to accomplish organizational and team goals and objectives;
works actively to resolve conflicts; expresses ideas and thoughts
effectively; selects and uses appropriate communication methods and
maintains meaningful communication with virtual coworkers and other
parties to keep them informed
- Commitment to Diversity & Inclusion: Takes personal responsibility for and supports others across
the organization in creating and sustaining a diverse work environment
where individuals are welcomed, valued, respected and supported;
personally committed to attaining cultural competency including
self-awareness of one’s own attitudes about culture and cross-cultural
interactions; exhibits the willingness and ability to engage openly and
respectfully around issues of race, colonialism, identity and culture;
upholds equity in access to sharing of information, ideas, and
opportunities throughout VillageReach
- Commitment to Excellence: Produces a high output of work, both in terms of quality and
quantity; looks for ways to improve and promote quality; monitors work to
ensure quality; has a personal commitment to the mission of VillageReach
- Solution Orientation & Innovation: Focuses on results and desired outcomes and how to best
achieve them; gets the job done; sees opportunities for creative
problem-solving while staying within the parameters of good practice; sees
old problems in new ways and has novel approaches to solving those
problems; contributes original and/or resourceful ideas to their area of
responsibility; is able to consider and articulate risks and consequences
of proposed innovations and factor these into decision-making
Requirements
Supervisory Responsibilities:
- This position does not have direct
supervisory responsibilities. However, the position will serve as the
primary technical liaison for all enterprise data and analytics, ensuring
seamless integration and alignment with organizational goals. The position
holder will also Collaborate with business leaders to design and implement
innovative data and business intelligence solutions, focusing on
automating pipelines, reports, and interactive dashboards for actionable
insights.
Education & Experience:
- Preferably a Master’s and a minimum of
Bachelor’s degree in computer science, Information systems, Engineering,
or a related field.
- 7+ years of experience in data
engineering, with a focus on data ingestion, pipeline automation, ETL
development, and data warehousing.
- Should demonstrate significant PowerBI
development experience, with the ability to build and maintain
multi-dimensional data models, troubleshoot errors, run DAX queries, set
up new data pipelines, and design and deploy new reports.
- Proficiency in programming languages such
as Python, Java or Scala.
- Working knowledge of databases, data
systems, and analytics solutions, including proficiency in SQL, Python and
MS Synapse for reporting and dashboard building.
- Experience with big data technologies
with implementation experience on Azure Data solution and tools &
Azure Synapse solutions.
- Strong SQL skills and familiarity with
relational and NoSQL databases.
- Experience working with non-technical
stakeholders to drive adoption and use of data.
- Experience ingesting data from ERP
systems and familiarity with non-profit organizational processes is highly
desired.
- Excellent project management skills, with
experience developing project plans, gathering user requirements with
non-technical business partners, and adhering to project timelines.
- Project management certification is an
asset
Other Qualifications:
- Comply with VillageReach’s COVID-19
vaccination policy which requires full vaccination for in-person work or
travel.
- Established cultural competency in
partnering with racial, cultural and linguistically diverse groups.
- Demonstrated understanding of challenges
with working in rural, underserved and low-income context; experience
living in and/or working in a low-income country a plus.
- Proficient in Microsoft Office Suite
(Word, PowerPoint, Outlook, Excel) and comfortable in a fast-paced
technical environment.
- Fluency in oral and written English is
required, and proficiency in French or Portuguese would be advantageous.
How To Apply