Business Intelligence Analyst / Bi Analyst

Job Title: Business Intelligence Analyst

Location: Remote

Duration: 6 Months

Job Type: Contract

Work Type: Remote

Pay Rate: 40$/hr

Note: Only hiring #W2 candidates for this role.

:

• As a Senior Business Intelligence Analyst on our team, you will leverage your understanding of data and analytics to gather requirements, develop, test, and deploy solutions that provide visibility, save time, and continually improve upon our collective processes in Merchandising. Specifically, this role will focus primarily on supporting the functional areas of Inventory Management, Forecasting & Replenishment, Order Management, and Product Disposition.
• The Merchandise Operations (MerchOps) Business Intelligence (BI) team is responsible for supporting the objectives of the Merchandising organization with effective data and analytical solutions.
• You will work directly with MerchOps BI leadership to understand the prioritization of requests that span from projects, enhancements, ad-hoc requests, documentation, and system testing.
• Similarly, the team works very closely with various IT teams to grasp an understanding of key merchandising and BI applications that ensure team members can become functional subject matter experts, acting as liaisons between the business and technology.
• In addition, you will be part of a team who focuses on the training and expansion of skillsets like GCP, Python, and Power BI as the needs of the team evolve.
• With merchandise being at the heart of most everything we do, the team regularly collaborates with cross-functional partners across the enterprise (e.g., Finance, Supply Chain, Marketing, Store Operations) to ensure solutions and their dependencies are being addressed holistically.
• Current state you will be exposed to various technologies: HANA, Oracle, and SQL Server databases on the backend; and Tableau and WEBI as front-end tools.

CORE JOB RESPONSIBILITIES:

• Act as a liaison between business teams and IT to identify any gaps in infrastructure based on business requirements gathered.
• Deliver accurate and on time solutions to stakeholders to do their jobs throughout the year.
• Support ad-hoc and non-project-based requests.
• Support the testing of enterprise system changes and implementations.
• Develop efficient data models and SQL queries to support front end reporting and visualization solutions.
• Create and update process documentation and/or playbooks to support the maintenance of solutions.
• Deliver informative solutions that drive improvements to key Merchandising metrics and streamline and automate processes to eliminate the need for ad-hoc reporting.
• Educate stakeholders on best practices and industry standards as part of the MerchOps BI team’s strategy.

REQUIREMENTS FOR CONSIDERATION:

• Expertise using MS Excel (Power Query, INDEX/MATCH, VLOOKUP, Macros)
• Strong critical thinking, detail oriented, and logical approach to solving problems
• Experience using remainder MS Office suite (Word, PowerPoint, Outlook)
• Ability to conform to shifting priorities and timelines under a high-pressure environment
• 4+ years of experience building front end reporting or visualization solutions
• 4+ years of experience working with SQL and database concepts
• Self-motivated to learn and produce solutions independently when necessary
• 4+ years of experience building data models or data preparation workflows
• Strong interpersonal skills, both in-person and written

PREFERRED REQUIREMENTS:

• Bachelor’s degree in related discipline preferred.
• Experience with programming languages (e.g., JAVA, Python, R, VBA)
• Knowledge of Merchandising, Planning, Inventory, and Supply Chain operations
• Experience with Tableau Desktop, Server, and Prep Flows
• Experience with SAP HANA Studio and SAP Business Objects tools
• Experience with Oracle, SQL Server, and GCP
• Experience with Power BI