Data Engineer - Houston, United States - Houston Food Bank

Description

Job Description

Starting Pay: $75,000-$93,750

POSITION SUMMARY:

The Houston Food Bank is looking for an experienced Data Engineer with an agile mindset. This position will contribute to the design, implementation, and maintainability of our cloud-based data processing infrastructure. The Data Engineer will help support a team that is improving the lives of people, every single day.

Adhere to PACT values. (Purpose: Using our strengths passionately to contribute to our mission. Accountability: Choosing to rise above one's circumstances and demonstrating ownership to achieve results. See It. Own It. Solve It. Do It. Courage: Standing up for what's right and acting. Transparency: Doing things openly and honestly).

ESSENTIAL JOB FUNCTIONS:

1. Designs, builds, and maintains large-scale production data infrastructure.
2. Works on systems critical to Houston Food Bank's (HFB's) current and future operations.
3. Debugs production issues across services and multiple levels of the stacks.
4. Creates and maintains technical documentation.
5. Improves engineering standards, tooling, and processes.
6. Develops API integrations and troubleshoots reporting database environments and reports.
7. Supports the data warehouse in identifying and revising reporting requirements.
8. Provides technical expertise on data storage structures, data mining, and data cleansing for peers.
9. Assesses tests, implements new or upgraded software, and assists with strategic decisions on new systems.

SUPERVISORY RESPONSIBILITIES:

This position has no supervisory responsibilities.

QUALIFICATIONS:

Education/Experience:

• Bachelor's degree from an accredited four-year college or university in Computer Science, Information Technology, Engineering, Mathematics, or a closely related field required
• 1+ years of experience writing and optimizing SQL queries, working with relational databases, and understanding database concepts
• 1+ years of experience with data manipulation, analysis, and scripting using Python or R
• 1+ years of experience using Git for version control, managing code repositories, and collaborating with other team members
• 1+ years of RESTful APIs, experience with making API requests, and parsing JSON or XML responses
• 2+ years of experience with creating structure models
• 2+ years of experience in any AWS service or equivalent Cloud-based data warehouses or Data pipeline services
• Experience with AWS services and concepts, such as S3, EC2, or Redshift preferred but not required
• Experience with DBT for data transformation and modeling within a data warehouse environment preferred but not required
• Exposure to BI tools such as Tableau, Power BI, or Looker, with experience in creating visualizations, dashboards, and reports preferred but not required

Certificates, Licenses, and Registrations:

NA

Special Knowledge/Skills/Abilities:

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability needed. Reasonable accommodation may be made to enable qualified individuals with disabilities to perform the essential functions. (For best performance, the job holder in this position would be expected to show the right knowledge, skills, and abilities in the listed areas.)

• Ability to work with a diverse population
• Must be able to stay on top of tasks and projects to ensure deadlines are met
• Must have a love for designing systems that are elegant abstractions over complex patterns/practices
• Must be able to think about systems, services, and platforms, and write high-quality code. We work mostly in Python
• Must take pride in craftsmanship and working on projects to successful completion involving a wide variety of technologies and systems
• Willingness and strong ability to learn new skills and computer programs efficiently

COMPLIANCE:

Carries out responsibilities in accordance with HFB policies.

REASONING ABILITY:

Ability to apply common sense understanding to carry out detailed but uninvolved written or oral instructions. Ability to deal with problems involving a few concrete variables in standardized situations. To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability needed. Reasonable accommodation may be made to enable qualified individuals with disabilities to perform the essential functions. (For best performance, the jobholder in this position would be expected to show the right knowledge, skills, and abilities in the listed areas.)

COMPETENCIES:

Business Insight / Instills Trust / Drives Engagement / Optimizes Work Processes / Directs Work / Composure / Manages Ambiguity / Communicates Effectively / Organizational Savvy / Decision Quality / Manages Conflict / Presentation Skills

PHYSICAL REQUIREMENTS:

The physical requirements described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. While performing the duties of the job, the employee is required daily to analyze and interpret data, communicate, and remain in a standing or stationary position for a significant amount of the workday; and often access, input, and retrieve information from the computer and other office productivity devices. The employee must regularly move about the office and around the facility, use hands, wrists, and fingers to grip, type, and write. The employee must frequently lift 10 pounds. The employee will need to have the average ability to hear horns, warnings, and alerts associated with a warehouse. The employee must frequently travel to other sites for business.

WORK ENVIRONMENT:

The work environment characteristics described here are representative of those employee encounters while performing the essential functions of this job. While the job is generally performed in an enclosed office environment, the employee is occasionally exposed to wet and/or humid conditions, strong food-related smells, and outside weather conditions. The noise level in the office environment is typically quiet, but the employee will be occasionally exposed to loud noise levels (e.g., horns, fans).

TRAVEL REQUIRED:

No travel is required for this role.

This role supports hours of operations at the Houston Food Bank facilities, as necessary, and may require flexibility (e.g., times of disaster, community events, company events).

*Is legally able to work in the United States.

The foregoing statements describe the general purpose and essential job functions needed for this job and are not an exhaustive list of all responsibilities, working conditions, qualifications, and skills that may be needed.

Houston Food Bank (HFB) is an equal employment opportunity employer. We consider individuals for employment or promotion according to their skills, abilities, and experience. We believe that it is an essential part of the Company's overall commitment to attract, hire and develop a strong, talented, and diverse workforce.

HFB is committed to complying with all applicable laws prohibiting discrimination based on race, color, religious creed, age, national origin, ancestry, physical, mental or developmental disability, sex (which includes pregnancy, childbirth, breastfeeding, and medical conditions related to pregnancy), veteran status, military status, marital or registered domestic partnership status, medical condition (including cancer or genetic characteristics), genetic information, gender, gender identity, gender expression, sexual orientation, as well as any other category protected by federal, state or local laws.