Advantage Sales & Marketing LLC dba Advantage Solutions

  • Sr BI Engineer

    Job Locations US-TX-Dallas
    Primary Posting Location : City
    Dallas
    Primary Posting Location : State/Province
    TX
    Primary Posting Location : Country
    US
    Requisition ID
    2018-173270
    Position Type
    Full Time
    Category
    Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)
  • Summary

    Sr BI Engineer

     

    We love data - and are passionate about providing our clients and business insights into data easily and reliably. We are looking for a talented and motivated Business Intelligence Engineer to join our team as an important contributor in delivering BI solutions and growing our overall delivery platform.

     

    You will be part of an agile, fast paced, collaborative team responsible for pulling in and making sense of data in multiple retailer, manufacturer, syndicated, and internal system sources, and delivering database, ETL, reporting and analytical products that are key to winning business, delighting clients, defining and implementing product strategy, and improving business processes.

    Key qualities:

    • A curious, analytical mind that can quickly ramp up on new domains and problem sets by asking insightful questions, understand what clients are trying to achieve, and drilling into and profiling data sources
    • A track record of successfully delivering value to companies through business intelligence solutions
    • A history of being a key contributor on agile teams where their processes and practices helped, not hurt, providing continuous business value
    • A desire to share and learn together with a team

    Things you will do:

    • Define - Influence and contribute to client and business projects as a member of an agile team that speaks to clients and internal customers, analyzes and clarifies what they are trying to achieve, and provides thought partnership in driving to a solution
    • Build - Design and develop all areas of a business intelligence solution, including databases, ETL, reports, cubes, and dashboards, primarily using the Microsoft BI stack
    • Architect - Contribute to growing our platform's capabilities, some examples being reducing data latency in our ETL architecture and approaches, building intelligent process that can make decisions and send pertinent and actionable notifications, expanding ad hoc query and visualization capabilities
    • Improve - Work with the team to pragmatically and continually reduce the gap between getting things done fast and getting things done right. This includes aligning with the team on development practices, sharing approaches, code reviews, automating development, testing, integration and deployment tasks
    • Support - Answer data questions, consult on tools, suggest approaches, triage and troubleshoot issues

    Technical chops:

    • T-SQL
    • SSIS
    • SSRS
    • SSAS, MDX, DAX
    • Modeling normalized and dimensional data marts/warehouses with ER tools such as ERwin, ER/Studio, PowerDesigner
    • BI solutions in SharePoint
    • Visualization tools such as PowerView, QlikView, Dundas
    • C#/.NET
    • Using TFS as a source control and ALM tool

    Advantage Solutions is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. Advantage Solutions services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today. 

     

    Advantage Sales and Marketing, LLC dba Advantage Solutions is proud to be an Equal Opportunity Employer.

     

    Responsibilities

    Advantage Solutions is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. Advantage Solutions services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today. 

     

    Position Summary

     

    This position designs and develops business intelligence, ETL and database solutions that support Advantage Sales and Marketing business units (Sales, Marketing, HR, etc) and clients.  The key duties include managing stakeholders, gathering requirements, design solutions, write and review code.  Works with many technologies and serves as the subject matter expert on select technologies or platforms. Collaborates as a member of the technical team and IT implementer for business stakeholders.  Executes on database, ETL, cube, reporting and BI application projects and owns the platform subsystems/components.

     

    Essential Job Duties and Responsibilities

    • Define - Influence and contribute to client and business projects as a member of an agile team that speaks to clients and internal customers, analyzes and clarifies what they are trying to achieve, and provides thought partnership in driving to a solution.
    • Build - Design and develop all areas of a business intelligence solution, including databases, ETL, reports, cubes, and dashboards, primarily using the Microsoft BI stack.
    • Architect - Contribute to growing our platform's capabilities, some examples being reducing data latency in our ETL architecture and approaches, building intelligent process that can make decisions and  send pertinent and actionable notifications, expanding ad hoc query and visualization capabilities
    • Improve - Work with the team to pragmatically and continually reduce the gap between getting things done fast and getting things done right. This includes aligning with the team on development practices, sharing approaches, code reviews, automating development, testing, integration and deployment tasks
    • Support - Answer data questions, consult on tools, suggest approaches, triage and troubleshoot issues

    Supervisory Responsibilities

     

    Direct Reports

    This position does not have supervisory responsibilities for direct reports

     

    Indirect Reports

    This position does not have guidance or mentoring responsibilities for indirect reports

     

    Travel and/or Driving Requirements:

     

    Travel and Driving are not essential duties or functions of this job 

     

    Minimum Qualifications

     

    Education Level: (Required): Bachelor's Degree or equivalent experience

    • 5+ years of experience in SQL Server, SSIS, SSRS
    • 3-5 years of experience working in a software development environment supporting BI solutions

    Skills, Knowledge and Abilities

    • T-SQL
    • SSIS
    • SSRS
    • SSAS, MDX, DAX
    • Modeling normalized and dimensional data marts/warehouses with ER tools such as ERwin, ER/Studio, PowerDesigner
    • BI solutions in SharePoint
    • Visualization tools such as PowerView, QlikView, Dundas
    • C#/.NET
    • Using TFS as a source control and ALM tool
    • Should have strong analytical and quantitative analysis skills
    • Familiarity with tools, concepts & methodology of business analysis
    • Sound coordination and follow up skills
    • Ability to meet deadlines under pressure
    • Be a strong team player
    • Ability to share knowledge and expertise with other software engineers
    • Proficient with agile development methodologies / Scrum
    • Strong written and oral communication skills

    Environmental & Physical Requirements

     

    Office / Sedentary Requirements

     

    Incumbent must be able to perform the essential functions of the job.  Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.  A detailed Environmental and Physical Requirements document is available in the Total Rewards department. 

     

    Additional Information Regarding Advantage Solutions Job Duties and Job Descriptions

     

    Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. Advantage Solutions reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law.  Advantage Solutions shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

     

    Important Information

    The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.

                                        

    Are you passionate about Service Excellence, Results, Integrity, Entrepreneurial Focus and Leadership: These are our values at Advantage Solutions. Come learn why “Winning Together” is more than just words on a piece of paper. It is the vision by which we live our mission as an organization: "To create outstanding value for clients and customers through superior sales execution, operational excellence and innovative marketing services."

     

    Advantage Solutions is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, Advantage Solutions shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law

     

    Apply/Share

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

    CONNECT TO YOUR CAREER

    Not ready to apply? Connect with us for general consideration.