Note: The job is a remote job and is open to candidates in USA. Builders FirstSource is America’s largest supplier of building materials, and they are seeking a Technical Lead for their Data Engineering Team. The role involves leading the SAP Data Migration efforts, overseeing technical architecture, and ensuring the delivery of high-quality data migration solutions.
Responsibilities
- Leads complex projects from end to end
- Drives analyses from technical design through completion; guides others on working in a dev ops structure/ environment
- Acts as point of escalation/ deep SME resource to manage admin failure and messaging events
- Develops complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using ETL toolsets
- Conducts complex ETL processes and troubleshooting
- Defines requirements for ETL solutions, ensure data quality and match-back to core systems transaction results
- Identifies and documents process for building data models; ensures data is clean and usable through validation, testing and troubleshooting
- Leads data architecture and pipeline development to store and process high-volume data sets
- Identifies immediate and larger scope problems through thorough code reviews
- Tests and reviews code to optimize scale, velocity, and reliability of deliverables
- Collaborates with Data Scientists to ensure architectural and project specification needs are being met
- Designs solid, robust, and extensible data warehouse system, and prepares data to support key business flows
- Defines standardization and reuse opportunities, abstractions and patterns across classes and components to streamline design and development of data integration solutions
- Determines data mapping tools and techniques, reviews, and highlights process improvement opportunities
- Devises new methods and procedures for collecting data; performs complex data analyses
- Designs and creates reporting and visualization for communicating data insights, underlying principle, and linkage of data to business outcomes; presents findings to senior stakeholders
Skills
- Bachelor's degree from an accredited college/university
- 7+ years relevant work experience
- Or an equivalent combination of education and experience
- Experience leading ETL having worked on multiple SAP data migration projects from end to end
- Demonstrated high involvement with SAP data object migration processes/tools and complex data extractions, transformations, and data loading techniques
- Experience in SAP Data Migration Toolset: SAP Data Services (BODS) including the setup and maintenance of the environment (Job Servers, Client, VMs, etc), iDoc, BAPI, LSMW, RFC, DMC including the creation and execution of the programs to perform data extraction, transformation and loading of legacy data
- Manages and resolves data conversion issues during loading, upon consulting with functional team/client
- Demonstrated experience in performance tuning pipelines and applications related to the Data Migration process, providing quick resolution to such issues
- Demonstrated experience in IT security practices in data at rest and in motion
- Maintain Technical and Functional Documentation / Standards including Field Mapping, Validations, Process Flows, Relevancy Rules, etc
- Experience in Azure data engineering toolset: Databricks, Microsoft SQL Databases (SQLMI), Azure DevOps, etc
- Experience in basic data warehousing and modeling practices and techniques
- Operating System Technologies: Windows, Linux/Unix including VMs
- Database Technologies: Microsoft SQL, S/4 Hana, Sybase, ODBC/JDBC connection management
- Programming Languages: SQL, Python
Benefits
- 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.
- 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).
Company Overview
Company H1B Sponsorship