Modeler jobs in United States, California, San Francisco

Job Category

Job Details

to lead the design and delivery of the data foundation, models, and schemas that power theC360 Data CloudMarketing AutomationGo-To-Market Activations, and the data infrastructure supporting creation of
Responsibilities

• Take ownership of the entire data modeling process and associated deliverables 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 necessary 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 andtransformation/businessrules.

• 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.

• Foster 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 enhance overall efficiency and effectiveness.

Minimum Qualifications:

• A related technical degree required.

• 7+ years of demonstrated, hands-on analytical data modeling and design experience for OLTP and analytical systems. Experience with Salesforce platform and data objects is a huge plus.

• Possess a solid understanding of data modeling principles and best practices, including expertise in canonical and semantic data modeling concepts.

• Significant 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).

• Demonstrate the 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 etc.) is beneficial.

• Ability to quickly grasp technological and business concepts.

• Possess strong verbal and written communication skills, with a track record of effectively conveying technical and functional concepts to engineers, software professionals, and product management.

• Thrive in a fast-paced, Agile environment characterized by short release cycles, iterative development, and continuous feedback.

• Capable of handling multiple projects/products simultaneously and comfortable working with minimal specifications.

Preferred Qualifications:

• Experience with the Salesforce technology stack, particularly Salesforce Data Cloud features such as Calculated Insights, Segmentation, and Identity Resolution, to guide data modeling decisions for both real-time and batch use cases. Prior experience applying identity resolution techniques to support the creation of a golden customer record is highly desirable.

• Prior experience with CRM, Sales and Marketing data is a huge plus

• Sound grasp of enterprise architecture principles

• Understanding and acquaintance with marketing technology solutions and the Digital Marketing domain

• Advanced degree or equivalent experience in Computer Science or a related field

• Experience working with globally distributed teams is a plus

Unleash Your Potential

When you join Salesforce, you’ll be limitless in all areas of your life. Our benefits and resources support you to find balance and

If you require assistance due to a disability applying for open positions please submit a request via this.

Posting Statement

Job Category

Job Details

Responsibilities:

• Provide expert data modeling design advice and reviews for all styles of data models (OLTP and analytical).

• Collaborate with product and development teams to define data model requirements and drive consensus on unified data model designs that address overlapping requirements across multiple product teams.

• Own data model designs and representing them to both internal and external stakeholders.

• Mentor and enhance the data modeling design skills of our own team and all the teams we work with.

• Leading and contributing to data model documentation and collateral.

• Perform essential data model oversight tasks, such as ensuring that data model requests are properly documented and routed.

• Continuously seek improvements in Salesforce's processes, methods, and tooling to enhance efficiency and effectiveness. Assist in adopting AI technologies to enhance and automate data modeling activities.

• Supporting engineers through hands-on detailed design, development, testing and publishing of data models as needed.

RequiredQualifications:

• 6+ years (depending on level) of hands-on experience in data modeling and enterprise software design for relational (OLTP) and analytical systems

• Strong understanding of data modeling principles and best practices, including canonical and semantic concepts

• Ability to quickly grasp technological and business concepts

• Strong written and verbal communication skills, with experience in effectively conveying technical and functional concepts to diverse audiences

• Demonstrated experience in full software lifecycle delivery for enterprise software products or large-scale enterprise IT projects

• Ability to thrive in a fast-paced environment characterized by short release cycles and iterative development methodologies

• Comfortable in managing multiple projects/products concurrently.

• Related technical degree required

PreferredQualifications:

• Experience across a variety of business domains (e.g. sales, service, field service, marketing, commerce) and industries (e.g. communications, media, energy, utilities, financial services, health, manufacturing, consumer packaged goods, retail, non-profit, education, public sector, sustainability)

• Strong, hands-on knowledge of SQL (or Salesforce SOQL) including performance tuning

• Knowledge of modern, non-relational databases (e.g. columnar, graph, vector, NoSQL, streaming databases), data lakes, data warehouses, AI pipelines or similar. Experience with modern data stack technologies such as Apache Iceberg, Snowflake, MongoDB, Neo4j, Neptune, and similar.

• Knowledge of Salesforce product and platform features, capabilities, and the best use of them including Data Cloud and Tableau

• Experience with Agile development methodologies

• Good understanding of enterprise architecture principles

• Ability to serve as a trusted advisor to customers, with a deep curiosity to understand them, their motivations and needs, and how to approach ensuring their success

• Experience with data modeling tools, processes, BI tools, reporting software and data analysis and data analytics

Check out our
Check out our

If you require assistance due to a disability applying for open positions please submit a request via this.

Posting Statement