Advantage Sales & Marketing LLC dba Advantage Solutions

BI Development Manager

US-CA-El Segundo
Position Type
Full Time
Requisition ID
2016-62797
Category
Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)

Summary

BI Development Manager

 

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:

  • Manage – Manage Business Intelligence Development team
  • 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

 

The National Technology Manager BI will have oversight over the multiple technical initiatives including business intelligence reporting, data warehousing, and data integration.   Responsible for the overall team execution of BI projects which include: writing and reviewing code, architecting solutions, project estimating, work planning, issues management, risk management and change control.

 

Essential Job Duties and Responsibilities

 

Software Development Management

  • Lead project planning and sizing activities, identify resource requirements, and oversee a team of internal and external resources capable of producing specified deliverables
  • Create and maintain an software development project plan that communicates tasks, milestone dates, status, and resource allocation
  • Identify and communicate major milestones and risks to achieving those milestones in a positive manner
  • Coordinate delivery of development (beta) and production releases that meet quality assurance standards
  • Manage software development projects around the BI platform to ensure quality, on time, within budget delivery from requirement definition through testing, rollout, and support
  • Perform work breakdown and task identification, assign tasks to project resources, track progress on assigned tasks, and manage the assembly of completed tasks into coherent deliverables

Technical Leadership

  • Architect, design, develop, test, and deploy code for business intelligence and database technology platforms
  • Plan and execute efforts to address technical debt for legacy systems and processes
  • Share acquired skills/knowledge with team members and mentor junior engineers
  • Collaborate with test team in creating a Quality Assurance strategy for supporting both new and legacy BI systems
  • Develop and enforce development best practices
  • Lead code reviews and technical exchange sessions
  • Manage the development and maintenance of technical documents
  • Manage business intelligence, data warehouse, and IT strategy projects.

    Take an internal leadership role in one or more areas to coach, mentor and review BI engineers.

  • Work with many technologies and as an IT leader for the team and business stakeholders.

End User Support

  • Create a user support structure that addresses user requests with minimal impact on ongoing project work
  • Manage user training and onboarding activities.
  • Perform technical liaison functions to all clients/customers
  •  

Supervisory Responsibilities:

 

Direct Reports

Hires, retains, trains, coaches, guides, directs, and develops direct reports using company-wide processes, tools and resources

 

Indirect Reports

May delegate work of others and provide guidance, direction and mentoring to indirect reports

 

Travel and/or Driving Requirements:

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

Minimum Qualifications

 

The following are the minimum job-related qualifications which an individual needs in order to successfully perform the essential duties and responsibilities of the job

 

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

                                   

Field of Study/Area of Experience:  computer science, engineering or related education/professional work experience

  • 6+ years of significant experience with SQL Server, SSIS, SSRS
  • 6+ years of relevant experience with Systems Analysis and documentation
  • Deep knowledge of related technologies such as SSAS, Microsoft and third party BI tools, .NET
  • Current experience presenting technical solutions to business and technical audiences
  • Experience leading software development teams through all phases of the SDLC
  • Experience managing business clients or customers
  • Advanced communication, organization, and project management skills
  • SCRUM Master and working within an Agile process a plus
  • Prior consulting experience is a big plus

Skills, Knowledge and Abilities

  • The ability to analyze ambiguous technical and customer situations and determine appropriate solutions as necessary
  • Self-starter, problem solver, resourceful
  • Demonstrated ability to provide cross-functional leadership
  • Ability to create and maintain a positive work environment by motivating and managing people
  • Experience architecting technical solutions for complex problems
  • Experience architecting systems and leading a small team in a Microsoft BI development environment:
  • SQL Server 2008 (or newer)
    • Microsoft Visual Studio
    • Microsoft Team Foundation Server
    • Microsoft Office
    • SharePoint
    • Third party BI visualization and end user tools
    • Working knowledge of related systems and platforms:.NET, Active Directory, BizTalk, Dynamics and application architecture

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.