Job Responsibilities
Design, build, and maintain scalable data pipelines using Fivetran to ingest data from Salesforce, ERP, and other business systems into Snowflake.
Own the data transformation layer between raw ingested sources and analytics-ready datasets, ensuring models are clean, tested, documented, and aligned to Finance and GTM reporting needs.
Build and maintain Tableau dashboards and reporting assets to track key financial and go-to-market metrics, including pipeline coverage, ARR/NRR, revenue retention, quota attainment, and other GTM activities.
Partner with Finance and cross-functional stakeholders to translate business questions into data models, metrics definitions, and dashboard solutions.
Validate data accuracy and reconcile financial and operational metrics across source systems (CRM, ERP, and other systems of record) and the Snowflake data warehouse.
Manage data warehouse objects in Snowflake, including schema design, virtual warehouse configuration, role-based access controls, and query optimization.
Define and enforce KPI definitions, data source documentation, and metric governance to drive consistent reporting across Finance and GTM teams.
Analyze customer, revenue, and product usage data to surface trends related to growth, churn, expansion, pricing, and performance.
Continuously improve analytics workflows, documentation standards, and self-service reporting capabilities to scale insight delivery across the organization.
Job Qualification
4–7 years of experience in analytics engineering, business intelligence, or a related data role.
Hands-on experience with Snowflake and Fivetran in a production environment.
Strong SQL skills for querying, joining, and transforming structured data across complex schemas.
Experience building and maintaining Tableau dashboards and data sources.
Familiarity with CRM data structures, particularly Salesforce objects and reporting.
Experience working cross-functionally with Finance, Ops, or GTM teams to support data and reporting needs.
Bachelor’s degree in a quantitative, technical, or business fields (e.g., Statistics, Mathematics, Economics, Computer Science, Data Science, Business Analytics). Master’s degree preferred.
Snowflake: schema design, virtual warehouse management, RBAC, query optimization, and cost monitoring.
Fivetran: connector configuration, sync scheduling, schema change handling, and MAR management.
Tableau: advanced dashboard design, calculated fields, LOD expressions, data source management, and Tableau Server/Cloud publishing.
SQL: advanced querying across Snowflake; window functions, CTEs, and performance tuning.
Salesforce: familiarity with standard and custom objects, SFDC data exports, and CRM reporting structures.
Git: version control for analytics codebases.
Python (preferred) for data analysis, automation, and supplemental data processing tasks.
Solid understanding of SaaS business metrics (ARR, NRR, churn, pipeline coverage, quota attainment) and how they flow through financial and GTM reporting.
Ability to integrate, clean, and analyze data from disparate source systems into a coherent, governed data model.
Skilled in translating complex data into clear narratives, actionable insights, and strategic recommendations for Finance and executive audiences.
Technical Skills
Analytical & Business Acumen
Skills Required
- 4-7 years of experience in analytics engineering, business intelligence, or a related data role.
- Hands-on experience with Snowflake in a production environment.
- Hands-on experience with Fivetran in a production environment.
- Strong SQL skills for advanced querying, joins, window functions, CTEs, and performance tuning.
- Experience building and maintaining Tableau dashboards and data sources, including Server/Cloud publishing and advanced calculations.
- Familiarity with Salesforce CRM data structures, standard and custom objects, and CRM reporting.
- Experience partnering with Finance, Ops, or GTM teams to support data and reporting needs.
- Bachelor's degree in a quantitative, technical, or business field (Statistics, Math, Economics, CS, Data Science, Business Analytics).
- Master's degree in a relevant field.
- Experience with Snowflake schema design, virtual warehouse management, RBAC, query optimization, and cost monitoring.
- Experience configuring Fivetran connectors, sync scheduling, schema change handling, and MAR management.
- Experience with Tableau calculated fields, LOD expressions, and advanced dashboard design.
- Experience using Git for version control of analytics codebases.
- Python for data analysis, automation, and supplemental data processing.
- Solid understanding of SaaS business metrics (ARR, NRR, churn, pipeline coverage, quota attainment).
- Ability to validate data accuracy and reconcile financial and operational metrics across CRM, ERP, and other source systems.
What We Do
Model N enables life sciences and high tech companies to drive growth and market share, minimizing revenue leakage throughout the revenue lifecycle. With deep industry expertise and solutions purpose-built for these industries, Model N delivers comprehensive visibility, insight and control over the complexities of commercial operations and compliance. Our integrated cloud solution is proven to automate pricing, incentive and contract decisions to scale business profitably and grow revenue. Model N is trusted across more than 120 countries by the world’s leading pharmaceutical, medical technology, semiconductor, and high tech companies, including Johnson & Johnson, AstraZeneca, Stryker, Seagate Technology, Broadcom and Microchip Technology. For more information, visit www.modeln.com.
