Job Information
Advantage Solutions Lead Engineer Software BI - REMOTE in Irvine, California
Summary
The Company 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. The Company 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.
Essential Job Duties and Responsibilities
Job Duty
Software Development
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
Project Leadership
Lead efforts to gather and convert business requirements into functional designs and wireframes
Architect and develop BI solutions for complex business problems
Provide guidance to a team of BI developers, analysts and testers
Develop and enforce BI development best practices
Lead code reviews and technical exchange sessions
Manage the development and maintenance of technical documents
Escalated End User Support
Troubleshoot escalated issues with users
Identify patterns in user issues and recommend solutions that addresses root causes
Supervisory Responsibilities
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
Travel up to 5%
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: 5+ years of experience in SQL Server, SSIS, SSRS, or equivalent technologies
Field of Study/Area of Experience: 5+ years of experience in Systems Analysis and documentation
Current experience presenting technical solutions to business and technical audiences
Experience managing business clients or customers
Experience managing multiple phases of the SDLC
Skills, Knowledge and Abilities
Ability to understand a business process and translate to a data model
Ability to analyze ambiguous technical and customer situations and determine appropriate solutions as necessary
Advanced skills in analytical design of software to be developed or configured to meet business needs, including but not limited to how that translates into BI initiatives, needs, and solutions
Ability to develop sound technical documents
Ability to share knowledge and expertise with other software BI engineers
Proficient with agile development methodologies / Scrum
Strong organizational skills
Be a strong team builder
Strong work ethic, self-motivated
Advanced analytical thinking and problem-solving skills
Advanced written and oral communication skills
Microsoft Office tools skills
Tools/Software
Experience architecting systems and leading a small team
SQL Server, or similar database technologies including but not limited to Open Source PostgresSQL, etc.
Third Party BI visualization and end user tools including but not limited to Qlikview, Tableau, PowerBI, or SSRS
Working knowledge of related systems and platforms: including but not limited to .NET, Active Directory, Dynamics, application architecture, or BizTalk
ETL Development (SSIS, Talend, Etc.)
C#/.NET preferred
Microsoft Visual Studio preferred
Microsoft Team Foundation Server preferred
SharePoint preferred
Responsibilities
The Company 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. The Company 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.
Essential Job Duties and Responsibilities
Job Duty
Software Development
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
Project Leadership
Lead efforts to gather and convert business requirements into functional designs and wireframes
Architect and develop BI solutions for complex business problems
Provide guidance to a team of BI developers, analysts and testers
Develop and enforce BI development best practices
Lead code reviews and technical exchange sessions
Manage the development and maintenance of technical documents
Escalated End User Support
Troubleshoot escalated issues with users
Identify patterns in user issues and recommend solutions that addresses root causes
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
Travel up to 5%
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: 5+ years of experience in SQL Server, SSIS, SSRS, or equivalent technologies
Field of Study/Area of Experience: 5+ years of experience in Systems Analysis and documentation
Current experience presenting technical solutions to business and technical audiences
Experience managing business clients or customers
Experience managing multiple phases of the SDLC
Skills, Knowledge and Abilities
Ability to understand a business process and translate to a data model
Ability to analyze ambiguous technical and customer situations and determine appropriate solutions as necessary
Advanced skills in analytical design of software to be developed or configured to meet business needs, including but not limited to how that translates into BI initiatives, needs, and solutions
Ability to develop sound technical documents
Ability to share knowledge and expertise with other software BI engineers
Proficient with agile development methodologies / Scrum
Strong organizational skills
Be a strong team builder
Strong work ethic, self-motivated
Advanced analytical thinking and problem-solving skills
Advanced written and oral communication skills
Microsoft Office tools skills
Tools/Software
Experience architecting systems and leading a small team
SQL Server, or similar database technologies including but not limited to Open Source PostgresSQL, etc.
Third Party BI visualization and end user tools including but not limited to Qlikview, Tableau, PowerBI, or SSRS
Working knowledge of related systems and platforms: including but not limited to .NET, Active Directory, Dynamics, application architecture, or BizTalk
ETL Tooling (SSIS, Talend, Etc.)
C#/.NET preferred
Microsoft Visual Studio preferred
Microsoft Team Foundation Server preferred
SharePoint preferred
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.
The Company 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, the Company 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.
Job Locations US-CA-Irvine
Primary Posting Location : City Irvine
Primary Posting Location : State/Province CA
Primary Posting Location : Postal Code 92602
Primary Posting Location : Country US
Requisition ID 2023-427318
Position Type Full Time
Category Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)
Minimum USD $130,000.00/Yr.
Maximum USD $150,000.00/Yr.