People Matter

Tableau Developer

Pendulum Therapeutics

Pendulum Therapeutics

Software Engineering
San Francisco, CA, USA
Posted on Dec 12, 2023
Pendulum™ is on a mission to improve physical and mental health by creating a new category of products that target the microbiome. We are researching, developing, and commercializing a novel class of rationally-designed Live SynbioticsTM (probiotics + prebiotics) that have demonstrated clinical efficacy to treat conditions like metabolic syndrome, inflammation, and neurodegeneration.
Pendulum™ has created proprietary pipelines to build a unique discovery platform that identifies key, novel bacterial strains and the prebiotics that feed them.
We are a highly collaborative team of scientists, engineers, physicians, marketers, and salespeople interested in improving human health by using the latest research from diverse fields, such as microbiology, molecular biology, high-throughput genomics, distributed computing, pharmaceutical development, and nutrition. We believe strongly in an individual's transparency and strong communication to enable the most effective and efficient path to team success.
If you're interested in building a new category of products that will help improve people's lives globally and you love working in a cross-functional, collaborative, inspiring environment, please continue reading!
Position Overview
We are seeking a Tableau Developer to join our growing Data and Analytics Team. Reporting to the VP of Software, you will be part of a dynamic environment within our data delivery function, helping internal clients solve complex business problems with data and delivering on self service dashboards, analytics products, and ad-hoc training & support. We seek someone who genuinely enjoys connecting with people and developing architectures that support them through data visualization, researching and providing actionable value within our organization, and managing multiple department-facing data access and reporting environments.

Responsibilities

  • The Tableau Developer will bridge the gap between the business analytics needs of our departments and our internally managed cloud analytics platforms.
  • Architect and support our analytics platform, servicing departments through their data-driven journey and delivering measurable business value through dashboard development, ad-hoc data requests, training support in access tooling, ongoing user/content/security administration, and robust technical documentation.
  • Design and implement enterprise data architecture that includes data components needed to build and deliver business solutions to include: Data Pipelines, Real-time analytics, Cloud Computing, Streaming Data, AI & ML, APIs, and Cloud storage (i.e. Data Lake and Cloud SQL.)
  • Perform (ad-hoc) data analysis tasks such as building visualizations, identifying trends, and making recommendations to customers based on findings using Tableau and SQL
  • Work closely with Enterprise Architect & Marketing Strategist roles to translate business requirements into technical specifications, including data flows, integrations, transformations, databases, data warehouses, and Data Lakes.
  • Develop diagrams representing key data entities and their relationships.
  • Assist in the development of data structures, views, and database components in support of BI solution development.
  • Assist in defining the data architecture framework, standards, and principles, including modeling, metadata, security, and master data.
  • Ensure BI data, architecture, UI/UX designs meet the overall needs of the enterprise.
  • Guide the development, testing and implementation of Data Warehouse/Data Lake assets to support BI reports, dashboards, and BI solutions.
  • Ensure projects are executed within agile Software Development Lifecycle (SDLC.)
  • Guide the implementation of data solutions for self-service analytics.
  • Develop (or improve existing) client-facing dashboards and templates
  • Communicate with internal stakeholders - presenting through strong written and verbal communication that resonates with audiences
  • Support requirements gathering - including new data insights requests and ongoing project check-ins
  • Work with IT management in the development of 3-5-year Enterprise Data roadmap.
  • Participates in the formulation of development procedures, standards, deployment/retirement and archiving as related to the data architecture, tools and applications.
  • Support interactive Tableau training programs focused on reporting tool proficiency, data visualization best practices, and end-user data training and enablement
  • Troubleshoot and support resolution of support tickets & data issues related to dashboard functionality and data accuracy
  • Maintain multiple data delivery environments focused on best practices in user permissions, data security, and content organization

Requirements

  • Proficiency & experience with designing customer centric database models, datasets (e.g., CRM, Call Center, Marketing, Ecommerce, SAAS etc.)
  • Proficiency with data transformation & ETL tools (Stitch, FiveTran, DBT, Celigo, SSIS, Informatica)
  • Proficiency with Data Modeling experience (e.g., Relational, Dimensional, Columnar, Big Data)
  • Proficiency with complex SQL and NoSQL experience
  • Experience in advanced Data Warehouse concepts
  • 3+ years experience as BI developer (e.g. gathering requirements, developing reports/dashboards, wrangling data, developing actionable recommendations to business leaders)
  • 3+ years experience of professional experience working in data analytics; consulting experience is a plus
  • Expert with data visualization best practices, including the ability to communicate data structure or data modeling needs to support visualizations and analysis requests
  • Familiarity with cloud based BI tool administration best practices
  • Experience delivering BI training to both new and experienced users
  • Experience facilitating requirements gathering with multidisciplinary departments.
  • Ability to self-manage to requirements, anticipate needs, and perform necessary quality assurance steps to ensure high quality deliverables
  • Comfortable handling ambiguity & managing multiple assignments
  • Strong ability to communicate complex ideas effectively (verbal and written) with people at all levels of the organization, including senior management
  • Additional ‘nice-to-have’ knowledge and experience includes
  • Active portfolio on Tableau Public, Looker or PowerBI
  • Office productivity tools (e.g. Google Workspace)
  • Project management tools (e.g. Jira, Asana)
  • Tableau certification(s), such as Tableau Specialist/Data Analyst
  • SQL querying through Snowflake or experience with dbt
  • Master’s degree or equivalent in data analytics-related field

Salary & Benefits

  • $166,375 - $180,000
  • Medical, Dental, and Vision
  • Commuter Benefits
  • Life & STD Insurance
  • Company match on 401 (k)
  • Flexible Time Off (FTO)
  • Equity
Pendulum Therapeutics, Inc. is committed to creating a diverse environment and is proud to be an equal
opportunity employer. All qualified applicants will receive consideration for employment without regard to
race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics,
disability, age, or veteran status. We welcome all to apply.