We are looking for someone who applies practical knowledge of development and engineering to conceive, design, develop, test, and implement data extracts, transformation, migration, and uploads. This will be done using modern software development paradigms (e.g., agile, product, cloud). The right candidate must have experience with food & beverage supply chain technology, with deep skills in SQL development in Windows and RHEL (Red Hat Enterprise Linux) environments. The ideal candidate will also have report/dashboarding development experience using MicroStrategy Cloud Environment.
Primary Responsibilities:
Is responsible for creating data mappings, extracts, transformations, data migration, and uploads.
Configures supply chain technology for business use.
Owns SQL and script programming, validation, testing, and debugging of applications after data loads.
Gathers reporting requirements, designs reports, and develops reports for business use.
Creates stories in JIRA backlogs and participates in agile ceremonies.
Reviews and writes code that meets set quality gates.
Creates/updates documentation for reproducible data loading and configuration.
Interacts and coordinates work with other technical and testing groups in the organization.
Coordinates team members in finding root-cause of problems and issue resolution.
Recommends improvements to processes, technology, and interfaces that improve the effectiveness of the team.
Basic Qualifications (Required):
Bachelor's degree in computer science or similar field or related work experience.
5+ years of progressively related experience in data extracts, analysis, and reporting.
Significant knowledge/experience in relevant technologies, such as:
Experience with food & beverage supply chain technology.
Deep skills in SQL development using Oracle DB, MS SQL, Snowflake on Windows and RHEL (Red Hat Enterprise Linux) environments.
Report/dashboarding development experience using MicroStrategy Cloud Environment.
Agile Tools (Jira).
Soft Skills & Other Requirements:
Excellent written and verbal communication skills.
Detail-oriented, self-organized, delivers quality, and capable of tracking multiple pieces of work simultaneously.
Ability to handle virtual teams and work with resources in multiple sites (onsite, offshore, near shore).
Excellent time management skills.
Preferred Qualifications:
Knowledge of report writing against Snowflake and Oracle and MS SQL Server DBs.
Experience with Blue Yonder's Forecasting and Replenishment technology and Crunchtime including associated interface/data structures.
Required Education:
Bachelor's in Computer Science or similar.
Benefits:
401(k).
Dental Insurance.
Health insurance.
Vision insurance.
We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people.
The salary will be determined based on several factors including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.
Additional Responsibilities:
Participate in OrangePeople monthly team meetings, and participate in team-building efforts.
Contribute to OrangePeople technical discussions, peer reviews, etc.
Contribute content and collaborate via the OP-Wiki/Knowledge Base.
Provide status reports to OP Account Management as requested.
About us:
OrangePeople is an Enterprise Architecture and Project Management solutions company. Our most valuable asset is our people: dynamic, creative thinkers, who are passionate about doing quality work. As a member of the OrangePeople team, you will have access to industry-leading consulting practices, strategies & and technologies, innovative training & and education. An ideal Orange Person is a technology leader with a proven track record of technical achievements and a strong process/methodology orientation.