Business Intelligence Developer - Full-time

Summary

The Business Intelligence Developer makes order out of chaos, compiling data from all available sources, then distills it into just what senior leaders require for decision-support.

Job Purpose

The Business Intelligence Developer will leverage our enterprise SQL Server platform to meet current and future needs of our business. This position will work with various business units and technical teams to design, develop, and implement SSAS cubes, SSRS reports, ETL processes, data warehouse solutions, and dashboard visualization technology to deliver end user reports and dashboards.

Job Responsibilities

Design and implement SQL Server 2008 R2 (or newer) Analysis Services cubes.

Create, develop, test relational and dimensional data warehouse and marts using SQL Server 2008 R2 (or newer).

Create, develop, test ETL framework and solutions utilizing SQL Server 2008 R2 (or newer) Integration Services.

Work with business users and Analysts to design and develop data requirements.

Implement repeatable testing processes to ensure data quality and performance.

Job Requirements

BS in Business, Computer Science, or equivalent job-related experience required.

2 + years of relevant experience as a BI Developer.

Subject matter familiarity with corporate business units, e.g., Finance, Payroll, Sales, HR.

Experience with enterprise source systems, e.g., accounting, payroll, employee, workforce management, order

management (preferred).

Thorough understanding of systems and network considerations to design and implement an effective BI infrastructure. Excellent presentation and written and oral communication skills.

Outstanding interpersonal skills.

E/R modeling experience using tools such as ERWin, PowerDesigner, ERStudio.

Strong skills and experience working with SQL Server 2008 (or newer).

C# skills, especially with SQL CLR and SSIS custom components, preferred.

SQL Server 2008 (or newer).

Experience designing and implementing relational and dimensional data warehouses and marts.

Experience with dashboard visualization tools (Dundas preferred).

Experience with near real time ETL, using features such as CDC, Service Broker, ESB solutions, preferred.

Experience and ability to work within software development lifecycle (SDLC) processes.

ETL design and development experience using tools such as SQL Server Integration Services (SSIS).

Multidimensional database design and development experience using tools such as SQL Server Analysis Services (SSAS).

Working knowledge of MDX.

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.

Job Purpose

The Business Intelligence Developer will leverage our enterprise SQL Server platform to meet current and future needs of our business. This position will work with various business units and technical teams to design, develop, and implement SSAS cubes, SSRS reports, ETL processes, data warehouse solutions, and dashboard visualization technology to deliver end user reports and dashboards.

Job Responsibilities

Design and implement SQL Server 2008 R2 (or newer) Analysis Services cubes Create, develop, test relational and dimensional data warehouse and marts using SQL Server 2008 R2 (or newer) Create, develop, test ETL framework and solutions utilizing SQL Server 2008 R2 (or newer) Integration Services Work with business users and Analysts to design and develop data requirements Work with the infrastructure team to design, implement, and scale the BI systems architecture Develop application and report solutions Implement repeatable testing processes to ensure data quality and performance.

Job Requirements

Education

BS in Business, Computer Science, or equivalent job-related experience required.

Experience

2 plus years of relevant experience as a BI Developer Ability to work with business stakeholders and users to understand data needs Subject matter familiarity with corporate business units, e.g., Finance, Payroll, Sales, HR Experience with enterprise source systems, e.g., accounting, payroll, employee, workforce management, order management (preferred) Knowledge in the consumer packaged goods (CPG) and retail industry preferred.

Skills & Competencies

Understanding systems and network considerations to architect and implement a BI infrastructure environment.

Possess a basic understanding of the process to architect a data model to ensure adherence to the appropriate relationships.

Advance skills in analytical design of formulas to be programmed or configured to meet business needs.

Strong organizational skills.

Very strong written and oral communication skills.

Outstanding interpersonal skills.

Strong work ethic, self-motivated Excellent presentation skills.

Ability to work independently, but also successful team building skills.

Tools/Software

E/R modeling experience using tools such as ERWin, PowerDesigner, ERStudio Strong skills and experience working with SQL Server 2008 (or newer) SharePoint, Excel, PowerPivot BI solutions implementation preferred C# skills, especially with SQL CLR and SSIS custom components, preferred SQL Server 2008 (or newer)

Experience designing and implementing relational and dimensional data warehouses and marts.

Experience with dashboard visualization tools (Dundas preferred)

Experience with near real time ETL, using features such as CDC, Service Broker, ESB solutions, preferred.

Experience and ability to work within software development lifecycle (SDLC) processes ETL design and development experience using tools such as SQL Server Integration Services (SSIS) Multidimensional database design and development experience using tools such as SQL Server Analysis Services (SSAS) Working knowledge of MDX.

Other Requirements

Strong understanding and utilization of proper safety techniques and correct use of equipment when appropriate.

Executes verbal and written business communications, in a manner that effectively achieves business objectives, reflects the Company’s commitment to integrity, and is in keeping with company policies.

Travel Requirements

Travel up to 25%

Schedule Requirements

Ability to be flexible and willing to work extended hours when necessary Required to be on call the following days/hours:

24/7 for any failures of the CRM system.

Need to respond to “Pager Duty” notices and provide required support to bring systems on line.

Physical Demands

Never (0% of time): Work in high volume large format retail, grocery or other type retail store(s), crawl and/or climb, work in cramped/awkward positions, kneel, push/pull more than ten pounds, work in unprotected heights, operate mechanical machinery, use hand tools/equipment, be exposed to marked changes in temperature and humidity, work in freezer/coolers, be exposed to harmful fumes and/or other pollutants, use feet and/or legs for repetitive motion, use fingers, hands and/or arms for firm grasping, and lift and/or carry more than 20 pounds.

Occasionally (up to 33% of time): Stand, walk, bend and/or stoop, push/pull up to ten pounds (sedentary), and lift and/or carry up to 20 pounds (sedentary to light).

Continuously (66-100% of time): Work in an office, sit, and use fingers, hands and/or arms for fine manipulation (typing – keyboards/handhelds), finger/hand grip/grasping and repetitive motion.


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.

Disclaimer

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.