Summary
VillageReach seeks an experienced and highly
motivated individual to join the Global Operations and IT team as the Senior
Data Engineer. The individual will focus on harnessing data power to drive
actionable insights. As a Senior Data Engineer, you’ll be the champion of our
Data Modernization initiative, which seeks to ensure that managers and
functional leads throughout the organization are able to access and leverage
high-quality data to make informed business decisions.
This role will involve driving the rollout of an
enterprise warehouse solution, building data engineering systems that support
robust and scalable dashboards and reports. The successful candidate in this
role will combine deep knowledge of data structures, systems and of business
processes to gather requirements, identify unmet data insights needs and design
elegant solutions that allow business users to leverage data when making key
financial and management decisions.
Description
Essential Duties and Responsibilities include the
following. Other duties, responsibilities, and activities may change or be
assigned at any time.
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:
The following competencies reflect what is expected
of all VillageReach employees; including examples of how one might demonstrate
each of these competencies in one’s role.
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
To perform this job successfully, an individual must
be able to perform each essential duty satisfactorily. The requirements listed
below are representative of the knowledge, skill and/or ability required.
Reasonable accommodation may be made to enable individuals with disabilities to
perform the essential functions.
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