Data Engineer III
Walmart Canada
What you'll do...
Position: Data Engineer III
Job Location: 702 SW 8th Street, Bentonville, AR 72716
Duties: Problem Formulation: Identifies possible options to address the business problems within one's discipline through analytics, big data analytics, and automation. Applied Business Acumen: Supports the development of business cases and recommendations. Owns delivery of project activity and tasks assigned by others. Supports process updates and changes. Solves business issues. Data Governance: Supports the documentation of data governance processes. Supports the implementation of data governance practices. Data Strategy: Understands, articulates, and applies principles of the defined strategy to routine business problems that involve a single function. Data Transformation and Integration: Extracts 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. Data Source Identification: Supports 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. Data Modeling: Analyzes 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. Analyzes 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. Code Development and Testing: Writes 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.
Minimum education and experience required: Bachelor’s degree or the equivalent in Computer Science, Information Technology, Engineering, or related field and 2 years of experience in software engineering or related experience; OR 4 years of experience in software engineering or related experience; OR Master's degree or the equivalent in Computer Science, Information Technology, Engineering, or related field.
Skills required: Must have experience with: Designing and building ETL pipeline using Sqoop, Hive, Map Reduce and Spark on on-prem and cloud environments; Functional programming using Python and Scala for complex data transformations and in-memory computations; Implementing star and snowflake schema for the data warehouse using Erwin for Logical/Physical data modeling and Dimensional Data Modeling; Designing and developing UNIX/Linux scripts for handing complex file formats and structures; Orchestration of workflows and jobs using Airflow and Automic; Creating multiple Kafka producers and consumers for data transferring; Performing Continuous Integration and deployment (CI/CD) using tools like Git, Jenkin to run test cases and build applications with code coverage using Scala test; Analyzing data using SQL, Big Query and created reports using Tableau and superset; Gathering requirements from business and converting them to codable user and technical stories; Adhering and working with various project management framework like waterfall, scrum, and Kanban; and Monitoring the cluster performance, setting up alerts, documenting the designs, workflows and Providing production support, troubleshooting, and fixing the issues by tracking the status of running applications to perform System administrator tasks. Employer will accept any amount of experience with the required skills.
#LI-DNP #LI-DNI
Wal-Mart is an Equal Opportunity Employer.