Data Engineer

Company: Combined Jewish Philanthropies
Location: Boston
Posted on: May 16, 2022

Job Description:

Passion. Purpose. Impact. CJP is at the heart of Greater Boston's Jewish community, but our reach is felt around the world. We bring together the resources, volunteers, leadership, and expertise to care for people in need, advocate for Israel, and ensure a vibrant Jewish future. Together, we're helping struggling families find financial stability, making Jewish learning relevant and inclusive, connecting the next generation to Jewish life, and so much more. Our greatest resource is our people - the staff, volunteers, partners and leaders who help make Greater Boston's Jewish community a welcoming home. It's this energy and commitment that drive CJP's mission. We are one of Boston's oldest and most respected philanthropic organizations and we are currently seeking a Data Engineer.



The Data Engineer will facilitate the integration of our CRM, marketing automation platform, GL accounting system, and data warehouse. They both creatively solve data problems and introduce innovation to existing processes. This position will be responsible for building and maintaining data pipelines on Google Cloud, as well as identifying opportunities for improved data processes. The Data Engineer will support our database analysts, developers, and data initiatives and will ensure optimal data flow architectures across the organization. We're looking for an individual who enjoys building efficient and resilient systems and automating manual processes. They will collaborate with both technical and non-technical partners to architect data to serve business needs. The ideal candidate has experience designing and implementing cloud data pipelines, with a focus on best practices. This person will be detail-oriented, possess strong communication skills, and be able to organize and prioritize tasks. They will prioritize data security in their work, both at the design and implementation stage. They should have experience with serverless computing, cloud warehousing, and data-oriented programming. Essential Functions:

• Create and maintain optimal data pipeline architecture across CJP
• Plan and implement data integrations between CJP's critical systems, including our CRM, Marketing platform, online giving solution, and GL accounting system.
• Partner with the Measurement and Evaluation team to implement a programmatic data pipeline.
• Identify and automate manual processes across the organization, serving as an internal consultant.
• Ensure the security of our donor data by following and sharing security best practices
• Other duties as assigned with or without accommodation. - - - MINIMUM REQUIREMENTS : Education:
  • Bachelor's degree in computer science or a related subject Experience:
    • 3 years' minimum experience in working programmatically with data
    • 3 years' minimum experience with database management systems (SQL Server, Oracle, and/or MySQL) Skills/Competencies:
      • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) and table design, as well as working familiarity with BigQuery or similar
      • Strong Python programming skills, with a focus on data manipulation/transformation and related libraries.
      • Knowledge of serverless computing best practices and ability to independently design and implement data pipelines.
      • Experience systematically cleaning messy and incomplete data, matching data from multiple systems, and general data munging for the purpose of solving business needs
      • Experience creating audit-able data processes and knowledge of security best practices
      • Proven ability to independently partner with non-technical stakeholders to identify and solve business problems through data processes
      • Experience with a cloud computing environment, preferably Google Cloud Platform
      • Experience with HubSpot
      • Ability to quickly learn and work with third-party data APIs
      • Excellent interpersonal and communication skills with both technical and non-technical audiences
      • Knowledge of statistics and experience with data modeling, preferably using Python or BigQuery ML
      • Experience with a dashboarding tool, preferably Microsoft PowerBI
      • Experience working with an enterprise CRM, preferably Blackbaud CRM
      • Familiarity with non-profit business model and operations
      • Ability to learn and utilize highly specialized software applications
      • Ability to work independently or collaboratively, as the situation demands
      • Ability to multi-task effectively
      • Ability to develop and maintain relationships with clients, consultants, collaborators and co-workers
      • Ability to organize and prioritize tasks; also, flexible and willing to accept changes in priorities
      • Strong attention to detail Working Conditions:
        • Remaining in a stationary position, often standing or sitting for prolonged periods, much of which will be working at a computer.
        • Must be able to lift up to 15 pounds. CJP offers that rare opportunity to tap your skills, talents, and experience to benefit a greater good while you grow professionally. You will work in a dynamic environment, with a diverse group of individuals who share your commitment and enthusiasm. Together, you will make a difference for Jews and non-Jews in Greater Boston and worldwide. We offer competitive salaries, comprehensive benefits and a collegial, family-friendly work and team environment. - - For more information about CJP, go to - Please use this link to apply: - CJP conducts background checks as part of the hiring process. - CJP is an equal opportunity employer. People with disabilities, women, veterans, black, indigenous and people of color, and LGBTQ people are encouraged to apply. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.

Keywords: Combined Jewish Philanthropies, Boston , Data Engineer, Engineering , Boston, Massachusetts