Analytics Engineer - U.S. Based Remote Opportunity

About UsDo you have a passion for higher education? Do you want to make a positive impact on the college admissions process? Our staff help to remove barriers and encourage students to forge their path to a better future. Common App is a national not-for-profit organization dedicated to the pursuit of access, equity, and integrity in the college admission process. Each year we support more than 1 million students, one-third of whom are first-generation, as they apply to our more than 1100 diverse member colleges & universities using the Common App's free online application.If you are an experienced analytics professional and want to be part of a mission-driven non-profit that uses innovative technology to advance the college admission process, Common App may be a great match for you. Common App is currently searching for a Analytics Engineer.ResponsibilitiesThe Analytics Engineer is the technical architect responsible for evolving Common App's shared data warehouse, semantic layer, and reusable data assets to enable scalable analytics, data governance, and artificial intelligence readiness across the organization. This role is central to operationalizing governance standards within enterprise systems and building the shared data foundations that power the Applied Analytics and Research team.Reporting to the Senior Director, Analytics Engineering, the Analytics Engineer partners with Data Engineering and Applied Analytics and Research to deliver insight-ready data, and with Data Governance to ensure that governance rules and standards are technically enforceable within the enterprise data platform. This role focuses on developing Common App's reporting schema, refactoring existing tables and pipelines for performance, cost efficiency, and maintainability; designing and implementing automated data quality frameworks; establishing monitoring and alerting for critical datasets and pipelines; maintaining warehouse data documentation; and architecting data products that structure the platform for scalability, quality, and self-service.The Analytics Engineer is a recognized subject matter expert in data platform engineering who combines deep data modeling expertise with a platform mindset, delivers outstanding results, and drives innovation in how Common App's shared data infrastructure is designed and governed.RequirementsQUALIFICATIONSThis role requires:Candidates must live in the United StatesWilling to travel to attend twice annual Common App RetreatBachelor's degree in Computer Science, Information Systems, Data Engineering, Statistics, or a closely related quantitative or technical field; or an equivalent combination of education and experience5-8 years of progressive experience in analytics engineering, data engineering, or a closely related data platform roleDemonstrated experience working within an enterprise data warehouse environment at scale, including ownership of data models, transformation pipelines, and data quality processesExperience implementing data governance requirements — such as retention, deletion, or PII controls — within a production data platformStrong expertise in SQL and data modeling, including dimensional modeling, star/snowflake schemas, and modern data transformation approachesDemonstrated experience designing, building, and maintaining data pipelines and transformation layers within cloud data warehouse platforms (e.g., Databricks, Snowflake, BigQuery, or equivalent)Experience with Databricks-specific features, including Unity Catalog, Delta Live Tables, or Databricks workflowsExperience designing and maintaining a semantic layer or metrics layer that serves multiple downstream consumers, including BI tools, analysts, and AI systemsDemonstrated thought leadership in data platform engineering, with a track record of innovating and contributing to the advancement of analytics engineering practices within or beyond the organizationProven ability to contribute to long-term platform planning and influence organizational data strategies through technical expertise and cross-functional engagementDemonstrated experience implementing automated data quality frameworks, including pipeline-embedded tests, validation logic, and monitoring/alerting for production datasetsUnderstanding of data governance concepts and experience translating governance requirements - including data retention, PII handling, and access controls - into technical implementations within data platformsProficiency in Python for data engineering and analytics workloads; familiarity with orchestration tools (e.g., Apache Airflow, dbt Cloud, or Databricks AI/BI)Experience designing and implementing data products and reusable data assets for self-service analytic consumptionStrong documentation practices, with the ability to create and maintain clear, accurate data dictionaries, lineage records, and model descriptionsStrong interpersonal and communication skills, with the ability to collaborate effectively with analysts, researchers, data scientists, and governance stakeholders of varying technical backgroundsStrong collaboration and influencing skills, with the ability to build trusted relationships with stakeholders across technical and non-technical functions and drive outcomes without formal authorityProficiency in collaboration and version control tools (GitHub, Git)The ideal candidate will possess:Advanced training and experience in Tableau for semantic layer integration and BI dashboard developmentFamiliarity with data catalog and metadata management tools (e.g., Alation, Atlan, or similar)Experience working with Agile frameworks for cross-functional, product-minded collaborationExperience in the higher education, nonprofit, or mission-driven technology sectorRelevant data engineering or cloud platform certifications (e.g., Databricks Certified Data Engineer, dbt Certified Developer, or equivalent)PAY RANGE$106,080 - $119,340 BenefitsCommon App is a virtual first environment. We value our employees' time and efforts. Our commitment to your success is enhanced by our competitive salary and an extensive benefits package including:Work-Life balanceVirtual-first officePaid Time Off (PTO)Seven company-wide holidaysNine floating holidays*Sick leaveMonthly mental health dayfloating holidays prorated depending on start dateVirtual-first supportChoice of PC of MAC laptopMay choose an external monitor, keyboard, mouse, and/or headsetOne-time office set-up stipendMonthly remote work stipendMonthly mobile stipendFinancial securityMarket-based salariesPerformance-based bonus403(b) retirement plan5% company contributionadditional 5% company match3-year vesting scheduleParticipation may begin immediatelyHealth & wellnessChoice of two health insurance plansHealth Savings Account, depending on health plan selectionMedical Flexible Savings Account, depending on health plan selectionVision insuranceDental insuranceInsurance coverage begins on the date of hireDependent Care Flexible Spending AccountMaven virtual clinic for women's and family healthCompany provided life and ad&d insuranceOpportunity to purchase additional life insurance for self, spouse, and dependentsCompany provided short and long-term disability insuranceCareer developmentBudgeted annual funds for professional developmentGrowth opportunities within the companyAdditional perksMutual of Omaha Employee Assistance ProgramMutual of Omaha will preparation servicesMutual of Omaha travel assistancePayroll dedication pet insurance through PinPaws1Password family accountWe work to maintain the best possible environment for our staff, where people can learn and grow. We strive to provide a diverse, collaborative, team-oriented, creative environment where each person feels encouraged to contribute to our processes, decisions, planning, and culture.How Do i ApplyTo apply for this opportunity, send your resume and cover letter with salary expectations.PROTECTING YOUR PERSONAL INFORMATION:During the recruiting process, please note that Common App will never:Provide a job offer without an interviewAsk for payment to process documents, purchase equipment or for any other reasonRequest banking or credit card informationDirect you to third-party services to obtain visas or other documentationAs we work alongside you through our recruitment process, please remain alert and never provide financial information or payment to anyone claiming to offer a job opportunity.If you believe you're a victim of a job scam, report it to the Federal Trade Commission (FTC) or your state attorney general. To learn more about job scams, read the FBI's public service announcement or visit the FTC site.