Data Engineer II

POSITION SUMMARY: 

Data Engineers provide data services to stakeholders within portfolios and throughout the enterprise by building and managing data resources to support reporting, business intelligence, analytics, data science projects and operational applications. They engage with data-centric product managers and developers, technology teams, analysts, and business partners to understand capability requirements and define and construct data structures and solutions based on priorities.

The Data Engineer II performs the design, development, and operational tasks required to provide accurate, timely, high quality data critical to feed data products (i.e., reports, analyses and data science models) and support downstream applications. The Data Engineer II will be knowledgeable of available business data resources and how to craft robust, practical data solutions.

This role is within the Information and Digital Services organization at Les Schwab headquarters in Bend, OR.

Applicants must be currently authorized to work in the United States on a full-time basis. This position is not eligible for visa sponsorship.

PRIMARY RESPONSIBILITIES:

35% - Operational Support

• Build and deliver ad hoc data sets to support business analysis, data analysis, analytics, proofs-of-concept, and other use cases

• Create complex SQL scripts and queries in support of reporting and analytics applications

• Use appropriate technologies and methods to automate data preparation and data movement with Les Schwab standard data stores, tools, and platforms

• Monitor and troubleshoot manual and automated data preparation and data movement processes

• Solve technical problems, develop workarounds and resolve operational issues

• Create and maintain operational procedures and related documentation

25% - Data Structure and Solution Design

• Collaborate with business systems analysts, data analysts, business stakeholders, and analytics practitioners to understand data product and downstream system data requirements

• Collaborate with data stewards and data source managers to understand data definitions and business rules relevant to data structure design

• Perform detailed design of data structures from inception through production support

• Create data models for relational and dimensional database schemas for a range of use cases from targeted reporting solutions to support of downstream applications

• Conduct information modeling, including conceptual models, relational database designs and message models

• Design and implement data manipulation, preparation, and data movement processes for a variety of scenarios from simple file-based export/import to enterprise-grade ETL workflows connecting multiple structured and unstructured endpoints

20% - Data Structure and Solution Development

• Catalog existing data sources and enable access to resident and external data sources

• Develop programming, modelling and data integration, supporting task automation.

• Create physical database tables, views, and flat files for analytics research projects, reporting, analytics applications, and for publication to downstream subscribers

• Solve technical problems in developing data models, data structures and ETL solutions

• Create and maintain data dictionaries, data model diagrams, data mapping documents, data security and quality requirements and related data platform documentation

• Work in an agile team environment to deliver timely analytics solutions and insights within a dynamic learning organization

15% - Data Platform Quality and Governance

• Follow a quality assurance framework to ensure the delivery of high quality data and data structure analyses to stakeholders

• Collaborate with Digital Services colleagues to use best practices within a culture of data management excellence

• Use development best practices, version control and deployment strategies to ensure product quality, agility and recoverability

• Implement and test data access roles and permissions to ensure “least privileged” access to enterprise data and reduce the enterprise risk of data exposure

• Maintain and continuously improve data work flows and query performance

5% - Stakeholder Relationship and Vendor Management

• Support Data Stewards to establish and enforce guidelines for data collection, integration and maintenance

• Collaborate with Information and Digital Services colleagues to understand and utilize Enterprise Data Platform Services and Data resources

Educational/Experience Requirements: 

• Bachelor’s degree (BS or BA) in STEM related discipline with major in Computer Science/Information Management/Database Development and Analysis or equivalent disciplines or equivalent experience with appropriate time-in-role

• 4+ years of experience with data warehouse technical architectures, ETL/ELT, reporting/analytic tools and scripting

• Experience with AWS services including S3, Data-pipeline and cloud based data warehouses

• Experience with data visualization tools such as Tableau or Birst is a plus

Required Technical Skills/Knowledge: 

• Advanced data modelling skills 

• Proficient in the composition of Advanced SQL (analytical functions)

• Proficient in query performance tuning

• Proficient in Data Analysis techniques for testing and troubleshooting

• Proficient in ETL process development

• Proficiency in writing and maintaining data management documentation such as data dictionaries, data catalogues, and integration data maps

• Awareness of stakeholder processes for reporting, and data analysis techniques for business decision-making 

• Proficiency and demonstrated experience with a programming language such as Python, R, JavaScript, Java, Go, or similar. Advanced procedure or function development in T-SQL, Oracle PL/SQL or equivalent also acceptable

• Proficiency and demonstrated professional experience working with Snowflake, Kafka, Ngrok, Docker, Streamlit, and Kinesis Data Streams.

• Proficiency and demonstrated professional experience working with flat file data formats including delimited files, XML, and JSON

• Practical experience using solution delivery collaboration software such as Service Now, Jira, TFS, or similar

General Knowledge and Abilities: 

• Analytical Skills: Strong analytical, conceptual and problem-solving abilities

• Communication: Ability to communicate technical and non-technical information clearly and professionally (both verbally and in writing) while ensuring that the quality and content of the message are relevant to the circumstances; ability to be an active-listener; the ability to draft, proofread, and send written communications effectively; the ability and willingness to carefully listen to others by asking appropriate questions and avoiding interruptions

• Confidentiality: Ability to work confidently, effectively and with discretion with all staff levels

• Flexibility: Willingness to work in an ever-changing environment with the ability to positively adapt to organizational, process, and technology changes

• Initiative: Ability to work effectively independently with proven ability to execute high complexity and diversity of work assignments

• Multitasking: The ability to perform two or more tasks simultaneously or to shift back and forth between two or more activities or sources of information without difficulty

• Organization: Ability to manage work assignments through prioritization, paying attention to detail, and optimal time management

• Service Excellence: Exhibit the willingness to be stakeholder-focused by anticipating and understanding stakeholders' needs; collaborate with them to reach a suitable solution; then consistently meet and deliver on those expectations

• Teamwork: The ability to establish and maintain rapport, interact comfortably, and work well with coworkers. This includes cooperating, being supportive of others, willingly helping others, considering others’ ideas and opinions, sharing information, giving proper credit, and fulfilling team responsibilities

Physical Requirements: Primarily desk position; regularly required to sit, occasionally required to stand and walk. Requires frequent and repetitive use of hands and fingers to operate a computer, mouse, keyboard, and office related equipment and the ability to reach with hands and arms. Position requires lifting no more than 10 pounds on a regular basis. Specific vision abilities required by this job include close visual acuity and the ability to adjust focus. Requires the ability to communicate verbally and exchange information over the phone and in person.

Work Environment: Office, non-manual work; the worker is not substantially exposed to adverse environmental conditions. Working on-call is required for this position, including but not limited to: evenings, weekends, and holidays.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions/primary responsibilities. This job description is not all inclusive and is subject to change. Additional duties and tasks may be assigned, as necessary. Employment remains “AT WILL” at all times.