Junior Data Engineer

Socket.dev; Atlanta (GA); Hybrid; USD 70,000 - 90,000; Full time

Job summary

U.S. Soccer is seeking a Junior Data Engineer to support strategic technology projects. You will join the product team to support scalable data warehouse solutions, integrate new systems, manage identity resolution, and align data ingestion with business objectives.

This role reports to the Vice President of Engineering. Responsibilities include building data pipelines, ensuring data quality, and collaborating with engineers, analysts, and stakeholders to improve the data lifecycle from

Qualifications

• Bachelor's degree in computer science or related field.
• Strong foundation in Python and SQL.
• Experience with cloud-based data solutions (AWS preferred).
• Experience delivering reliable data sets for BI/analytics/data science.

Responsibilities

• Integrate new data sources and ensure seamless data flow across the organization.
• Implement and manage ETL processes to move data into the warehouse.
• Support scalable data warehouse solutions and automate data pipelines.
• Collaborate with engineers and analysts to ensure data integrity and quality.

Skills

Python

SQL

AWS

Data pipelines

Data modeling

Problem solving

Education

Bachelor's degree in computer science or related field

Tools

Prefect

AWS Redshift

Job description

Description

U.S. Soccer Overview

The U.S. Soccer Federation exists in service to soccer. Our aim is to ignite a national passion for the game. Because we believe that soccer is more than a sport; it is a force for good.

We understand the importance and the power of teamwork, on and off the pitch. That is why we work closely with our Federation partners and members, to inspire, support and guide every level of the game: from the grassroots to the National Teams. We want to bring soccer into every home and every community, right across America. Because we believe that soccer can transform lives like no other sport. Soccer can represent the best of U.S.

U.S. Soccer is in a period of significant growth, with ambitious plans for U.S. Soccer in the near and far future. We are, therefore, looking for dynamic servant leaders to join us on this journey: in service to soccer. Applicants must be able to demonstrate visionary leadership, analytical decision-making, professional flexibility, and an empathic management style that builds bold teams and delivers globally significant results.

Position Description

U.S. Soccer is seeking a Junior Data Engineer to support strategic technology projects. This individual will join U.S. Soccer’s growing product team and support scalable data warehouse solutions, integrate new systems with existing infrastructure, manage our identity resolution process, and align data ingestion with business objectives. This position reports to the Vice President of Engineering.

Primary Responsibilities

• Integrate new data sources and ensure seamless data flow and accessibility across the organization.
• Implement and manage Extract, Transform, and Load (ETL) processes to move data from various sources into the warehouse.
• Assist in the development and testing of new features, models, or data processes within our data warehouses, leveraging feedback to drive continuous improvement.
• Ensure the accuracy, integrity, and security of data within the warehouse, establishing policies and auditing regularly.
• Monitor and optimize database and system performance, troubleshooting issues to ensure efficiency.
• Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation.
• Assist with our in-house unification process and all downstream data integrations.
• Collaborate with engineers, analysts, and other stakeholders to ensure integrity and quality of data throughout the entire data lifecycle, from ingestion to analysis, by implementing data validation and cleansing processes.

Requirements

Minimum Qualifications

• 0-2 years experience with cloud-based BI and data solutions (AWS preferred)
• Proven experience operating production pipelines
• Strong foundation in Python and SQL
• Bachelor's degree in computer science or related field
• Strong experience delivering reliable data sets for BI, analytics, and data science—…
• Excellent problem-solving skills and attention to detail.
• Experience working with relational and dimensional data models
• Must be a self-starter comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools and concepts quickly
• General knowledge of soccer
• Must be able to connect “micro” details to the “macro” vision and mission
• Proficient experience with Microsoft Suite (Word, PowerPoint, Excel, and Outlook)

Desired Qualifications

• Experience utilizing Prefect for data orchestration
• Experience managing data warehouses in AWS Redshift
• A background in, and passion for, soccer, sports and/or entertainment is preferred
• Familiarity with Salesforce data structure and concepts
• Ability to handle multiple projects, tasks, and priorities
• Collaborative, team-player with a results-driven mindset
• Must be able to connect “micro” details to the “macro” vision and mission

U.S. Soccer offers a comprehensive compensation package, casual work environment, an inclusive culture, and an atmosphere for professional development.

U.S. Soccer is an equal opportunity employer that is committed to diversity, equity, and inclusion, and prohibits discrimination and harassment of any kind on the basis of race, color, sex, religion, national origin, citizenship, pregnancy, sexual orientation, gender identity, age, disability, genetic information, military status, political belief, or any other characteristic protected under the law. This policy applies to all our employment practices within our organization. We strongly encourage women, people of color, LGBTQIA, veterans, parents, and persons with disabilities to apply