Title: Salesforce Data Modeler
Location: Chicago United States
Job Description:
Position Summary:
Results-driven Salesforce Data Modeler to support our evolving Customer Experience team. Responsible for designing robust, integrated data models within Salesforce, enabling seamless platform interoperability and ensuring data is optimized for consumption by reporting and analytics tools. Responsibilities include master data management, cross-platform data integration, and understanding business requirements in digital environments. Provide exceptional support for reporting and analytics, leading to influential business decisions.
Reports To:
Director – Commercial Analytics
Key Accountabilities & Responsibilities
USG is seeking an experienced and results-driven Salesforce Data Modeler to support our evolving Customer Experience team. The successful candidate will be responsible for designing robust, integrated data models within Salesforce, enabling seamless platform interoperability and ensuring data is optimized for consumption by reporting and analytics tools. Our current ecosystem includes sales and marketing solutions operating across North America (US, Canada, and LATAM). The ideal candidate will have strong expertise in master data management, cross-platform data integration, and a keen understanding of business requirements in digital environments. This role is pivotal in supporting business decisions and enhancing USG’s reporting and analytics capabilities.
Minimal local travel will be required. This position is based in Chicago, IL.
Data Model Design:
· Design, implement, and maintain scalable and integrated Salesforce data models that support business operations and analytics.
· Develop and enhance data integration between Salesforce and external platforms to ensure data consistency and accessibility for reporting.
· Align data architecture with Master Data Management strategies and ensure data accuracy and quality across the platform.
Cross-Platform Integration:
· Lead efforts to integrate Salesforce data with other enterprise systems, supporting analytics and reporting needs across business units.
· Collaborate with IT, Sales, Service, and Marketing teams to understand cross-functional data requirements and facilitate data interoperability.
· Ensure seamless and secure data flow across platforms, optimizing for high availability and data consistency
Reporting and Analytics:
· Design data structures and models that enable efficient consumption of Salesforce data for business intelligence and analytics.
· Support development of dashboards and reports by ensuring underlying data model meets consumption focus and self-service analytics requirements.
· Facilitate self-service reporting and empower business teams with accessible, reliable, and actionable data.
Business Acumen and Digital Strategy:
· Translate complex business needs into scalable data model solutions.
· Apply a consumption-focused mindset to ensure reporting and analytics users can easily access and utilize relevant information.
· Remain current with Salesforce feature releases, industry best practices, and emerging data trends.
Documentation and Governance:
· Maintain thorough, up-to-date technical documentation (data dictionaries, ERDs, integration flows).
· Advocate for data governance practices, ensuring secure, compliant, and high-quality data management across all projects and platforms.
Goals
· Deliver resilient, integrated Salesforce data models tailored to USG’s strategic growth and analytics needs.
· Align Salesforce and enterprise data ecosystems for seamless cross-platform data sharing and analytics.
· Maximize the quality, accessibility, and utility of USG’s Salesforce data assets for business reporting, analysis, and innovation.
Requirements
Education:
·Bachelor’s degree required. Degree in Computer Science, Information Systems, or a related technical discipline preferred.
Data Management Expertise:
· Minimum of 5+ years’ experience designing, developing, deploying, managing, and governing advanced data models in an enterprise digital environment.
· Demonstrated experience with Master Data Management and enterprise data governance.
· Proficient with data modeling best practices, Salesforce Data Cloud, relational/non-relational data stores, and the implementation of effective data model solutions.
· Solid background using ETL/integration platforms (MuleSoft, Informatica, Boomi, etc.).
·Experience supporting reporting and analytics initiatives with a user-centric and consumption-focused approach.
·Proficiency with data modeling tools, ETL processes, and integration middleware.
·Working knowledge of Salesforce architecture capabilities and ecosystem, including Sales Cloud, Service Cloud, Marketing Cloud, and Data Cloud.
Technical and Analytical Skills:
· Exceptional analytical, problem-solving, and communication skills; strong partnership focus and ability to convey technical topics