BI Data & Reporting Developer I

Dick's Sporting Goods; McAlisters Crossroads (PA); On-site; USD 70,000 - 100,000; Full time

Job summary

DICK'S Sporting Goods in Pennsylvania is seeking a BI Data & Reporting Developer I to support last mile analytics within the supply chain. The role involves data analysis, report development, automation, dashboarding for self-service, and production support for the Supply Chain ecosystem.

You will learn from senior team members, assist with data solutions, and become a data expert across the organization. Tools include Cognos, SQL, Databricks, Google Cloud Platform, and Power BI.

Qualifications

• Bachelor's degree in MIS or Applied Data Analytics.
• 1–3 years experience.
• Experience creating visualizations and self-service tools based on available data; querying Oracle/DB2 with Cognos/SQL.

Responsibilities

• Develop data analytics and reporting solutions for last mile in the supply chain.
• Create and maintain dashboards and self-service analytics for stakeholders.
• Provide production support and data insights for distribution and logistics teams.
• Document reports, data sources, and data transformations in Confluence.
• Collaborate with business partners to communicate data validation issues and needs.

Skills

Data analysis

Visualization design

SQL querying

Stakeholder communication

Education

Bachelor's degree in MIS or Applied Data Analytics

Tools

Cognos

SQL

Databricks

Google Cloud Platform

Power BI

Oracle

DB2

Job description

At DICK'S Sporting Goods, we believe in how positively sports can change lives. On our team, everyone plays a critical role in creating confidence and excitement by personally equipping all athletes to achieve their dreams. We are committed to creating an inclusive and diverse workforce, reflecting the communities we serve.

OVERVIEW

The BI Data & Reporting Developer I role will be a position in the supply chain domain with responsibilities of last mile solutions of data analytics; data analysis, report development/automation, dashboarding for self-service, and production support for the Supply Chain Ecosystem. This teammate will learn from senior members of the team and assist with data solutions. Additionally, they will strive to become one of the data experts for all areas of the Dick's Supply Chain Ecosystem, aid senior Reporting Developers, and support other project goals.

Role Responsibilities

Data & Analytics Solutions

Utilizes modern tools and platforms (e.g. Cognos, SQL, Data Modules, Databricks, Google Cloud Platform, and PowerBI) and supply chain data sources (Warehouse Management, Labor Management, Parcel Logistics, Ecomm Order Management) to transform raw data into business insights.

Learns DKS operational processes for data analytics and aids in the development of complex data solutions. Assists in creating meaningful data modules/models and looks for opportunities to leverage and influence self-service dashboarding.

Becomes knowledgeable in the Supply Chain Ecosystem domains and makes actionable recommendations based on stakeholder needs and roadblocks.

Creation and maintenance of documentation (Confluence) to track reports, report use cases, data sources, and any manipulation of data in the reporting.

Production Support

Attend meetings and provide insights to one of the supported supply chain teams about production data and integrations.

Learn and support legacy processes that exist to support current production systems.

Assist in modernization efforts by being a subject matter expert in one of the production team integrations to drive future products and reduce risks.

Create and manage alerting for the Warehouse management system to drive efficiencies in the Distribution Centers.

Relationship Building

Independently builds strong relationships with business partners to understand the business needs and data and analytic challenges.

Partners with key internal business partners, external business partners, and tech partners to communicate data validation issues.

Training and Development

Partner with business and tech stakeholders to gain an in-depth knowledge of operational and systemic processes.

Learns and applies both business knowledge and new modern data techniques.

Willing to explore new business intelligence tools (Explorations, Generative AI, Google Looker) to support modernization efforts within the Data and Analytics organization.

Educates and leads sessions with end users (supply chain and other organizations) to demonstrate how to effectively utilize last mile solutions.

Other Tasks

Interprets business requirements to create Jira tasks, identify appropriate data sources, and chooses the best approach for final mile solution.

Manages Jira tickets by creating definitive tasks that will lead to value based on the business requirements without scope creep.

Manages ADHOC reporting requests to meet data visibility and insights for all available Supply Chain Data. Leverages Cognos, Excel files, and SQL to answer Supply Chain data needs from Distribution Center and Corporate teammates.

QUALIFICATIONS

• Bachelor's Degree BS in Management Information Systems, BS in Applied Data Analytics
• 1-3 years experience
• Recommending and creating visualizations and self-service tools based on available data. Query information directly from Oracle and DB2 databases using IBM Cognos and SQL

VIRTUAL REQUIREMENTS

At DICK'S, we thrive on innovation and authenticity. That said, to protect the integrity and security of our hiring process, we ask that candidates do not use AI tools (like ChatGPT or others) during interviews or assessments.

To ensure a smooth and secure experience, please note the following:

• Cameras must be on during all virtual interviews.
• AI tools are not permitted to be used by the candidate during any part of the interview process.
• Offers are contingent upon a satisfactory background check which may include ID verification.

If you have any questions or need accommodations, we're here to help. Thanks for helping us keep the process fair and secure for everyone!