Senior Data Engineer

ABOUT THE COMPANY

VillageReach is a non-profit global health innovator that develops, tests, implements and scales new solutions to critical health system challenges in low-resource environments, with an emphasis on strengthening the "last mile" of healthcare delivery. VillageReach combines expertise across public health, technology, and business to bring life-saving innovation – new systems, programs and technologies – to scale and sustainability in the world's most underserved communities.

Effective solutions require a deep understanding of local health systems, a diverse set of skills and expertise, and strong relationships on the ground in order to achieve sustainable impact. More than a decade of studying and working in low-resource communities around the globe drives our approach— focus on solutions that
address the most critical barriers to improving health outcomes in LMICs: healthcare accessibility, lack of infrastructure, information availability, and human resource constraints.

JOB SUMMARY

SummaryVillageReach 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.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 organizationCollaboration & 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 informedCommitment 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 VillageReachCommitment 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 VillageReachSolution 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-makingRequirementsREQUIREMENTSTo 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 assetOther 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.

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 pipelinesImplement 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 WarehousingDesign 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 TuningTroubleshooting 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 DashboardsCreate 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.

REQUIRED SKILLS

Python, Business intelligence, Big data and data analytics, Database query languages (SQL, others)

REQUIRED EDUCATION

Bachelor's degree