Data Engineer REMOTE

SummaryPosition SummaryThe Lead Engineer Software- BI is responsible for architecting, designing, and developing business intelligence, ETL, and database solutions that support Company business units (Sales, Marketing, HR, etc.) and clients. This position serves as the project lead for small to mid-sized projects and primary point of contact for client stakeholders. This role manages stakeholders, gather requirements, design solutions, write and review code. The incumbent works with many technologies and serves as the subject matter expert on select technologies or platforms. This position engages directly with the business stakeholder and is the bridge between the business and the technical team. This role also guides the development of business intelligence and database projects and owns small to mid-sized system.ResponsibilitiesThe 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 ResponsibilitiesJob DutySoftware 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 ResponsibilitiesDirect 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 jobEducation Level: (Required): Bachelor's Degree or equivalent experienceField of Study/Area of Experience: 5+ years of experience in SQL Server, SSIS, SSRS, or equivalent technologiesField 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 InformationThe 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-IrvinePrimary Posting Location : City IrvinePrimary Posting Location : State/Province CAPrimary Posting Location : Postal Code 92602Primary Posting Location : Country USRequisition ID 2023-427313Position Type Full TimeCategory Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)Minimum USD $130,000.00/Yr.Maximum USD $140,000.00/Yr.