Subject Matter Expert – Data Engineering

Role Overview

• Lead and provide expert support for data collection, data validation, data visualization, and analytics initiatives
• Apply disciplined methodologies for the planning, analysis, design, and development of information systems on an enterprise-wide basis or across a business sector
• Develop analytical techniques and methodologies to solve complex business and technical problems
• Perform strategic systems planning, business information planning, and business analysis
• Organize and analyze large volumes of structured and unstructured data sets using data analytical tools
• Locate, access, merge, clean, and standardize data from multiple sources, and develop derived metrics
• Create and implement data collection and analysis tools using programming languages such as Python, Databricks, SQL, Scala, R, and Java
• Design, script, debug, and analyze data engineering solutions
• Implement and create machine learning-based tools and processes
• Apply distributed and parallel processing technologies (e.g., Spark) to handle big data analytics tasks involving large data volumes
• Perform SQL Server data imports from CSV and TXT files
• Leverage Excel and Google Suite for data analysis, reporting, and collaboration
• Utilize supporting tools and platforms such as Pentaho (data import/transformation), Azure Data Studio, GitHub, and Smartsheet as needed
• Document task requirements, work completed, processes, and technical details thoroughly
• Communicate effectively with stakeholders across technical and business teams
• Operate independently as a subject matter expert in a fast-paced, entrepreneurial environment

Requirements

• Bachelor’s or master’s degree in computer science, Computer Science, Data Science, Engineering, or a related field.
• Minimum of seven (7) years experience, of which at least three (3) years must be specialized.
• Knowledge in organizing and analyzing large amounts of structured and unstructured data sets using data analytical tools, to include experience locating, accessing, merging, cleaning, and standardizing data, and developing derived metrics.
• Strong proficiency in creating and implementing data collection and analysis tools while utilizing programming languages and environments, including Python, Databricks, SQL, Scala, R, and Java.
• Knowledge of design, scripting, debugging, and analysis.
• Experience in the implementation and creation of machine learning-based tools or processes.
• Knowledge in distributed & parallel processing (e.g., Spark) and the computational power required to handle most big data analytics tasks that can process large volumes of data.

Tech Stack

• Azure
• Java
• Python
• Scala
• Spark
• SQL

Benefits

• B&A is proud to offer three robust individual and family medical plans to full time employees, including a Health Savings Account (HSA) option as well as two tiers of dental coverage, vision, life & AD&D, disability, accident, hospital indemnity, and critical illness insurance.
• In addition to these benefits, B&A employees enjoy paid time off, B&A sponsored trainings and certifications, pet insurance benefits, commuter transit benefits and a free subscription to a virtual exercise platform (NEOU).
• A formal mentorship program
• Job shadowing and cross training opportunities
• Employee Assistance Program (EAP)
• Access to various support resources to include counseling, legal guidance, financial planning, and more.
• Monthly teambuilding events
• B&A Annual Wellness Challenges: #StepWithB&A, #WalkDuringLunchWithB&A, #VolunteeringWithB&A, #ExerciseDuringLunchWithB&A, and more