DATA ARCHITECT

NGO Jobs / UN Jobs Vacancy



Country: United States of America
Organization: CARE USA
Closing date: 5 Jun 2021

CARE is an international NGO with local staff and community partners in more than 90 countries. We create local solutions to poverty and inequality and we seek dignity for everyone every day and during times of crisis. These solutions have a broad range, from clean water to access to education; from microfinance to ensuring that everyone has nutritious food; from agriculture and climate change to disaster response. CARE puts women and girls at the center of everything we do because they have proven to be the best hope for creating lasting change in the world. Our staff live where they work, which makes us effective at understanding the challenges they face. We’ve been doing this for over 70 years, since World War II. It started with the world’s first CARE Package® of food for the post-war hungry in Europe. Our work today is as important as ever, we believe that poverty and inequality are historic injustices that we can end within a generation, for good. If you share our core beliefs: poverty is an injustice; poverty is solvable; and together, we have the power to end it, join us, and fight with CARE.

CARE is looking for a Data Architect with cloud experience to be part of our Digital team. This person will design, develop, maintain and support our Enterprise Data Warehouse & BI platform within Care, this position has the ability to directly affect lives, by leveraging the power of data.

  • Work in an agile environment to analyze, design, develop and deliver Enterprise Data Warehouse solutions using Cloud technologies and Big data platform.
  • Create ETL pipelines using Python, Azure data factory, Airflow.
  • Work on creating data pipelines to create and maintain Data lake on AWS or Azure Cloud or equivalent cloud platform.
  • Work with systems that handle sensitive data with regulatory compliance and change management processes, including data masking, row and column level data security implementations.
  • Develop collaborative relationships with key sponsors and IT resources for the efficient resolution of work requests.
  • Analyze raw data sources and data transformation requirements for structured, semi-structured and unstructured data.
  • Experience working with REST API and micro services based data integrations to complete data ingestion from varied data sources, open source platforms.
  • Write code, and leverage tools, to transform data to incorporate business logic as defined in conjunction with various stakeholders.
  • Work with team members through all phases of the Systems Development Life Cycle (SDLC) using Agile practices.
  • Develop and design solutions to support the data analytics and reporting needs, with data warehouse / No SQL and Power BI
  • Good communication skills to present technical solutions, architecture and standards supporting the Digital teams data policies and best practices.

Responsibilities:

  • Data Architect - Develop various data architecture solutions to ingest, transform, load and model data warehouse using cloud and big data technologies; develop and conduct proof of concept using cloud technologies to rapidly develop solutions supporting various data science initiatives; develop a reusable framework to ingest data from various data sources for varied patterns to create pipelines using Python or Spark scripting languages, to transform and store data in a Big data platform; analyze raw data sources and data transformation requirements and apply AWS or Azure technologies.
  • Data modeling and warehouse design - Lead the effort to derive insight and data mining by doing data analysis of different datasets; follow advanced modeling techniques to create data relationship diagrams and enhance model to support future needs; conduct workshops and lead sessions working with internal teams, research specialists, operational teams to develop data architecture solutions supporting the desired functionalities; identify root cause and recommend solutions based on data analysis of problem statement and work on designing and implementing solutions based on priorities; work on developing conceptual, logical and physical models reflecting the different subject areas.
  • Data analytics and reporting - Design the data warehouse to support various data analytics to support different data science and reporting needs; work in collaboration with global teams to develop standards and design high quality deliverables to optimize large datasets and harmonize disparate in a common data store; data partitioning, indexing and parallelizing to performance tune complex business queries to support reporting and visualization; support ongoing reporting effort following best practices and principles of data architecture, for highly performing reporting solutions with Power BI; partner with CARE teams to support, administer and enhance Power BI reports, users and security setup and configurations; assist and support in establishing a Community of practice for Analytics and reporting.

Qualifications:

  • Undergraduate degree in Computer Science or Information systems.
  • 2+ years of hands on experience programming on AWS or Azure technologies.
  • 3+ years of experience in Software Development Life Cycle (SDLC) - Datawarehouse and BI projects.
  • Hands-on experience with related/complementary open source software platforms and languages (e.g. Java, Scala, Python, Unix)
  • Experience using Microsoft SQL server and expertise in modeling the tables/views.
  • Experience in implementation of ETL applications preferably Azure data factory (ADF), Data warehousing principles, architecture and its implementation in large to medium environments.
  • Analytical and problem solving experience applied to a Big Data environment.
  • Excellent query writing skill and communication skills.

How to apply:

https://phg.tbe.taleo.net/phg02/ats/careers/v2/viewRequisition?org=CAREUSA&cws=52&rid=5458

There are individuals who may use CARE’s name and trademark in emails and on websites in an attempt to solicit fees from interested job-seekers. Some examples of these fees are placement fees or immigration processing fees. CARE does not use recruiting or placement agencies that charge candidates an up-front fee of any kind. Occasionally, CARE does employ recruiting or placement agencies to help us identify candidates for specific employment within CARE. If you’re contacted by a legitimate recruiting or placement agency, there should be no charge to you. If you suspect that you have been a victim of fraud from someone purporting to be CARE, please contact us at legal@care.org.

We provide equal employment opportunities (EEO) to all employees and qualified applicants for employment without regard to race, color, religion, gender, gender identity, ancestry, sexual orientation, national origin, age, handicap, disability, marital status, or status as a veteran. If you’d like more information about your EEO rights as an applicant under the law, please click here.



Apply to Job

Related Job Vacancies

Secretary - ASN Trustee Board

Office Manager- HQ

Nigeria - Head of Mission in Abuja

Project Coordinator

Head of Office, Humanitarian Affairs, D1 (Temporary Job Opening)