• IT Sr. Data Warehouse Engineer

    Position Type
    Full-time
    # of Openings
    1
    Category
    Information Technology
    Location : Name
    Corporate Office
    Location : City
    Idaho Falls
  • Company Profile

    "Enhancing the Lives of Those We Touch by Helping People Reach Their Goals”

     

    Melaleuca has firmly supported this mission statement since our humble beginning in 1985. Everything we accomplish is done with an eye toward promoting the physical, environmental, financial, and personal wellness of those around us. Our focus has always been on wellness. By manufacturing and selling effective, high quality, natural, health oriented products we help people live more vibrant, healthier, and happier lives. When you walk through the doors at Melaleuca, you can feel it immediately. This is The Wellness Company.

     

    We have achieved consistent and profitable growth with our annual revenue hitting over $2 billion dollars. We now have over 4,000 employees and operate in 19 countries around the world. Melaleuca is positioned to grow even more rapidly in upcoming years.

    Overview

    A Sr. Data Warehouse Engineer is responsible for designing and implementing efficient, flexible, extensible and scalable data warehouse operations and data structures to support our core business operations and analysis.

    Responsibilities

    • Support and maintain existing Enterprise Data Warehouse (EDW) Efforts
    • Engage with business units and subject matter experts to determine requirements and specifications for data structures in the EDW
    • Monitor, troubleshoot, and support data warehouse processes and systems
    • Document EDW systems, data flows and processes
    • Ensure changes conform to standards, are thoroughly tested, and will not break systems
    • Maintain familiarity and provide direction for the field’s concepts, practices, and procedures
    • Participate in technical design and code reviews
    • Can lead or mentor Data Warehouse Engineers as needed
    • Learn systems, languages, methodologies, and technologies utilized by the team
    • Establish and grow department procedures, policies, and processes
    • Function as Technical or Team Lead as needed
    • Be on call for escalation of technical incidents as needed
    • Ability to prioritize work and meet deadlines

    Qualifications

    • Bachelor’s degree in Computer Science, Business Information Systems or related field, or equivalent work experience.
    • 5+ years experience in Data Warehouse, Business Intelligence or related field
    • 5+ years experience in database solutions using TSQL and/or PL SQL
    • Ability to work and communicate well with technical and non-technical people
    • Strong problem solving skills

    Ideal Candidate

    • Seasoned experience in Kimball Data Warehousing Methodologies
    • Seasoned experience with Microsoft SQL Server, Change Data Capture (CDC)
    • Experience with SSDT Database Projects
    • Experience with SQL Server Analysis Services (SSAS)
    • Experience with SQL Server Reporting Services (SSRS)
    • Experience with Power BI (preferably on premise)

    Why Melaleuca

    Melaleuca is one of the leading Health and Wellness companies in the world. We manufacture and distribute nutritional, pharmaceutical, personal care, facial care, home hygiene, and other wellness products and distribute them directly to the consumer through a full-service catalog and Internet shopping system. We carefully craft products used every day with the highest standards of safety, health, and wellness in mind.

     

    This revolutionary system is changing the way hundreds of thousands of people shop by eliminating middlemen and reducing marketing and distribution costs. This enables the company to spend more on research and high-quality, ecologically-sensible ingredients, while maintaining reasonable prices.

     

    Great culture - flexibility is a must in this position; you'll become a part of a fast-paced team dedicated to a feel-good lifestyle brand dedicated to changing lives. Like the rest of Melaleuca, we are proud to be part of a values-driven organization that treats employees with respect. Our employees and their families enjoy company parties and countless discounts around the community. We implement a very real open-door policy, and all employees are on a first name basis—it feels more like a family than a multi-national corporation.

     

    Safe, uncrowded, affordable - nestled in the heart of beautiful Eastern Idaho, Idaho Falls is a prosperous and vibrant community, as well as the gateway to recreational paradise. This unique setting provides numerous opportunities for total wellness -- social, physical, financial, and emotional. If you love outdoor activities, this is the place for you, with the Snake River running right through town, the Rocky Mountains dominating the horizon, and Yellowstone less than a 2-hour drive away.

     

    Excellent compensation - in addition to a competitive wage, we offer comprehensive benefits for our full-time employees that include all you would expect plus some remarkable surprises, such as a longevity bonus. Right here on-site, we provide a fitness center, free concierge service, and an employee restaurant.

     

    The next step is yours. To apply today, click on the "Apply" button.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.