Tebra 1 час назад
Senior Analytics Engineer
127 000 – 145 000 $в год
- United States
- Удалённо
- Опыт от 5 лет
SQLJiraDBTTableauData ModelingSnowflakeGitHub ActionsSalesforceNetSuiteAnalytics EngineeringStripeDimensional Data Modeling
Описание
Responsibilities
- Design, build, and maintain enterprise-wide business data that teams across Finance, Customer Success, Growth, and Payments build on.
- Apply dimensional modeling and layered design (staging, intermediate, and marts) so business logic lives in one place and isn't rebuilt by each team.
- Partner with metric owners in Finance and the business to define each key metric once, with a named owner and documented logic.
- Publish governed metrics in a semantic layer that Tableau, AI assistants, and other tools query, and reconcile them to current reporting and the general ledger before teams switch over.
- Build easy-to-use datasets that let non-technical teammates and analysts answer their own questions without writing complex joins.
- Lead projects end to end on the new internal analytics platform, from source data to dashboards.
- Move each team's reporting over one domain at a time, with clear cutover and rollback plans, and onboard the analysts who contribute to new conventions, review processes, and tools.
- Build automated tests and pull-request checks so data issues are caught before they reach reports.
- Monitor scheduled jobs, fix failures, and recover runs as part of shared production support.
- Tune SQL, models, and pipeline schedules so data refreshes on time and dashboards load in seconds.
- Monitor compute usage and cost, and choose how each model is built and refreshed to keep both in check.
- Partner with analysts and data scientists to prepare clean, documented datasets for forecasting and machine learning models, such as retention and revenue projections.
- Review code from analysts and engineers across teams, and coach them on modeling, SQL, and testing standards.
- Follow data-sharing and privacy rules that keep protected health information (PHI) and personal data out of internal analytics.
- Maintain model documentation, lineage, and metric definitions via dbt, GitHub, Confluence, and Jira.
Requirements
- 5+ years of experience in analytics engineering, data engineering, or a similar role, with 2+ years hands-on in dbt in production.
- Expert SQL, including window functions, CTEs, and performance tuning for queries and pipelines on large datasets.
- Deep proficiency in dimensional modeling (Kimball), including shared datasets that serve many teams.
- Proven experience with Snowflake or a similar cloud data warehouse, and with dbt.
- Experience defining business metrics with Finance or business stakeholders, and reconciling data to financial systems.
- Experience with GitHub for version control and code review, automated builds (GitHub Actions or similar), and Jira and Confluence for work tracking and documentation.
- Strong communication with people who aren't data specialists, and ability to execute under minimal supervision.
- Motivated to learn new technologies and develop new skills.
- Bachelor's degree in computer science, statistics, economics, information systems, or a related field, or equivalent practical experience.
Nice to have
- Experience with a semantic layer, such as Snowflake semantic views or the dbt Semantic Layer.
- Experience with Salesforce, NetSuite, or Stripe data, and with subscription revenue, retention, or payments metrics.
- Experience preparing data for forecasting or machine learning models.
- Healthcare or HIPAA experience.
- Familiarity with Tableau, Terraform, or Okta.
- dbt Analytics Engineering or SnowPro certifications.
We offer
- Competitive and fair compensation.
- Eligible employees have the opportunity for variable pay.
- Robust benefits package.
- Work from home basics discount through Dell.
- Resources to help keep your mind and body healthy, such as Gympass and Telus Employee Assistance Program.
Hiring process
- Tebra only initiates contact with candidates via email from an official Tebra email address (•••.com, •••.com, or •••.com) or through our applicant tracking system, Greenhouse.
- Sensitive personal information will only be asked through the official application portal, not via social media or text message.
- Interviews will not be conducted via instant messaging.
- Interviews may be recorded by Greenhouse Notetaker for consistency, bias reduction, and informed hiring decisions.