Senior Engineer, ITBuilders FirstSource

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 optimizes 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 works 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.

Requirements:             Employer will accept a Bachelor’s degree in Computer Science, Computer Engineering, Electrical Engineering, Electronics Engineering or related field and 72 months of experience in experience in the job offered or in a related occupation.

Position requires:

1. Python;

2. Azure Cloud Platform services for data processing such as Databricks or Data Factory;

3. CICD pipelines built on Azure DevOps;

4. Building Integration with SAP systems such as BODS or HANA;

5. SAP HANA data objects and underlying data models;

6. Data architectures involving Delta Lake, Lakehouse, data warehouse, and ODS;

7. Data modeling tools such as ER or Studio Data Architect;

8. PySpark and SQL for data processing, analysis and data engineering;

9. Kafka;

10. ETL Development using SSIS, Informatica;

11. Linux shell scripting and Powershell;

12. Master Data Management and Data Governance; and

13. Data Visualization and Reporting.