Full Job 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 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.
This position was posted on DATE and we anticipate it will be open for a minimum of five days, though it may be open for a longer period. We encourage your prompt application.
In addition to the base wage listed, this position is also eligible to earn an annual bonus subject to changes in plan design and documents and in accordance with applicable law. Eligibility and the amount of the bonus varies based on overall company success, thresholds met and other terms and conditions of the Company's active bonus policy for the respective year.
At Builders FirstSource, we offer competitive, affordable benefits designed to make life better for you and the people you love. Our goal is simple - provide great plans that help you and your family to live happier, healthier and more secure lives. This role is eligible for medical, dental, vision, and disability insurance plans, 401(k) retirement savings plan, PTO (including paid sick time), and 8 paid holidays per year (for salaried and hourly team members). Details about Builders FirstSource's benefits offerings are available here www.bldrbenefits.com.