Data Engineer

RECRUITERS DO NOT CONTACT

Charlie's Produce - Who We Are

Charlie's Produce is a privately owned wholesale produce company. We are the largest privately owned produce wholesaler on the West Coast, with distribution centers in Seattle, Spokane, Portland, Anchorage, Boise, and Los Angeles. The secret to our 40 years of success in this industry is PEOPLE! We strive to hire the best and we reward them with a working environment that fosters loyalty, stability, innovation, and growth.

Charlie's provides a healthy employee stock ownership program, competitive Medical/Dental/Vision and Life Insurance plans. And our newest benefit offers Pre-Paid Fully Funded College Tuition to our employees and the dependent children of our employees after 1 year!

What we offer:

An amazing company culture!
• Medical/Dental/Vision on the first of the month following hire.
• ESOP (Profit Sharing) and 401(k).
• Paid vacations, paid holidays.
• Pre-tax commuter benefits, and onsite parking.
• Coverage under State Sick Leave.
• 100% Prepaid College Tuition for employees and their dependents.
• Employee assistance program (EAP).

Additional Compensation Details:

• $85K to $115K Dependent on Experience
• Potential 90-day performance-based raise
• Yearly review with possibility of increase based on performance and tenure

The Role

The Data Engineer is an expert who has both broad and deep knowledge of Enterprise design, Data modeling and Data Warehouse applications. The candidate will provide technical leadership of all data associated with the software applications within Charlie's Produce, including but not limited to upgrading and providing roadmap of any new systems to support the improve business operations model.

Essential Responsibilities Include but Not Limited To

• Responsible for designing, developing, documenting data models, data dictionaries, pipelines and dashboards for an analytical platform. In addition, will you be using the latest technologies for building BI and Data Warehouse solutions that will be used downstream by customers, business leaders and analysts
• Open to reverse engineer existing reporting and databases to accomplish desired business data
• Design, promote and deliver highly scalable, reliable, and performant pipelines to integrate large volumes of complex data, reduce costs and improve information flows
• Develop and implement long-term strategic road maps and phased plans that mature the data architecture over several years and that support both current and future state business processes
• Create short-term tactical solutions to achieve long-term objectives and migrate data from sub-optimized legacy systems to new solutions. Identify and develop opportunities for data reuse, migration, or retirement
• Oversee the mapping of data sources, data movement, interfaces, and analytics--with the goal of ensuring data quality, improving delivery, and reducing costs
• Create strategies and plans for data security, backup, disaster recovery, business continuity, and archiving
• Assess and determine governance, stewardship, and frameworks for managing data across the organization
• Remain conversant with emerging data technologies and strategies
• Work on issues/tickets reported by business teams
• Debugging, troubleshooting and finding the root causes
• Administer, support and test systems
• Work with Business teams on requirements, documentation, user acceptance testing
• Work with Software vendors for execution, documentation, creating test scripts and working with business users for user testing prior to production implementation.
• Support application integrations, multitasking and change management
• Be in constant communication with upper management regarding system glitches and changes
• Responding to requests and providing effective customer service using clear communication skills
• Experience in business negotiations, building partnerships and project management
• Experience in team building and a problem solver
• Must possess planning and project implementation skills
• Open to ideas and collaborate with team members
• Be flexible and adopt to the business culture while staying customer focus

Desired Minimum Qualifications:

• Bachelor's degree or equivalent experience required.
• AS400(RPG-IV) experienced REQUIRED
• 5+ years of experience of data architecture, business intelligence and/or consulting services, implementation, customer facing, vendor management.
• 5+ years of experience in project management.
• 2+ years of experience with Database Architecture, Database Design including Data Quality and Master Data Management (MDM) tools, processes, and governance.
• 2+ years of experience leading analysis, architecture, design, and development of data warehouse and business intelligence solutions.
• 2+ years of experience in product development and or consulting delivery engagements.
• 2+ years of experience designing highly scalable ETL processes with complex data transformations, data formats including error handling and monitoring, etc.
• Conceptual knowledge of applications and IT infrastructure.
• Familiar with the concepts, principles and practices of software applications, data bases, BI, Data warehouse platform.
• Knowledgeable and understanding of scripting and programming languages.
• Ability to travel as needed, approximately 5%.
• Knowledge of design, build and supports data base, data analytics, application integration and meeting customer expectations.
• Experience on AWS, Azure, Snowflake, Tableau with data architecture, design, analytics, ERP.
• Strong MS-SQL Server 2017 / 2019 experience with hands-on database design and Transact-SQL, SSIS / SSRS / SSAS development, testing, performance tuning, etc.
• Expertise in SQL and experience with programming languages (Python, Java, C#, Power Shell is highly desirable)

RECRUITERS DO NOT CONTACT

Supplemental Information

This employer participates in E-Verify and will provide the Social Security Administration and if necessary, the Department of Homeland Security with information from each new employee's Form I-9 to confirm work authorization.

Please note that the pay range provided is a good faith estimate for the position at the time of posting. Actual compensation will be dependent on factors, including but not limited to, the individual's qualifications, experience, knowledge, skills, and abilities as well as physical work location within the state.

For additional protected privacy information please visit: Privacy Policy | Charlie's Produce (charliesproduce.com)

Charlie's Produce is an Equal Opportunity Employer

Visit our Employment Page for more details or to view our privacy center: https://www.charliesproduce.com/careers/