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

Location:

Minimal local travel will be required. This position is based in Chicago, IL and requires 2 days a week on site, 3 days a week starting in September.

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.

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 to business stakeholders.
• Strong analytical skills for translating business requirements into scalable data models.
• Proficient in developing and supporting BI/reporting platforms such as Tableau, Power BI, or Salesforce-native analytics.
• Working knowledge of data security, privacy practices, and compliance requirements.

Leadership and Communication:
• Excellent communication and interpersonal skills to collaborate with cross-functional teams and present technical concepts to business stakeholders.
• Commitment to high ethical standards and handling of sensitive/confidential data.

PREFERRED SKILLS AND QUALIFICATIONS
• Informatica Certified Practitioner or comparable certifications.
• Experience in the manufacturing or construction industry.
• Prior consulting, enterprise data strategy, or multi-cloud/SaaS implementation experience.
• Background with ERP or CRM data integrations.

Rate of pay may be adjusted based on the qualifications and experience of the candidate.

USG employees enjoy a number of benefit options for themselves and their families. These include two medical insurance options, as well as vision and dental coverage. The cost of these optional programs varies based on coverage level - employees generally pay 25% of the monthly premium cost, USG pays the rest. These coverage options are offered on the first day of employment with no waiting period.

Additionally, USG employees enjoy both a 401(k) Investment Plan with company match and a pension plan. Beyond these main features, employees may also choose from a number of additional programs like life insurance, accident insurance, legal insurance, even pet insurance, just to name a few. USG also offers Quarterly (hourly) / Annual (salary) bonus potential for all employees based on performance metrics tied to safety, quality, and productivity. USG also provides employees with paid time off and paid holidays.