About the position
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. 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 who 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.
Responsibilities
- 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 deliverables are met each sprint.
- Design, test, and extend dimensional data models in dbt that meet internal standards for scalability, accuracy, and best practices.
- Maintain and advocate for data 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 ServiceNow system.
Requirements
- 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.
Nice-to-haves
- 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.
Benefits
- Comprehensive healthcare options and dental coverage
- 401(k) match for eligible participants
- Earn three weeks paid vacation in first year of employment; four weeks after initial year
- Funds available to support staff in achieving career objectives ($2,500 per year)
