Staff Analytics Engineer

A pioneer in K–12 education since 2000, Amplify is leading the way in next-generation curriculum and assessment. Our core and supplemental programs in ELA, math, and science engage all students in rigorous learning and inspire them to think deeply, creatively, and for themselves. Our formative assessment products help teachers identify the targeted instruction students need to build a strong foundation in early reading and math. All of our programs provide educators with powerful tools that help them understand and respond to the needs of every student. Today, Amplify serves more than 15 million students in all 50 states. For more information, visit amplify.com. Our data analytics teams transform, model, and aggregate the data that empowers our customers to make sense of and tell stories with their data. You’ll be working with data scientists, data analysts, data engineers, and software engineers to provide clean, accurate, reliable models and metrics for our products. Help school administrators build great schools by: Respecting privacy and ensuring security while offering valuable insights Making inquisitive choices in tech stack, database design, masking policies, and encryption Building analytical models to fuel reporting we offer to administrators Helping school principals understand how teachers are teaching and how students are learning by Architecting data warehouse schemas and SQL transforms with just the right CTEs, window functions, and pivots Creating data solutions using tools like Snowflake, Airflow, DBT, SQL, Python, Cube.dev. Learn every day by: Immersing yourself in agile rituals and leveraging our infrastructure Leading collaboration, pull request-ing, CI/CD processes, and mentoring on a cross-functional team participating in cross-team share-outs, brownbags, and workshop series Becoming an expert in the data models and standards within Amplify to deliver quality and consistent solutions Example Projects You Might Work On Build well-tested and documented ELT data pipelines for full and incremental dbt models to funnel into Cube Sematic Layer models. Engineer novel datasets that express a student's progress and performance through an adaptive learning experience that allows for flexible comparison across students and deep analysis of individual students. Craft slowly changing dimensional models that take into account the nuances of K-12 education such as School Year changes and students moving schools or classes. Improving our pipeline deployments and tests Required Qualifications BS in Computer Science, Data Science, or equivalent experience. 8+ years of professional software development or data engineering experience 5+ years experience in computer, data, and analytics engineering. Expertise in computer, data, and analytics engineering. Expertise in SQL and its use in code-based ETL frameworks, preferably dbt, focusing on reuse and efficiency. Expertise in ETL/ELT pipelines, analytical data modeling, aggregations, and metrics Expertise in dbt and git preferably with automation skills. Expertise in analytical modeling architectures, including the Kimball design Strong communication skills in writing and conversation, including writing engineering training documentation. Preferred Qualifications Fluency in a development language such as Python Familiarity with metadata management tools such as Atlan 3+ years Experience building dashboards, reports, and models in business intelligence tools such as Tableau or Looker Expertise with tools we use every day: Storage: Snowflake, AWS Storage Services (S3, RDS, Glacier, DynamoDB) and Postgres ETL/ELT: Airflow, dbt, Matillion, Fivetran BI: Cube.dev, Looker, Tableau Experience with tools we don’t use, but should Proven passion and talent for teaching fellow engineers and non-engineers Proven passion for building and learning: open source contributions, pet projects, self-education, Stack Overflow Proven technical leadership in project delivery. Experience in education or ed-tech What we offer: Salary is only one component of the Amplify Total Rewards package, which includes a 401(k) plan, competitive health insurance and mental health options, basic life insurance, paid time off, parental leave, and access to best-in-class development programs. The gross salary range for this role is $175,000 - $185,000. This role is eligible to earn an annual discretionary bonus that rewards individual and company performance. Amplify is an Equal Opportunity Employer. Amplify makes employment decisions based on qualifications and merit, and does not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability status, veteran status, or any other legally protected characteristic or status. Amplify is committed to providing reasonable accommodations for qualified individuals with disabilities, including disabled veterans. If you have a disability and need an accommodation in connection with the application or hiring process, please email hiringaccommodations@amplify.com. . If you are selected for employment, a background check will be required. As required by state and local laws and district policies, you may be required to provide additional documentation, such as proof of vaccination, or submit to enhanced background screening, such as fingerprinting. Amplify is an E-Verify participant. Q: Do I have to create an account to apply for a job? A: Yes. Once you identify a position that interests you, you may apply by creating a Candidate Account. From the Candidate Home, you may search for additional opportunities, apply and check on your application status. *Note: Please refrain from using multiple email addresses to create multiple accounts, as this can cause issues with your application. If you need to change your email address, you can log into your original account and update it there. Q: I forgot my password. What should I do? A: Click on the Forgot Password option and you will be prompted to create a new password. Q: How do I know my application was received? A: You will receive an email confirming your application was submitted. A recruiter will review your application and if you meet the qualifications for the position, they will contact you to move forward in the hiring process. Q: How long does it generally take to hear back on the status of my application? A: There is not an exact time frame and updates can vary depending on the volume of applicants, it can take up to two weeks or longer to hear back from a recruiter. Q: Will I receive a response even if I am not selected? A: Yes. If your qualifications are a match for the job posting, a recruiter will contact you with additional steps. We also exercise our best efforts to notify, via email, all applicants that are not selected. Q: I’ve completed the application process. How can I check the status? A: Please log in to your Candidate Home to review your profile. To view the status of an application, review the "My Applications" section in the Candidate Home. If your status is in Review, this means your application is active and is still being reviewed for consideration. Q: Can I attach additional documents, such as cover letters and references? A: Yes. You can attach a cover letter and references in addition to your resume or CV when you are applying. filling out the application. However, once your application is completed and submitted, your attachment can no longer be edited and you cannot add another attachment. Carefully review and ensure that the correct version of your resume/CV is attached before submitting your application. Q: I do not see a position I am interested in. Can I apply without selecting a specific position? A: No. You must apply to a specific position. Q: Can I start my application and finish it later? A: Yes. If you log out before completing your application, you may save your progress. Log in to Candidate Home to view any incomplete applications in Candidate FAQ the “My Drafts” section. Q: If I apply for a position with your company, will Workday maintain my information for subsequent applications? A: Yes. You can use the last resume you uploaded or choose to upload a new resume, which will pre-populate your job application with new information. You can also choose to have your LinkedIn Profile information populate your application. However, you will need to complete an application for each position you apply for. Q: What if I have browser issues when trying to create a candidate account or submitting my application? A: Workday no longer supports version 10 or earlier of Microsoft Internet Explorer (IE). Use of unsupported versions may cause issues in the application process. It is recommended to upgrade to version 11 of IE or use another supported browser such as Google Chrome or Firefox. It is also recommended to clear your cache if you are experiencing issues. Q: How do I withdraw my application? A: Access “My Submitted Applications” from your Candidate Home. Click on the application and withdraw. *Note: Once you withdraw your application from a specific role, you cannot reapply to that same role. Q: I am a current contractor. Do I apply as an internal or external applicant? A: You must apply as an external applicant through a candidate account. If you are a current Amplify Employee, please apply as an internal candidate via your Workday Employee Profile Career Hub. Q: How long does it take to complete an application? A: Approximately 10 minutes. It depends on the detail you choose to provide in your application. Q: My email address has changed. Can I update my email information? A: Yes. If your email address has changed, you can log into your Candidate Home, click on your profile tab and select the Account Settings tab and update your email address. Q. My address has changed. Can I update my contact information? A: Yes. If your contact information has changed, you can log into your Candidate Home, click on your profile tab and update your contact information. Our culture We’re a community that rewards innovative thinking, prizes communication and takes fun so seriously we even have a committee for it. Share our view. Amplify is Brooklyn Based. Remote First. In-person sometimes. Get creative. We work hard to make learning as engaging as the best video games. Work as reward. We’re forging a community around a common purpose. The signs are everywhere. We take a lean and agile approach that allows us to get quicker and better results. Share, inspire. Collaboration helps us stay innovative.