**Visible Talent Company is the Inclusive Agency Interviewing on Behalf of the Employer**
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 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 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