BI Developer-Lindherst, NJ

BI Developer

Duration: 6 months contract to hire

Location: Hybrid - Lyndhurst, NJ

Position 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 integrity
• Design and develop business intelligence & data management applications and systems
• Perform BO administration to manage licenses, control access, production deployments
• Execute cross-functional design of processes/systems based on collected requirements
• Create technical documents as intermediate output in development process
• Develop technical deliverables with quality standards
• Responsible for providing timely support so that business continuity can be maintained

Essential Duties and Responsibilities:

• Perform requirement gathering with business end-users
• Create and maintain technical documentation that includes design, requirements, testing and user manuals
• Identify the development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability
• Keep stakeholders up to date by providing communications on occasional basis throughout projects and continuous improvement efforts
• Create cutover and contingency plans, provide communication about deployments, validate successful deployments
• Monitor BI group email distribution for any user issues and respond as issues arise
• Understand current business application processes, usage, and operations
• Develop code and documentation to guide users for right usage of system
• Attend project & team meetings and assist team members to resolve issues quickly
• Provide on call support on a rotational basis, attend to user production issues with utmost urgency
• Engage other team members as needed to resolve production issues
• Understand the work being performed as per organizational roadmap
• Follow team standards for coding, testing and deployments; perform code reviews as needed

Education/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 SQL
• Should able to create oracle packages, stored procedures, functions, etc.
• Optimization of queries and its performance.
• Develop BI universe and reports in SAP Business Objects
• Setup 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 accurate
• Develop new integrations with Boomi
• Understanding of VBA development for Excel.
• Understanding of how WEB APIs and Web Hooks.
• Previous retail/supply chain system experience is required
• Experience with managing tasks using JIRA.

Skills Required or Preferred:

• Strong written, verbal, and interpersonal communication skills required
• Ability to function independently, self-motivated and responsible
• Ability to multi-task, understand "linkages" in processes and document or flow chart business processes required
• Strong analytical, conceptual, problem-solving and critical thinking skills are required