BI DeveloperDuration: 6 months contract to hireLocation: Hybrid - Lyndhurst, NJPosition Purpose:This position is responsible for all stages of the business intelligence cycle: understanding business objectives, gathering business requirements, and translating them into data requirements, gathering required data, designing, and developing reports or dashboards (code and visualization) using SAP business objects, scheduling, and deployment of business intelligence components in accordance with supplied standards and best practices. Writing complex queries, packages, stored procedures, functions, views or triggers in Oracle PL/SQL and MS SQL Server. Collaborate with business to understand system data and its use, data analysis and unit testing, and provides support around the data and how it is integrated.
Create new integrations using Boomi and tables to connect multiple sources into BI system. Mentors and assists business to develop a deep understanding of the data, its use, and the structure of reports and dashboards.Position Outcomes/Deliverables:Develop and maintain existing reports integrityDesign and develop business intelligence & data management applications and systemsPerform BO administration to manage licenses, control access, production deploymentsExecute cross-functional design of processes/systems based on collected requirementsCreate technical documents as intermediate output in development processDevelop technical deliverables with quality standardsResponsible for providing timely support so that business continuity can be maintainedEssential Duties and Responsibilities:Perform requirement gathering with business end-usersCreate and maintain technical documentation that includes design, requirements, testing and user manualsIdentify the development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitabilityKeep stakeholders up to date by providing communications on occasional basis throughout projects and continuous improvement effortsCreate cutover and contingency plans, provide communication about deployments, validate successful deploymentsMonitor BI group email distribution for any user issues and respond as issues ariseUnderstand current business application processes, usage, and operationsDevelop code and documentation to guide users for right usage of systemAttend project & team meetings and assist team members to resolve issues quicklyProvide on call support on a rotational basis, attend to user production issues with utmost urgencyEngage other team members as needed to resolve production issuesUnderstand the work being performed as per organizational roadmapFollow team standards for coding, testing and deployments; perform code reviews as neededEducation/Skills and Experience:Experience Required or Preferred:Minimum 3-5 years progressively improved business experience that includes software development process using PL/SQL (Must), MS SQLShould able to create oracle packages, stored procedures, functions, etc.Optimization of queries and its performance.Develop BI universe and reports in SAP Business ObjectsSetup and manage report publications, BO server administrations and reporting code migration.Keep track of scheduled jobs to make sure reports are generated in timely manner and data is accurateDevelop new integrations with BoomiUnderstanding of VBA development for Excel.Understanding of how WEB APIs and Web Hooks.Previous retail/supply chain system experience is requiredExperience with managing tasks using JIRA.Skills Required or Preferred:Strong written, verbal, and interpersonal communication skills requiredAbility to function independently, self-motivated and responsibleAbility to multi-task, understand "linkages" in processes and document or flow chart business processes requiredStrong analytical, conceptual, problem-solving and critical thinking skills are required