Position Summary

The Data Engineer is responsible for architecting, designing, and developing business intelligence, ETL, and database solutions that support Company business units (Sales, Marketing, Reporting Analytics, etc.) and internal and external clients. This position serves as the project/product 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 such as AWS, Tableau, PowerBI, Lambda, Amazon Glue, Mongo DB, Postgres SQL,Azure and ADF. 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.

The salary range for this role is $130,000-$140,000.

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

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.