Senior, Data Analyst

Walmart • Bentonville, AR

10d • Onsite

About The Position

The Senior Data Analyst translates business problems into data-related or mathematical solutions, identifies appropriate methods and tools, and explains how those methods address business needs. The role provides expert guidance, develops recommendations and business cases, translates requirements into projects and tasks, and connects business needs with practical solutions. It also identifies suitable data sources, performs initial data quality checks, and creates visualizations that communicate findings to business and technical audiences.

The analyst profiles, tests, monitors, and improves data quality; manages data quality procedures and issues; supports data governance and access controls; and conducts exploratory analysis and statistical modeling. The role applies the organization's data strategy to routine business problems and mentors junior associates.

The position uses Tableau, Power BI, SQL and other data platforms and tools to create dashboards, migrate legacy reporting and databases, blend and analyze large datasets, build data pipelines and scheduled refreshes, and perform real-time analysis. The listed work includes Oracle, MySQL, Teradata, DB2, Google Cloud BigQuery, Hadoop, Hive, Python, Scala, Spark, Kafka, and PL/SQL. The position is located at 811 Excellence Dr, Bentonville, Arkansas.

Requirements

• Bachelor’s degree or equivalent in Business, Engineering, Statistics, Economics, Analytics, Information Technology, or a related field, plus 2 years of experience in data analysis, data science, or related experience; alternatively, 4 years of experience in data analysis, data science, or related experience.
• Experience with Tableau Desktop and Power BI dashboard development and publishing, connected to sources including Oracle (GRS/CKB), MySQL, Teradata, Prod 17, DB2, and Google Cloud BigQuery.
• Experience migrating Teradata databases to Google Cloud Platform and Hadoop and using Query IT and Hive to access Hadoop files.
• Experience blending data from multiple sources and developing front-end navigation for strategic, tactical, and operational dashboard portfolios.
• Experience migrating legacy reports into Tableau, developing data-warehouse reports, and managing Tableau semantic-layer reusable data sources and KPIs.
• Experience using Python to perform complex computations on large sales datasets, create BigQuery tables, and schedule refreshes.
• Experience developing Spark code with Scala, Python, and Spark SQL; tuning targets, sources, mappings, and sessions; and analyzing real-time data using Kafka and Spark Streaming.
• Experience with PL/SQL programming, stored procedures, functions, packages, SQL tuning, and database objects including tables, views, materialized views, triggers, sequences, and synonyms.
• The employer will accept any amount of experience with the listed required skills.

Responsibilities

• Translate or co-own business problems in the analyst’s discipline and formulate data-related or mathematical solutions; identify suitable methods and tools and demonstrate how they can address the problem.
• Apply current expertise to develop, execute, and improve action plans; advise others on information and best practices and support customer and business needs.
• Recommend solutions to complex business issues, develop business cases with projected return on investment or cost savings, and translate business requirements into projects, activities, and tasks aligned with business strategy.
• Connect business needs with tangible solutions, identify relevant business insights, and support implementation by partnering with stakeholders, monitoring results, and identifying improvement opportunities.
• Support prioritization of requirements and service-level agreements, identify fit-for-purpose data sources, and conduct initial data quality checks on extracted data.
• Create appropriate graphical representations of data and model outcomes, design representations for multiple datasets, and work with user experience designers and user interface engineers as needed.
• Present findings to teams and business audiences using appropriate visualization frameworks; tailor communication to stakeholders and mentor junior associates on data storytelling.
• Promote data quality awareness; profile, assess, test, validate, measure, and monitor data quality; deliver against data quality service-level agreements; and manage operational data quality procedures.
• Manage data quality issues and lead cleansing activities; determine user accessibility and remove or restrict access as needed; interpret company and regulatory policies and educate others on data governance.
• Collect and tabulate data, evaluate accuracy and applicability, support selection of statistical techniques, assist with exploratory analysis research, recommend statistical models, and conduct statistical analyses and build basic models.
• Apply defined data strategy principles to routine business problems involving a single function.
• Develop storytelling dashboards in Tableau Desktop and Power BI and publish them to servers connected to multiple data sources.
• Support migration of Teradata databases to Google Cloud Platform and Hadoop, and use Query IT and Hive to access Hadoop files.
• Blend data from multiple sources; develop front-end navigation for strategic, tactical, and operational dashboards; and migrate legacy reports into Tableau while developing new reports from a data warehouse initiative.
• Develop and manage Tableau semantic-layer reusable data sources and KPIs to help clients identify sales trends and forecast sales.
• Create and extract large sales datasets and shared files, perform complex computations using Python, create BigQuery tables, and schedule refreshes.
• Develop Spark code using Scala, Python, and Spark SQL to retrieve item- and product-related data from different sources.
• Tune the performance of targets, sources, mappings, and sessions.
• Analyze incoming data in real time using Kafka consumer APIs, Kafka topics, and Spark Streaming with Scala.
• Perform PL/SQL programming, including stored procedures, functions, packages, SQL tuning, and creation of tables, views, materialized views, triggers, sequences, and synonyms.

Benefits

• Competitive pay and performance-based incentive awards, including annual or quarterly performance incentives.
• Medical, vision, and dental coverage.
• 401(k), stock purchase plan, and company-paid life insurance.
• Paid time off, including sick leave; parental leave; family care leave; bereavement leave; jury duty leave; and voting leave.
• Short-term and long-term disability.
• Education assistance, including 100% company-paid college degrees.
• Company discounts, military service pay, and adoption expense reimbursement.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior