Senior Engineer, IT

Role Description

Lead moderately complex projects from technical design through completion. Duties include:

• Act as an on-call SME resource to manage admin failure and messaging events.
• Test and execute pre-defined ETL processes on standard data sets.
• Assist the research, troubleshooting, and resolution of data issues impacting extract delivery.
• Understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results.
• Perform data validation, unit testing and troubleshooting for data model usability.
• Support data architecture development and optimize data pipelines to store, integrate and process high-volume data sets.
• Perform code reviews for others in project.
• Collaborate with Data Scientists to ensure architectural and project specification needs are being met.
• Conduct necessary data transformations to populate data into a warehouse table structure that is optimized for reporting.
• Isolate and define core reusable data assets that support the long-term business strategy for development efforts.
• Review data analysis and data mapping logic.
• Identify recurring causes for defects and work proactively to resolve issues.
• Review fixes with MDM/Data Governance teams.
• Identify methods for collecting data and perform data analyses.
• Communicate analytical findings, including through reports, briefings, presentations, and data visualization.

Telecommuting permitted. Position requires 10% domestic travel.

Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering, Electrical Engineering, Electronics Engineering or related field.
• 72 months of experience in the job offered or in a related occupation.

Requirements

• Python
• Azure Cloud Platform services for data processing such as Databricks or Data Factory
• CICD pipelines built on Azure DevOps
• Building Integration with SAP systems such as BODS or HANA
• SAP HANA data objects and underlying data models
• Data architectures involving Delta Lake, Lakehouse, data warehouse, and ODS
• Data modeling tools such as ER or Studio Data Architect
• PySpark and SQL for data processing, analysis and data engineering
• Kafka
• ETL Development using SSIS, Informatica
• Linux shell scripting and Powershell
• Master Data Management and Data Governance
• Data Visualization and Reporting

Benefits

• Medical, dental, vision, and disability insurance plans
• 401(k) retirement savings plan
• PTO (including paid sick time)
• 8 paid holidays per year (for salaried and hourly team members)