Lead Data Engineer

We are Builders FirstSource, America's largest supplier of building materials, value-added components and building services to the professional market. You'll feel proud of the work you do here every day to transform the future of home building and help make the dream of home ownership more achievable. At BFS, we believe building a successful career is not solely defined by a degree. Your experience, skills, and passion are just as important, if not more so. As such, we are committed to creating a diverse and inclusive workplace that welcomes candidates from all backgrounds and experience levels.

Lead Engineer, IT - Data Engineering role will act as a Tech lead for supporting solution design and implementation across three product teams serving key business areas of Operations, Finance and Supply Chain. This role will participate with all three product teams following Scrum agile methodology as well as liaise with various other application teams that manage upstream/downstream systems, DBA team, Unix/Linux infrastructure team, Enterprise Architecture and release managers that oversee change management process (CAB). 

This individual will guide teams of Data Engineers, data analysts and BI reporting developers through various phases of requirements analysis, solution design, implementation, testing, code review, change approval and DevOps release process, and then support the maintenance of code once it is operational in production.

One of the key aspects of this role is to gain in depth understanding of existing on-prem architecture for existing needs and be able to transition the solutions to future cloud-based architecture as the platform evolves.

ESSENTIAL DUTIES AND 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.

SUPERVISORY RESPONSIBILITIES

This job has no supervisory responsibilities.

MINIMUM REQUIREMENTS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. 

• Expert understanding of various type of Data Architectures involving various Data Systems e.g Data Warehouse, Operational Data Store, Data Lake, Data Hub, MDM.
• Expert at data integration and ETL patterns for batch and event-based data movement involving on prem, and cloud-based technologies.
• Expert at optimization and performance tuning of various technologies for data at rest (storage, RDBMS etc) and data in motion (ETL, file transfers, API, Queueing Systems).
• Extensive experience designing and implementing data security patterns involving data masking, row-based security, role-based security using AD groups in on-prem, and cloud based eco-system.
• Expert level of understanding involving Data Models involving normalized and denormalized data.
• Extensive experience with ANSI SQL, SSIS and SQL Server development.
• Experience with cloud based ETL technologies like Databricks and data factory.
• Experience with MPP systems like Snowflake, Azure Synapse, and Redshift.
• Experience working with reporting tools like Power BI Service, MicroStrategy.
• Extensive experience playing the role of a lead and mentoring junior Data Engineers and analysts.
• Bachelor's degree from an accredited college/university.
• 7+ years relevant work experience.
• Or an equivalent combination of education and experience.

COMPETENCIES

• Evaluates Problems: Evaluates and analyzes different types of information objectively to identify appropriate solutions; writes fluently, establishing the key facts clearly and interprets numerical data effectively.
• Technical Communication/ Presentation: Communicates with clarity and precision, presenting complex information in a concise format that is audience appropriate.
• Adjusting and Driving Change: Takes a positive approach to tackling work and embraces change; invites feedback relating to performance and deals constructively with criticism. Identifies the need for and drives change when required to achieve objectives.
• Focuses on Customers: Understands and anticipates customer needs and takes action to provide high-quality products and services to exceed expectations. 
• Demonstrates Business Acumen: Demonstrates working knowledge of market, economic, legal, and regulatory environments and how they impact the business.
• Agile Best Practices: Understands how agility is leveraged in IT ways of working. Adopts agile best practices as appropriate throughout the assigned work lifecycle. Responds to feedback quickly based on comments of internal and external customers and needs of the market.
• Bias for Action: Takes initiative and identifies what needs to be done and acts without waiting to be asked. Executes work in a timely manner. Suggests improvements to current ways of working.

BFS COMPETENCIES

• Business and Financial Acumen
  • Demonstrates depth of understanding for the P&L and financial analysis
  • Teaches business and financial acumen to others.
  • Understands KPIs and how BFS makes money.
  • Knows the different business segments and how they relate to one another.
  • Understands customer sales and engagement.
  • Demonstrates functional and/or technical expertise.
  • Understands complex issues and demonstrates problem solving skills.
  • Understands how to maximize business results regardless of industry cycle.
• Results Driven
  • Holds self and others accountable.
  • Communicates and sets clear goals with plans to deliver.
  • Manages competing priorities effectively.
  • Demonstrates appropriate urgency.
  • Drives to exceed expectations in alignment with our BFS SPICE values.
  • Embraces and follows best practices.
  • Demonstrates self-starter, can-do attitude.
• Strategic Thinking and Decision Making
  • Leverages resources and teams around them to solve problems and create mutually beneficial outcomes.
  • Demonstrates willingness and courage to make tough decisions in a timely manner.
  • Balances short-and-long term priorities
  • Demonstrates proactive versus reactive thinking.
  • Asks questions to identify root cause and analyze situations more accurately.
• Servant Leadership
  • Demonstrates humility by putting others first.
  • Builds trust-based relationships.
  • Leads by example with kindness and respect.
  • Collaborates well across all areas of the business.
  • Advocates for others
  • Actively listens to understand the meaning and intent of what the other person is communicating.
  • Demonstrates authenticity and encourages others to do the same.
• Emotional Intelligence
  • Demonstrates situational awareness - knows when and how to adjust leadership style in different situations.
  • Demonstrates self-awareness - understands strengths and weaknesses.
  • Demonstrates empathy - puts themselves in other's shoes.
  • Assumes positive intent.
• Develops and Leads Others
  • Drives alignment through clear communication of vision, goals, and expectations.
  • Invests time on a regular basis in performance feedback and developmental conversations.
  • Fosters a respectful and inclusive environment.
  • Empowers, motivates, and inspires others.
  • Coaches and mentor others for their development.
  • Guides and persuades others to deliver positive outcomes.
• Growth Mindset
  • Demonstrates a growth mindset; takes appropriate risks, fails fast and forward, learns from mistakes.
  • Perseveres and champions growth, even in the face of resistance, ambiguity, or possible failure.
  • Thinks like an owner with an entrepreneurial spirit.
  • Demonstrates and encourages intellectual curiosity.
  • Continuous learner; seeks opportunities and knowledge for personal and professional growth.
  • Sees possibilities over problems - actively seeks solutions.
• Innovation
  • Encourages out-of-the box thinking to create new ways of doing things.
  • Continuously seeks to improve and simplify pain points in the business.
  • Anticipates, embraces, and leads change.
  • Develops and executes breakthrough strategies.
• Integrity
  • Does the right thing even under challenging circumstances?
  • Communicates with honesty.
  • Consistently treats others fairly and equitably.
  • Demonstrates reliability and does what they say they will do.
  • Conducts tough conversations and delivers difficult messages with kindness and respect.

WORK ENVIRONMENT / PHYSICAL ACTIVITY

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Subject to both typical office environment and outside locations with temperature and weather variations.
• Must be able to lift and carry up to 25 pounds.
• Occasional travel may be required.

Successful, innovative, and fulfilling careers are built here, and your professional development is a high priority. We invest in your future through the latest training, tools, and technologies. Highly collaborative, we work together to solve problems and find better ways to continually grow our business and careers every day. You'll be empowered to try new things, gain new experiences, and build a career with unlimited horizons. The scale and depth of resources that being the #1 building materials distributor in the nation provides a variety of opportunities for you to explore - all in a friendly, people-first environment. Join us to be more, do more, and build more, together at BFS.