Data Engineer

Data Engineer

  • Full Time
  • BOSTON

Website The Greater Boston Food Bank

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

 Reports to: Director of Business and Data Analytics

 

Position Summary 

The Data Engineer is responsible for managing and organizing GBFB’s data and identifying and implementing solutions to improve data reliability, efficiency, and quality. This role will work with system architects, data analysts, and team members across the organization to develop GBFB’s data architecture, aligned with business requirements, to support a self-service data ingestion framework.

 

Position Essential Duties and Responsibilities

Develop data platforms including data warehouses, analytic products, data lakes, ETL, ML models, and data pipelines in collaboration with enterprise architects, 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
Develop and manage Boomi data pipelines and APIs
Provide relational database expertise (Netsuite, Salesforce, SQL, etc.) to construct and execute queries to be used in data analysis activities 
Develop data models that can be used to make predictions and answer questions for the overall business
Develop self-service data ingestion strategy and 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
Develop and execute tools to monitor and report on data access and quality, and ensure optimized performance
Foster appreciation and adherence to the principles of data quality management
Collaborate with Technology team in managing security mechanisms and data access governance 
Support ongoing Digital Transformation work; provide expertise and translate the business needs to design; and develop tools, techniques, metrics, and dashboards for insights and data visualization
Respond to data and product related inquiries to support business and technical teams
Support development of the “Service Insights” program, working closely with the Community Investment Team to implement network-wide adoption, providing expertise to ensure quality data capture, analytic capabilities, and support the potential for changing business needs and future growth
Maintain and develop departmental Standard Operating Procedures

 

Knowledge, Skills and Abilities

Deep understanding of database design, architecture, and management
Familiarity with data warehousing concepts, methodologies, and best practices
Knowledge of data governance, data quality management concepts, and data quality tools 
Proficient in a relevant programming language for cloud platform (e.g., Python/Java/C#/Unix) as well as SQL
Ability to develop machine learning models
Ability to analyze large and diverse data sets
Ability to create insightful and accessible data visualizations
Strong critical thinking skills
Excellent problem solving and troubleshooting skills
Strong communication skills both verbal and written
Project Management and Planning skills
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
Demonstrated resiliency; strong relationship building and interpersonal skills
 

Mandatory Education and Experience

BS in Computer Science or related field required; MS in Computer Science or related field preferred
3+ years of data engineering and/or data warehousing experience required
Hands-on experience with big data application development and/or with cloud data warehousing (e.g., Spark, Redshift, Snowflake, Azure SQL DW, BigQuery) required
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
Experience with Microsoft Azure preferred
Experience with Boomi preferred
Experience in analyzing, organizing, and visualizing data
2+ years of experience working with a nonprofit organization preferred
Experience with Netsuite and Salesforce preferred
Experience with BI reporting tools (e.g. Power BI, Tableau, etc.) required
Experience in quantitative analysis and statistical modelling required
Experience working within process management, service management, and/or improvement/development methodologies (e.g. ITIL, Agile, Lean, Six Sigma) preferred 
Remote, high-speed internet access required
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 Teams
Ability to sit for up to 3 hours at a time

To apply for this job please visit workforcenow.adp.com.

Diversity@Workplace