OVERVIEW:

The Analytics Engineer is a critical role in the Business Intelligence team, working toward the goal of designing and implementing complex data-driven decision-making solutions for Year Up United. Sitting in IT, the Analytics Engineer collaborates with and influences analysts and business users across the organization to produce analytical material that enables a more rigorous and empirical understanding of our operations and outcomes through data.

Business Intelligence sits at the intersection of business and technology, and this role is grounded in both. As a technical position, our day-to-day work primarily consists of leveraging the modern data stack that drives insights for hundreds of staff across the country. Year Up United takes an evidence-based approach to program development and improvement (see our Research & Evaluation results). The Analytics Engineer must become fluent in Year Up United’s operations and quantitative management systems while effectively serving as an internal consultant who can demonstrate insights that measure organizational impact and results.

This is an ideal role for a deeply analytical individual is a self-starter, a quick learner, and someone who wants to help close the Opportunity Divide that exists in our country.

In keeping with Year Up United’s values, the Analytics Engineer will have the opportunity to interact with students as coach, group facilitator, and advocate, participating in creating and sustaining a positive educational environment, with trust among students, faculty, and site leaders.

KEY RESPONSIBILITIES:

The Business Intelligence team manages the entire data pipeline, from data extraction through reporting. As an Analytics Engineer, you will leverage our modern data stack to design and produce data models and visualizations that drive data-informed decision-making. You will partner with multiple levels of leadership, including senior leadership, to understand the motivations and goals of functional teams so that we can iteratively develop effective outcomes.

Key responsibilities include:

• Collaborate with team members and functional stakeholders to collect business requirements and desired results. Design effective data models and dashboards to support organizational objectives.
• Approach solutions with an outcomes-oriented agile mindset and an inclination toward iterative development, ensuring meets its deliverables each sprint.
• Design, test, and extend dimensional data models in dbt that meet our internal standards for scalability, accuracy and best practices. Maintain and advocate for these standards through code review.
• Extract data from external sources relevant to the mission of Year Up United, including education, demographics, and employment, through Fivetran, Matillion, or similar.
• Utilize software engineering best practices such as version control via Git, CI/CD, and release management.
• Implement data quality frameworks and data quality checks.
• Work independently and effectively manage time across multiple priorities and projects.
• Support ad-hoc requests and production issues identified using Service now system.

Additionally, there may be a long-term opportunity for:

• Project Management
• Data Governance

QUALIFICATIONS:

• 3+ years in the Data and Analytics space as an analyst, engineer, or an equivalent role designing, implementing, operating, and extending dimensional models with SQL (Jinja or Python a plus).
• 1+ years SQL-based analysis within a cloud-based data warehouse, preferably Snowflake.
• 1+ years’ experience building reports and dashboards in a data visualization tool, preferably Tableau.
• Experience managing SQL transformations as code using dbt (data build tool) or similar.

• Experience building reliable and resilient data pipelines using tools like DBT and Matillion.
• Knowledge of software engineering best practices: DRY code, version control, code reviews, and CI/CD.
• A passion for working with young adults, an unshakable belief in their potential, and a strong commitment to the mission of Year Up United.
• Understanding of the Opportunity Divide and its drivers.
• Commitment to diversity and inclusion.

Candidates with experience in one or more of the following will be particularly competitive:

• Managing a backlog of user stories using agile project management practices and methodologies
• Professional experience working in a related field, especially in IT or Education
• Familiarity with Salesforce, Netsuite, Workday and Adaptive
• Experience with our stack: dbt, Matillion, Snowflake, Fivetran, Tableau, AWS

Salary Range: $60,200 - $90,000

#LI-Hybrid

COMPENSATION & BENEFITS:

• Year Up United has established salary ranges for each of our sites, which allows us to pay employees competitively, equitably and consistently in different geographic markets. For roles in which the location is listed as flexible, the range displayed reflects the minimum and maximum target for new hire salaries for the position across all US locations. Salary offers take into account a candidate’s skills, experience, and location. Your recruiter can share more about the specific salary range for your location during the hiring process.

• Benefits: Comprehensive healthcare options and dental coverage; 401(k) match for eligible participants.

• Vacation: Earn three weeks paid vacation in first year of employment; four weeks after initial year.

• Professional Development: Funds available to support staff in achieving career objectives ($2,500 per year)

** This is an exempt role (paid on a salaried basis). **

ORGANIZATION DESCRIPTION:

Year Up United is a national 501(c)3 workforce development organization committed to ensuring equitable access to economic opportunity, education, and justice for all young adults—no matter their background, income, or zip code. Employers face a growing need for talent while millions of talented young adults lack access to meaningful careers. These inequities only further perpetuate the opportunity gap that exists in our country—a gap that Year Up United is determined and positioned to close through three interconnected strategies: providing targeted skills training and connections to livable-wage employment for students and alumni; empowering others to serve and support young adults, and changing systems that perpetuate the opportunity gap. Year Up United’s intensive training program utilizes a high expectations, high support model where students learn in-demand technical and professional skills and apply them during a corporate internship. Year Up United has directly served more than 40,000 young adults since its founding in 2000. Year Up United's nationwide presence includes Arizona, Austin, Bay Area, Charlotte, Chicago, Dallas/Fort Worth, Greater Atlanta, Greater Boston, Greater Philadelphia, Jacksonville, Los Angeles, the National Capital Region, New York City/Jersey City, Pittsburgh, Puget Sound, Rhode Island, South Florida, Tampa Bay, and Wilmington.

Voted one of the Best Nonprofits to Work For in the country by The NonProfit Times, Year Up United is a rewarding and impactful place to work. Our staff is passionate, supportive, mission-driven, and committed to positive change and continuous learning. We set high standards for both ourselves and our students and live by a set of core values that reflect an unshakable belief in the talent and potential of our young people. The work we do is life-changing, and we know that our team is the greatest asset in achieving our mission.

COMMITMENT TO DIVERSITY:

Year Up United embraces diversity and equal opportunity in a serious way. All aspects of employment, including the decision to hire, promote, discharge, or discipline, are based on meritocracy. We do not permit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristics protected by federal, state, or local laws. Learn more about our commitment to diversity: http://www.yearup.org/about-us/careers/commitment-to-diversity/

Year Up United is also committed to working with and providing reasonable accommodations to individuals with disabilities. Your recruiter can provide details regarding the expected work environment and any physical requirements. Please let our hiring team know if you need an accommodation at any point during the interview process. Information received relating to accommodation will be addressed confidentially.

TO APPLY:

Please submit a thoughtful cover letter and resume through our website.

Note that applications without a cover letter will not be considered. We respectfully request no phone calls.