Lead Engineer Software BI - REMOTE | Job in Irvine, CA. | Advantage Solutions | #2023-427318

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


- 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

Lead Engineer Software BI - REMOTE

Apply Now