A position at White Cap isn’t your ordinary job. You’ll work in an exciting and diverse environment, meet interesting people, and have a variety of career opportunities.
The White Cap family is committed to Building Trust on Every Job. We do this by being deeply knowledgeable, fully capable, and always dependable, and our associates are the driving force behind this commitment.
Job Summary
Responsible for defining data models to improve reporting and analytics consistency and insure accurate tracking/measurement across reporting platforms. Act as liaison between technical teams and business stakeholders to facilitate, conceptualize and define systems solutions; ensuring solutions align properly with data architecture.
Major Tasks, Responsibilities, and Key Accountabilities
- Participates in solution design and development by actively validating data solutions and validating new reports for correct data sourcing and accuracy.
- Develops data definitions; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
- Provides analyses, design, training, maintenance, tuning, documentation, and implementation of enterprise class logical data models and physical database objects.
- Ensures the quality, completeness, security, privacy, and integrity of data throughout the data lifecycle.
- Maintains analytic/reporting performance by identifying and resolving production and application development problems.
- Provides domain expertise, technical direction and risk assessment in support of development projects.
- Works with clients, business analysts, technical staff, and project team members to plan, design, develop, implement, and enhance applications, scripts, procedures, and metadata for relational databases.
- Builds collaborative relationships with development and IT teams.
Nature and Scope
- Identifies key barriers/core problems and applies problem solving skills in order to deal creatively with complex situations. Troubleshoots and resolves complex problems. Makes decisions under conditions of uncertainty, sometimes with incomplete information, that produce effective end results.
- Independently performs assignments with instruction limited to the expected results. Determines and develops an approach to solutions. Receives technical guidance only on unusual or complex problems or issues.
- May oversee the completion of projects and assignments, including planning, assigning, monitoring and reviewing progress and accuracy of work, evaluating results, etc. Contributes to employees' professional development but does not have hiring or firing authority.
Work Environment
- Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
- Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.
- Typically requires overnight travel less than 10% of the time.
Education and Experience
- Typically requires BS/BA in a related discipline. Generally 5-8 years of experience in a related field OR MS/MA and generally 3-5 years of experience in a related field. Certification is required in some areas.
Preferred Qualifications
- Collaborate with cross-functional teams to query large-scale data repositories like Databricks and establish links from data to Power BI dashboards and automated reports by working with analysis tools such as T-SQL and PL-SQL.
- Experience producing visualizations in Power BI for stakeholder audiences that support decision-making and highlight trends
- Responsible for assessing data quality and consistency in data warehouse.
- Produce technical documentation associated with datasets and query algorithms.
- Working knowledge of data security and sensitivity
- Experience with Oracle EBS R12 or similar ERP with Sales and Inventory Management modules is a plus
- Intermediate to Advanced proficiency in Microsoft Excel (includes advanced formulas, pivots, and conditional formatting)
- Background in data modeling
- Experience with advanced analytical tools for automation
- Strong written and verbal communication skills
This position may be remote, or hybrid based on location. Eligible candidates residing in the greater Atlanta area will be asked to work two days a week in our Doraville, GA Field Support Center.
If you’re looking to play a role in building America, consider one of our open opportunities. We can’t wait to meet you.
Similar Jobs
%20copy.jpg)
What We Do
White Cap and its affiliates serve as a one-stop shop, providing concrete accessories and chemicals, tools and equipment, building materials and fasteners, erosion and waterproofing products, and safety products to professional contractors by meeting their distinct and customized supply needs in non-residential, infrastructure, and residential end markets. White Cap operates approximately 500 branches across North America with more than 10,500 employees supporting approximately 200,000 customers.
For more information about White Cap, visit about.whitecap.com
