Sr Engineer BI - Full-time

Summary

Sr Engineer BI

Sr Engineer BI 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, writing and reviewing 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.

Sr Engineer BI JobResponsibilities

• Influence and contribute to client and business projects as a member of an agile team.
• Design and develop all areas of a business intelligence solution.
• Contribute to growing our platform's capabilities.
• Work with the team to pragmatically and continually reduce the gap between getting things done fast and getting things done right.
• Answer data questions, consult on tools, suggest approaches, triage and troubleshoot
  issues.

Sr Engineer BI Education & Experience

• Bachelor's Degree preferred.
• 5+ years of experience in SQL Server, SSIS, SSRS.
• 3-5 years of experience in a software development environment supporting BI solutions.

Sr Engineer BI 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.
• Ability to share knowledge and expertise with other software engineers.
• Proficient with agile development methodologies / Scrum.
• Strong written and oral communication skills.

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

• ETL development experience using tools such as SQL Server Integration Services (SSIS)
• Multidimensional database development experience using tools such as SQL Server Analysis Services (SSAS)
• E/R modeling experience using tools such as ERWin, PowerDesigner, ERStudio
• BI solutions in SharePoint
• Visualization tools such as PowerView, QlikView, Dundas C#/.NET
• Using TFS as a source control and ALM tool
• Analytical and research Skills
• Team building Skills
• Strong written communication and verbal 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).

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.