Sr. Data Engineer - Remote
St. Louis, MO 
Share
Posted 4 days ago
Job Description
Job Description

Job Summary

Design, develop (code), test, and debug applications. Provide experienced Ready-to-Serve and development subject matter expertise. Maintain, enhance, and provide solutions for software applications. Provide development leadership in a functional area, module, or project.

Major Tasks, Responsibilities and Key Accountabilities

  • Works with stakeholders to perform application functionality gap analysis and feasibility studies.
  • Leads development activities for a functional area, module, or project. Provides and documents technical design and specifications meeting business and functional requirements.
  • Develops (code), implements, and maintains tools/applications. Ensures applications and systems possess sufficient controls.
  • Performs unit testing prior to moving code/configuration to the QA process. Evaluates and researches upgrades, patches, and new functionality. Research defects and solve for root cause in applications.
  • Assists in the development and definition of test plans and scripts for performance, regression, and user acceptance test plans; support QA activities as required.
  • Builds and maintains templates, rules, style sheets, workflows, data extractions and imports, interfaces, and object models.
  • Analyzes applications for compliance with security protocols.
  • Trains team members on areas of expertise. Participate in and lead peer reviews.

Career Level Dimensions

Typical Training/Experience

  • Typically requires BS/BA in a related discipline.
  • Generally, 5-8 years of experience in a related field; certification is required in some areas OR MS/MA and generally 3-5 years of experience in a related field.

Problem Complexity

  • Identifies key barriers/core problems and applies problem solving skills to deal creatively with complex situations.
  • Troubleshoots and resolves complex problems.
  • Makes decisions under conditions of uncertainty, sometimes with incomplete information, that produce effective end results.

Autonomy

  • Independently performs assignments with instruction limited to the results expected.
  • Determines and develops an approach to solutions.
  • Receives technical guidance only on unusual or complex problems or issues.

Leadership

  • May oversee the completion of projects and assignments, including planning, assigning, monitoring, and reviewing progress and accuracy of work, evaluating results, etc.
  • Contributes to employees' professional development but does not have hiring or firing authority.

Environmental Job Requirements

  • Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
  • Typically requires overnight travel less than 10% of the time.
  • Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about.
  • On rare occasions there may be a need to move or lift light articles.

Preferred Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 5+ years of hands-on development experience in SQL and/or Python for data warehouse management, data integration, and data lake management
  • Expert proficiency in Microsoft SQL Server OLAP solutions and/or Azure Synapse Analytics, Deep working knowledge in SQL development using T-SQL code to design, implement, and optimize complex database objects, such as tables, views, stored procedures, indexes, and functions, Experience working with Azure data architecture, including a solid understanding of tools for building data pipelines on cloud-based data platforms, such as Delta Lakehouse Medallion architecture and data warehousing solutions
  • Exposure to modern Spark based data platforms like Databricks or Microsoft Fabric for data engineering tasks, including leveraging their capabilities for scalable data processing, analytics, and machine learning workflows in a cloud-based environment.
  • Understanding of ELT vs ETL and how to build efficient data pipelines with modern Change Data Capture processes.
  • Hands-on experience with CI/CD pipelines in Azure DevOps and understanding of Agile development methodologies.
  • Familiarity with common data mapping and transformation techniques for Dynamics 365 Data Entities and Data Management Framework for the Finance and Operations modules.

#LI-Remote

About Core & Main

Based in St. Louis, Core & Main is a leading distributor of water, sewer, storm drain and fire protection products in the United States. Operating approximately 320 branches nationwide, the company combines local expertise with a national supply chain to provide contractors and municipalities innovative solutions for new construction and aging infrastructure. Core & Main's 4,500 plus associates are committed to the safe distribution of water and fire protection to help communities thrive. Visit www.coreandmain.com to learn more.

Core & Main is an Equal Employment Opportunity employer. Employment at Core & Main is based solely on a person's merit and qualifications directly related to professional competence. Core & Main does not discriminate against any employee or applicant on the basis of race, creed, color, religion, national origin, nationality, ancestry, age, disability, veteran status, pregnancy or related condition (including breastfeeding), affectional or sexual orientation, gender identity or expression, marital status, status with regard to public assistance, citizenship, or any other basis protected by law.

None of the questions in this application are intended to elicit information regarding any protected characteristics, nor imply any limitation, illegal preferences or discrimination based upon non-job-related information or protected characteristics.

For more information, please click here or visit https://www.eeoc.gov


Core & Main is an Equal Employment Opportunity employer and does not discriminate in employment opportunities or practices on the basis of race, creed, color, religion, sex, national origin, nationality, ancestry, age, disability or status as a disabled veteran or veteran of the Vietnam era, pregnancy, affectional or sexual orientation, gender identity or expression, marital status, status with regard to public assistance, veteran status, citizenship or membership in any other legally protected class. None of the questions in this application are intended to elicit information regarding any protected characteristics, nor imply any limitation, illegal preferences or discrimination based upon non-job-related information or protected characteristics. Core & Main provides reasonable accommodations for qualified individuals with disabilities in the application, offer, and during employment. If you have any difficulty using our online system due to a disability and need an accommodation you may use the following email address: accommodationrequest@coreandmain.com Please specify which position you are seeking to apply for employment, and please only use this email address for inquiries regarding accommodations. For more information, please click here for a notice that provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs (OFCCP) AA/EOE.

 

Job Summary
Company
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Bachelor's Degree
Required Experience
5 to 8 years
Email this Job to Yourself or a Friend
Indicates required fields