United Food and Commercial Workers

Data Engineer

Based in Washington, DC
ufcw.org

 

Organization:
United Food and Commercial Workers International Union (UFCW) is North America’s neighborhood union; standing together to improve the lives and livelihoods of workers, families, and communities. Our members work primarily in the retail food, meat packing, poultry, food processing and manufacturing and retail store industries.

Location:
The position will be in our Washington, DC office, and they will report to the Director of the Data & Analytics Department.

SUMMARY
The Data Engineer will design and build the data systems needed to support UFCW’s mission. The position calls for expertise in maintaining scalable database infrastructure and pipelines. Collaborating with UFCW’s team of developers and strategists, this individual will be responsible for enabling UFCW’s data systems to be used across the organization for enhanced member communication, membership recruitment, and political campaigns.

ESSENTIAL DUTIES AND RESPONSIBILITIES
Include the following. Other duties may be assigned. This list is not exhaustive and may be supplemented.

• Designs, implements, tests, and maintains internal systems and automated pipelines, so that membership, voter, and other person level data can be leveraged inside and out of our central database.
• Produces scalable, replicable code, and engineering solutions that help automate processes and workflows.
• Creates documentation of data assets, data pipelines, and data transformations. 
• Works with other UFCW departments and vendors to integrate the flow of information across organizing, communication, and political tools used by UFCW.
• Collaborates with leadership and staff to establish standards for data collection, acquisition, preservation, analytics, and hygiene.
• Provides data, targeting, technological guidance, and support for organizing, bargaining, legislative and/or electoral campaigns.
• Works directly with and supervises staff in executing the work to ensure they are reaching program goals.
• Mentors staff on technology and data in organizing, member communication, membership recruitment, and political campaigns. May provide input for evaluation of performance. 
• Develops, recommends, implements, and maintains accountability systems relevant to department staff. Maintains detailed records of project activities.
• Works in close coordination with upper-level management and executive-level staff to evaluate resource usage. Creates recommendations and assists with implementation and corrective actions needed to optimize usage. 
• Ensure confidentiality and security of organizational data by adhering to best practices of data governance. 
• Duties, responsibilities, and activities may change, or new ones may be assigned at any time, in the UFCW’s discretion. UFCW employees function as a team and, occasionally, and on a temporary basis, employees may be required to perform tasks usually performed by others. This might occur if a team member is absent or unavailable to complete a project and the team is responsible for the 

QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.

Education and/or Experience

• BA or BS in related field or equivalent work experience and a minimum of one (1) to three (3) of related years experience required
• Strong command of SQL and relational databases. This includes extracting, transforming, and loading data. 
• Familiarity with dbt and best practices of database organization. 
• Familiarity with orchestration tools such as Airflow, Prefect, and Dagster as well as some familiarity with low-code data transfer tools such as Fivetran or Airbyte.
• General data manipulation skills: pull data, process and clean it, merge different data sets together, and re-format it for use across other systems. 
• Proficiency with Python or R, especially for the purpose of data manipulation and analysis. 
• Ability to use APIs to push and pull data from different systems and platforms. 
• Demonstrated ability to write code that is clear, detailed/well-documented, and stored in a version control system like Git. 

Communication Skills

• Effective time management skills, including demonstrated ability to manage and prioritize multiple tasks and projects. Excellent listening, interpersonal, communication and problem-solving skills.

Other Knowledge/Skills/Abilities 

• Demonstrated ability to learn new techniques and troubleshoot code on your own or using online sources.
• Demonstrated ability to work independently and as a self-starter, but also be able to work effectively in teams in either a lead or support role.
• Ability to work long and extended hours when needed.

Additional skills (preferred, not required)

• Familiarity with online and electoral tools and datasets such as Catalist, TargetSmart, VAN, LAN, or Every Action. 
• Experience working with cloud infrastructure services like AWS, Snowflake, and Google Cloud. 
• Experience with data visualization tools such as Tableau, PowerBI, or Looker.

Job Demands
Work often is performed under stressful situations, with multiple projects occurring simultaneously under deadline. 

Working Conditions
The work is typically performed in a normal office environment where the noise level is usually moderate.

Physical Demands
This position involves, but is not limited to, written and oral communications skills, use of computer keyboard, close vision, sitting for long periods, stooping, bending, and reaching.

Compensation
Salary Range: $93,401 – $110,00

The UFCW provides a very generous benefits package, including:

• Comprehensive health insurance coverage.
• Life insurance provided with ability to purchase supplemental life insurance at favorable rates.
• Retirement Savings Account.
• 401(k) plan with employer matching.
• Pension plan.
• Dependent care reimbursement account program.
• Health care reimbursement account program.
• Transportation program benefits.
• Three weeks of paid vacation, 12 days of paid short-term sick leave, Extended Sick Leave program, paid parental leave.
• Prepaid Legal Plan (for DC/MD/VA only).

To Apply:
Submit cover letter, résumé to: humanresources@ufcw.org

We believe our success rests on recruiting and retaining a diverse staff. UFCW is an equal opportunity employer. Woman and people of color are encouraged to apply. Reasonable accommodations will be provided pursuant to the state and federal laws.