Data Analytics Engineer / Senior Data Analytics Engineer

Boston, MA, United States

As ASA expands its digital transformation to drive its mission of creating resources and solutions for teenagers’ exploring their options for post-High School planning, it is seeking new and talented data analysts and engineers. Under the direction of the Senior Director of Strategic Insights & Program Outcomes, the Data Analytics Engineer is responsible for designing and building reliable data models and pipelines to provide large-scale data ingestion, aggregation, analysis and visualization projects for strategy and innovation insights, marketing and operations effectiveness, and outcomes measurement and reporting.

What’s ASA all about?

American Student Assistance (ASA) is a pioneer of student-led career learning helping millions of middle and high schoolers plan their futures – on their terms. Our mission is to radically transform the way careers are planned and pursued, and we’re doing this by creating digital tools that empower students to explore education and careers that align with their goals.

Since our founding in 1956, ASA has been at the forefront of educational innovation for middle and high school students nationwide. Our work has consistently adapted to meet their needs in a changing education landscape, and today, we’re focused on developing resources and opportunities that support students during the transition from high school into their careers.

ASA is a hybrid workplace with 2 required in office workdays per week on Tuesdays and Wednesdays.

As ASA expands its digital transformation to drive its mission of creating resources and solutions for teenagers’ exploring their options for post-High School planning, it is seeking new and talented data analysts and engineers. Under the direction of the Senior Director of Strategic Insights & Program Outcomes, the Data Analytics Engineer is responsible for designing and building reliable data models and pipelines to provide large-scale data ingestion, aggregation, analysis and visualization projects for strategy and innovation insights, marketing and operations effectiveness, and outcomes measurement and reporting.

The Senior Data Analytics Engineer’s Responsibilities Are To

Drive business impact by identifying and acquiring or mining data from multiple and diverse sources for actionable insights (including digital session web data, Salesforce and other CRM/CDP/IAM platforms, Google Analytics and Google BigQuery, etc.).

Manage the inflow and governance of that data as we warehouse it for staging, processing, and reporting, while building proper data quality detection to identify data issues in the transformation stages and fix problems to meet pipelines/table health SLAs, etc.

Deliver timely and high-quality analytics to internal and external stakeholders across product management, operations, marketing, partnerships, innovation and executive teams as they make data-informed decisions

Provide oversight/quality control direction to internal and external engineers/analysts, including development of talent, management of key 3rd party development and support services, etc.

Essential Functions

Develop, validate, monitor, and improve analytics and advanced modeling initiatives used to determine operational effectiveness, program outcomes, targeting initiatives and customer analysis to support insights development and strategic initiatives

Translate business requirements into technical specifications; establish and define details, definitions, and requirements of applications, components and enhancements

Explore, find, and strategize new uses from multiple, existing data sources to gain maximum insight

Design, build, and implement data pipelines and automated processes to enhance or create new data sets for use in analyzing trends and patterns, and production of custom reports and dashboards

Identify opportunities to collect and supplement analysis with external data, data partnerships, etc.

Present and communicate data findings, i.e., discover “stories” hidden in the data to Insights & Outcomes and other business leaders to help the organization understand operational outcomes performance, challenges, goals and provide recommendations on use of this information

Research external outcomes studies and reconstruct methodologies to develop comparable metrics

Maintain awareness of evolving analytical techniques, software and data sources to bring innovative approaches into the organization that drives higher quality results;

Contribute towards a robust best practices and governance program with respect to data discoverability, observability, lineage, stewardship and security strategies for protecting sensitive information and content

All other duties as assigned

Education & Experience

Computer Science, Math, Statistics, Engineering or other quantitative field or equivalent experience,

6+ years in a data analyst, business analytics engineer, business intelligence analyst or data analyst or related role with SQL experience and object oriented programming/scripting such as Python

Expertise in business intelligence, data visualization and dashboarding platforms (e.g., Tableau, Dataiku, Looker, etc.)

Strong knowledge of data management and modern data warehouse (Snowflake, Big Query) and ELT data acquisition/model building tools (Rivery, Fivetran), as well as dbt

Experience in dimensional data modeling and schema design, statistics and predictive modeling

Experience working with agile development methodologies such as Sprint and Scrum

Not required, but would be ideal if also had experience in providing leadership or mentorship to other engineers that fosters collaboration, knowledge sharing and high quality expectations

Skills

Strong critical thinking skills and ability to relate them to the services the company is providing

Ability to think and research creatively, possesses strong exploratory analysis and problem-solving skills, and is detail oriented

Extensive knowledge of industry practices

Demonstrated excellent verbal and written communication skills as well as the ability to bridge the gap between data and business by translating data results to strategic advice

Entrepreneurial spirit; ability to take the initiative to accomplish tough tasks and identify alternative solutions

Able to use deep breadth of analytics and market knowledge to guide strategy decisions by brand directors and provide support for those decisions in discussions with senior executives

Demonstrated excellent code writing abilities in programming languages like SQL (Structured Query Language), SAS, and SPSS (must pass a proficiency exam)

Proficient with Microsoft Office applications required; including SSRS reporting tool

Experience with digital and web analytics, and direct marketing a plus

Must provide examples of output related to described skill

Does a career at ASA align with your professional goals? Great! We look forward to reading your application.

#J-18808-Ljbffr