Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Purpose:

Implement ETL workflows and transformations for on prem and cloud applications for the business initiatives. Deliver value to business by modelling data marts/data ware houses and providing analytics/interactive reports. This enables alignment of company objectives with the Business and Technology team efforts.

Key Responsibilities:

  • Leverage strong analytical and problem-solving skills to identify and deliver actionable insights.
  • Implement data analytics initiatives by working with the Agile team to satisfy stakeholder expectations and the needs of the organization.
  • Develop and maintain data models, relationships to enable data access, reporting, integrity and quality.
  • Manage internal stakeholder expectations and balances the needs of the company and the client to ensure satisfaction for both.
  • Apply Business Intelligence, Structures Query Language, System Analysis, Design, Development and OLTP/OLAP, Data Modeling skills to develop lean and high-performance analytics.
  • Ensure data architecture is built for performance, fault tolerance and security applying reusable patterns.
  • Partner with teams across the organization to build, establish and deliver on requests. 

Competencies:

  • Business Insight
  • Tech Savvy
  • Manages Complexity
  • Global Perspective
  • Plans and Aligns 
  • Optimizes Work 

Measures of Success:

  • Optimize queries and reporting models enhancing performance by 20%
  • Reduce manual data remediation efforts for current KPI targets by 20%
  • Visualized data sets related to consultant journeys improving consultant lifetime value by 5% 

Education and Experience:

  • Bachelor in Computer Science, CIS, or MIS
  • Expert level in Informatica or Talend and creating Tasks, Subject Areas, Execution Plans, performance tuning and configuring DAC to execute the ETL process (7+ yrs)
  • Skilled in SQL and Oracle PL/SQL (7+ yrs)
  • Extensive experience with report development (Analysis/BI Publisher), interactive Dashboards , security Setup (roles/groups, access / query/report privileges) using OBIEE/MicroStrategy. (7+ yrs)
  • Strong experience in data modelling and data optimization
  • Expert in designing and developing dashboards in MicroStrategy or similar analytics tool. (7+ yrs)
  • Skilled with modelling OLAP databases
  • Experience in S3 and AWS Redshift development and implementation is a plus
  • Strong analytical, critical thinking and problem-solving capabilities with the ability to translate data-driven insights and customer needs into business recommendations and solutions
  • Strong work ethic and “can do” attitude with a high degree of self-motivation
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • JavaLanguages
    • JavascriptLanguages
    • AngularJSFrameworks
    • ExpressFrameworks
    • Node.jsFrameworks
    • MongoDBDatabases
    • OracleDatabases

Location

We get to mix it up! PC has offices in Addison and in downtown Chicago.

What are Pampered Chef Perks + Benefits

Culture
Partners with Nonprofits
Pampered Chef hosts Help Whip Cancer fundraisers with the American Cancer Society and is a proud partner with Feeding America's Round-Up from the Heart Program raising more than $26 million since 1991
Friends outside of work
Eat lunch together
Intracompany committees
Our FUN Committee plans monthly events from game nights, happy hours, Halloween contests, and summer BBQs.
Daily sync
Open door policy
Team owned deliverables
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 12 weeks of parental leave for the primary caretaker, and 4 weeks of leave for the secondary caretaker.
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Game Room
Happy Hours
Parking
Professional Development Benefits
Lunch and learns
Pampered Chef hosts occasional Lunch and Learns for employees.
Promote from within

Additional Perks + Benefits

Each and every coworker makes a difference every day by asking tough questions, finding the answers, and then making it happen—our entrepreneurial employees are the key to our success! Pampered Chef is big enough to implement cutting-edge technology, and small enough for all ideas to be heard and challenged.
We are a learning focused environment—we want you to learn from us, and we expect to learn from you and what you’re passionate about! We even provide training and development for added brainpower.

We collaborate every day in a high-tech space with writable walls, open collaboration zones, quiet “I need to contemplate” zones, and fun zones with ping pong, basketball, and bags, of course. No boring cubicle farms here!

We are concerned about your physical and financial well-being and offer BC/BS PPO or HMO health plans, dental, disability, matched 401K, life insurance, on-site fitness center, comfy chairs, on-site cafeteria, and dry cleaning valet service.

More Jobs at Pampered Chef8 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Legal
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Pampered Chef's full profileSee more Pampered Chef jobs