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.
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