Senior Data Modeler

To get the best candidate experience, please consider applying for a maximum of 3 roles within 12 months to ensure you are not duplicating efforts.

Job Category

Job Details

About Salesforce

We’re Salesforce, the Customer Company, inspiring the future of business with AI+ Data +CRM. Leading with our core values, we help companies across every industry blaze new trails and connect with customers in a whole new way. And, we empower you to be a Trailblazer, too — driving your performance and career growth, charting new paths, and improving the state of the world. If you believe in business as the greatest platform for change and in companies doing well and doing good – you’ve come to the right place.

Database Engineer

Office Hybrid - San Francisco, CA, Seattle, WA or New York, NY

We are seeking a seasoned and dedicated Senior Data Modeler to take ownership of and deliver the data foundation, model, and schema for Salesforce Marketing. Selected candidate will be responsible for developing conceptual, logical, and physical data models. This role involves close collaboration with Salesforce engineering, product management, data science, data visualization, and analyst teams to design both the customer data model within Salesforce Data Cloud and the analytical data model that shapes our metrics strategy.

The right candidate will have a passion for data design and the consistent use of data across products/teams. They will drive consensus and consistency across multiple teams when they need similar data model concepts. Must work very well with others and have superb communication, influencing and negotiation skills.  In this role, the selected candidate should have the ability to think creatively and be able to address and resolve challenges collaboratively, knowing when to compromise and when not to. Success will be measured by the individual’s ability to consistently deliver well-architected and documented data models at a steady pace. 

Responsibilities

• Take ownership of the entire data modeling process and associated work for both analytical and customer data models.
• Collaborate with Product Management teams to comprehend and assess functional and technical requirements.
• Conduct data discovery and analysis of source systems to pinpoint the vital data sources aligned with business needs.
• Develop conceptual and logical data models to validate requirements, identifying crucial entities and relationships.
• Collaborate closely with engineering teams to design and implement physical data models, including source-to-target mapping documentation and transformation/business rules.
• Provide ongoing support to engineering teams during pipeline creation and the implementation of new data models.
• Ensure data governance across all Marketing data platforms and architecture by collaborating with cross-functional teams.
• Cultivate data innovation for internal use cases, challenging conventional thinking about customer data models for segmentation and personalization.
• Generate and sustain comprehensive documentation for data models and source system analysis.
• Pursue continuous improvement in existing processes, methods, and tools to improve overall efficiency and effectiveness.

Minimum Qualifications:

• A related technical degree required
• 10+ years of proven, hands-on analytical data modeling and design experience for OLTP and analytical systems.
• Possess a solid understanding of data modeling principles and standard methodologies, including expertise in canonical and semantic data modeling concepts.
• Proven experience in data analysis and data profiling using SQL and other tools.
• Significant experience in data warehousing, data lakes, data pipelines, batch and real-time data transformation (ETL/ELT) and processing.
• Direct experience and proficiency with at least one modeling software (e.g. ER Studio, ERwin).
• Ability to generate thorough and understandable documentation artifacts, including data lineage and data glossaries.
• Familiarity with marketing analytics, business intelligence, and visualization tools (e.g., Google Analytics, Tableau) is beneficial.
• Ability to quickly grasp technological and business concepts
• Possess strong verbal and written communication skills, with a track record of optimally conveying technical and functional concepts to engineers, software professionals, and product management.
• Thrive in a fast-paced environment with short release cycles and an iterative development methodology.
• Capable of handling multiple projects/products simultaneously and comfortable working with minimal specifications.

​Preferred Qualifications:

• Experience with CRM, Sales and Marke