• Maintain and update master data records to ensure accuracy, completeness, and consistency • Review, clean, and normalize data from a variety of sources - including distributor feeds, manufacturer files, and internal systems - to ensure uniform formatting and structure • Recognize and correct data discrepancies or pattern inconsistencies to prevent errors from entering the company’s master database • Standardize incoming data for end-user reporting and business analysis • Map distributor product data to manufacturer products based on product history, manufacturer knowledge, and external resources (e.g., catalogs, websites) • Maintain an average of 1250 products mapped weekly (range of 1000-1500) • Verify and update product attributes - including brand, category, and manufacturer information—based on available and validated data sources • Conduct routine data audits and contribute to continuous improvement efforts for data accuracy, automation, and process efficiency • Support the development and enforcement of data governance standards and best practices • Collaborate with cross-functional teams to enhance data quality, streamline workflows, and document data management procedures • Participate in database cleaning and normalization projects as assigned • Assist in testing and providing feedback on evolving data management tools and automation technologies. • Assist in new team member training such as, but not limited to, mapping and cleansing data • Maintain Annual objectives and/or projects • Maintain business objectives

Role Description We're looking for a SQL Data Analyst to craft insightful and compelling data stories, empower business stakeholders to make more effective data-driven decisions, and help build a self-service data platform. You'll solve complex data challenges alongside a collaborative team, helping transform data into actionable insights that drive business growth and operational improvements. Key Responsibilities - Independently gather requirements for, prioritize, deliver, maintain, and continuously improve reusable data models, dashboards, analyses, A/B tests, and other data assets. - Act as the product manager and implementer for your domain's data offerings using advanced SQL and BI tools. - Become the subject matter expert for data within your business areas. - Identify opportunities for impact, proactively surface insights, support decision-making, and influence business strategy. - Serve as a trusted partner to business stakeholders while supporting other business areas as needed. - Create and maintain comprehensive data documentation, communicate updates to stakeholders, write user stories for data engineering, validate data mapping, conduct QA, and implement data quality monitoring. - Monitor the usage of data assets, increase data literacy, and promote self-service through BI tools by providing training, guidance, and ongoing support. - Work within a centralized data team using agile methodologies. - Collaborate with peer analysts through shared initiatives, shifting priorities, and code reviews to broaden your business and technical knowledge. - Partner with data architects, engineers, scientists, and analysts to help shape the vision and roadmap for the organization's data platform. - Define and track annual OKRs to measure your impact. Qualifications - 7+ years of experience as a Data Analyst supporting business stakeholders and collaborating with data engineers (experience in the energy or construction industry is a plus, but not required). - Bachelor's degree in a quantitative field is preferred; an advanced degree is a plus. - Advanced proficiency in SQL and BI tools (experience with Databricks and Sigma is a plus, but not required). - Strong track record of independently solving complex problems. - Passion for using data to drive business decisions and support sustainability initiatives. - Excellent communication skills with the ability to present ideas and insights to stakeholders across the organization. - Proven initiative in improving processes, products, or services, with a strong sense of ownership and accountability. - Strong analytical skills with the ability to identify root causes and recommend creative, data-driven solutions. - Ability to build strong relationships with internal and external stakeholders. - Eagerness to understand business operations and apply that knowledge to support strategic decision-making.

• Build and configure dashboards and visualizations in Omni (or Looker-compatible tools) • Write and optimize SQL queries to support reporting needs • Work within the semantic layer of Omni/Looker to configure visualization logic • Read and understand DBT models to support accurate dashboard work • Collaborate with the internal analytics team on standards and deliverables • Familiarity with DBT (Nice to have) • Python experience (Nice to have) • Financial services or data-heavy industry background (Nice to have)

• Gather, analyze, and document business and technical requirements for the Optimizely Data Platform implementation • Review and validate customer data architecture, schemas, and platform configuration • Analyze customer profiles, identity resolution rules, and behavioral tracking to ensure data accuracy • Translate marketing initiatives into detailed technical and functional requirements • Develop process maps illustrating customer data flow between CRM, eCommerce platforms, marketing systems, and ODP • Create and maintain functional specifications, data dictionaries, event tracking documentation, and process documentation • Design customer segmentation strategies to support lifecycle marketing and personalized customer experiences • Define KPI frameworks and reporting requirements to measure campaign performance and business outcomes • Collaborate with marketing, engineering, product, and data teams throughout project delivery • Identify implementation risks, validate technical assumptions, and recommend improvements based on industry best practices