Senior, Data Engineer

Walmart • Bentonville, AR

11d • $90,000 - $180,000 • Onsite

About The Position

This role is for a Senior Data Engineer who will be responsible for understanding and applying data strategy principles to business problems, identifying suitable data sources, performing data quality checks, and transforming data. The engineer will create data pipelines, develop knowledge of data science trends, and translate business problems into data solutions. They will also provide recommendations to stakeholders, develop business cases, and serve as a liaison between business needs and technical solutions. Responsibilities include analyzing data elements for data modeling, developing logical and physical data models, defining data structures, evaluating existing models, and creating training documentation. Additionally, the role involves writing code for solutions, creating test cases, deploying software, documenting code, and maintaining playbooks. Data governance is a key aspect, including establishing and documenting governance projects, implementing practices, interpreting policies, and educating others. The position requires experience with advanced SQL, cloud big data development, exploratory data analysis, pipeline design and orchestration, migrating data between platforms, big data/cloud warehouse integration, developing report-ready tables, version control, Agile/Scrum methodologies, statistical data analytics, correlation analysis, model training, and translating business requirements into technical specifications.

Requirements

• Advanced SQL and cloud bigdata development to analyze and transform workforce planning datasets using joins, CTEs, window functions, partitioning/clustering, and stored procedures for scalable analytics (SQL, MS SQL Server, BigQuery, Google Cloud Storage)
• Conducting exploratory data analysis on store labor hours and scheduling (Tableau Prep, BigQuery)
• Designing/orchestrating pipelines to ingest, transform, standardize and publish datasets from multiple sources for workforce reporting (Python, SQL, BigQuery, Dataiku, Airflow)
• Migrating code and data from SQL Server to BigQuery, including ETL conversion, validation and performance optimization (Azure/MS SQL Server, SQL, BigQuery)
• Implementing bigdata/cloud warehouse integration, modeling and schema design (SQL, BigQuery, ETL/ELT pipelines)
• Developing report-ready tables/views and publish datasets for BI (Power BI, Tableau, Looker)
• Version control, code deployment, collaborative development (Git, dbt, VSCode)
• Agile/Scrum (Azure DevOps, Jira, Confluence)
• Utilizing statistical data analytics for conducting hypothesis tests to identify correlation between metrics and store traits
• Applying correlation analysis and train/evaluate regression/classification models (Python, pandas, NumPy, scikit-learn, regression, correlation, model training)
• Translating business requirements into technical specificaions
• Master’s degree or the equivalent in computer science or a related field plus 1 year of experience in software engineering or related experience OR Bachelor’s degree or the equivalent in computer science or a related field plus 3 years of experience in software engineering or related experience.

Responsibilities

• Understand, articulate, and apply principles of the defined strategy to routine business problems that involve a single function.
• Support the understanding of the priority order of requirements and service level agreements. Helps identify the most suitable source for data that is fit for purpose.
• Performs initial data quality checks on extracted data.
• Extract data from identified databases. Creates data pipelines and transform data to a structure that is relevant to the problem by selecting appropriate techniques.
• Develops knowledge of current data science and analytics trends.
• Translate/ co-own business problems within one's discipline to data related or mathematical solutions.
• Identifies appropriate methods/tools to be leveraged to provide a solution for the problem.
• Shares use cases and gives examples to demonstrate how the method would solve the business problem.
• Provide recommendations to business stakeholders to solve complex business issues.
• Develops business cases s for projects with a projected return on investment or cost savings.
• Translates business requirements into projects, activities, and tasks and aligns to overall business strategy and develops domain specific artifact.
• Serves as an interpreter and conduit to connect business needs with tangible solutions and results.
• Identify and recommend relevant business insights pertaining to their area of work.
• Analyze complex data elements, systems, data flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models.
• Develops the Logical Data Model and Physical Data Models including data warehouse and data mart designs.
• Defines relational tables, primary and foreign keys, and stored procedures to create a data model structure.
• Evaluates existing data models and physical databases for variances and discrepancies.
• Develops efficient data flows.
• Analyses data-related system integration challenges and proposes appropriate solutions.
• Creates training documentation and trains end-users on data modeling.
• Oversees the tasks of less experienced programmers and stipulates system troubleshooting supports.
• Write code to develop the required solution and application features by determining the appropriate programming language and leveraging business, technical, and data requirements.
• Creates test cases to review and validate the proposed solution design.
• Creates proofs of concept.
• Tests the code using the appropriate testing approach.
• Deploys software to production servers.
• Contributes code documentation, maintains playbooks, and provides timely progress updates.
• Establish, modify, and document data governance projects and recommendations.
• Implements data governance practices in partnership with business stakeholders and peers.
• Interprets company and regulatory policies on data.
• Educates others on data governance processes, practices, policies, and guidelines.
• Provides recommendations on needed updates or inputs into data governance policies, practices, or guidelines.

What This Job Offers

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