Advantage Sales & Marketing LLC dba Advantage Solutions

Sr BI Developer

US-CA-El Segundo
Position Type
Full Time
Requisition ID
2016-62582
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:

  • Lead – Responsible for leading BI development projects. Strong project management and leadership abilities required
  • 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 Sales and Marketing, LLC (ASM) 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. ASM 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 ASM 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. ASM 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.  ASM 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.

 

Any estimate, schedule, or guideline provided to associates in this job description or elsewhere in connection with their jobs is only intended to help describe job duties and for planning purposes.  Regardless of any such estimate, schedule, or guideline, associates must always record all time worked for our company (which includes but is not limited to on-site work time in an assigned store, office, or other work location; required waiting time; administrative time; and work-related travel time).

 

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 Sales & Marketing LLC. 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 Sales & Marketing LLC 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, ASM 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.