Data Engineer at Greater Boston Food Bank (GBFB)

Job Title: Data Engineer
FLSA Classification: Exempt (Salaried)

Reports to: Senior Director of Business and Data Analytics

Position Summary 

The Data Engineer is responsible for developing and maintaining GBFB’s data warehouse and other data-related products including API management, data ingestion, data modeling, cost/activity monitoring and implementing best practice solutions to improve data reliability, efficiency, and quality. They will share the Business and Data Analytics team’s goal to grow GBFB’s data management program, empower self-service reporting, and drive data-informed insights & action across GBFB.

Role & Responsibilities

• Develop data platforms including data warehouses, analytic products, data lakes, ETL, ML models, and data pipelines in collaboration with the Senior Director, data analysts, and subject matter experts.
• Centralize, transform, and model data in Azure to enable powerful analysis and draw a more comprehensive picture of user flows throughout our system.
• Enhance and optimize Azure data ingestion pipelines and automations.
• Develop and manage Boomi, Power Automate, and other data extract/load pipelines.
• Provide relational database expertise (Netsuite, Salesforce, SQL, etc.) to construct views and execute queries to be used in data visualization and analysis activities.
• Develop data models that can be used to make predictions and answer questions for the overall business.
• Develop self-service data solutions to provide a range of business leaders and functional areas insights into GBFB’s operations.
• Leverage industry best practices to ensure data quality standards are met.
• Apply and ensure adherence to IAM and Data Governance policies.
• Promote updated code through DevOps through the development, pre-production, and production tiered environment.
• Develop and execute tools to monitor and report on data warehouse activity, access and data quality and ensure optimized performance and cost efficiency. 
• Foster appreciation and adherence to the principles of data quality management.
• Collaborate with Technology team in managing security mechanisms and data access governance.
• Respond to data and product related inquiries to support business and technical teams.
• Support the development and implementation of the Service Insights client data collection effort through API management, data ingestion and modelling; providing expertise to ensure quality data capture, analytic capabilities, and support the potential for changing business needs and future growth.
• Act as backup to Data Analyst and Senior Data Analyst.
• Maintain and develop departmental Standard Operating Procedures
• Other duties as assigned.

Skills:

• Deep understanding of database design, architecture, and management.
• Knowledge of data warehousing architecture, concepts, methodologies, and best practices.
• Knowledge of data governance, data quality management concepts, and data quality tools. 
• Proficient in SQL, Python, and some experience with other programming languages for cloud platform (e.g., Java/C#/Unix).
• Ability to transform business requirements into technical requirements.
• Ability to develop machine learning models.
• Ability to analyze large and diverse data sets.
• Strong critical thinking skills.
• Excellent problem solving and troubleshooting skills.
• Strong relationship building and interpersonal skills.
• Strong communication skills both verbal and written.
• Ability to create insightful and accessible data visualizations.
• Ability to create professional and comprehensive reports and summaries.
• Flexibility and adaptability to emerging and changing priorities.
• Ability to multi-task and manage tight deadlines.
• Sensitivity to issues affecting low-income, food insecure populations.

Qualifications:

• MS in Computer Science, Engineering, or related field; BS in Computer Science, Engineering or related field and minimum of 3 years working in a Data Engineer or related role; or 5+ years of experience working in a Data Engineer role required.
• Hands-on experience with big data application development and cloud data warehousing (e.g., Spark, Redshift, Snowflake, Azure SQL DW, BigQuery) required.
• Knowledge of Azure Synapse and DevOps required; hands-on experience preferred.
• 2+ years of experience with SQL required.
• 2+ years of experience with scripting languages (Python, PowerShell) required.
• 2+ years of experience interacting with web service APIs (SOAP, REST) required.
• 2+ years of experience designing, implementing, testing, optimizing, and troubleshooting data ETL solutions preferred.
• Experience with BI reporting tools required, Power BI preferred.
• Experience with Boomi preferred.
• Experience with Power Automate preferred. 
• Demonstrates the required digital competencies that result in the effective usage of the full range of digital technologies at GBFB.

Physical Demands:

• Ability to work in an office environment.
• Ability to work remotely both independently and collaboratively using connectivity tools like Zoom and MS Teams.
• Ability to sit for up to 3 hours at a time.
• Ability to lift up to 25 pounds with or without assistance.
• Ability the use of hands for simple grasping and fine manipulations. 
• Ability to travel based on business needs. 

Work Location: 

• Hybrid: This role follows a hybrid schedule working in accordance with GBFB’s hybrid work policy on the team’s designated days. This schedule is subject to change based on the organization’s mission to end hunger.

Affirmative Action/EEO statement 

GBFB provides equal employment opportunities to all Team Members and applicants for employment without regard to race, creed, color, religion, national origin, citizenship status, gender, sexual orientation, marital status, age, disability, handicap, genetic information, protected veteran status or any other characteristic protected by applicable federal, state, and local laws. This applies to all terms and conditions of employment, including but not limited to hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, benefits, and training.

No Team Member or applicant will be subjected to harassment, intimidation, threats, coercion or discrimination because they have engaged in or may engage in any of the following: (1) filing a complaint of employment discrimination; (2) assisting or participating in an investigation, compliance review, hearing, or any other activity related to the administration of any federal, state or local law requiring equal opportunity; (3) opposing any act or practice made unlawful by any federal, state or local law requiring equal opportunity; or (4) exercising any other right protected by any federal, state or local law requiring equal opportunity.