Robert Bosch Tool Corporation Lincolnton , NC 28092
Posted 3 weeks ago
Job Description
Database and server administration including, but not limited to developing data pipelines for data extraction, transformation, and integration, as well as their respective storage, in a robust and sustainable architecture. Provides technical assistance and troubleshooting support of server and database - related topics.
Primary Duties and Accountabilities
Role will be responsible for core data ETL across the organization.
Use SQL to extract custom data sets from enterprise-wide data lakes, deploy them as data cubes which can be accessed via spreadsheets, Power BI or other analytical platforms.
Effectively engage with multiple stakeholders across manufacturing, technical functions, controlling and IT teams.
Clean and transform extracted data by handling missing values and inconsistencies,
Perform data aggregation, analysis, and transformation using statistical methods and data manipulation tools.
Ensure data integrity and security.
Collaborate with database administrators and engineers to optimize data storage and access.
Actively seek standardization and automation, apply, and implement best practices across finance functions to streamline the entire analytics process.
Qualifications
Basic Qualifications:
Preferred:
Education: successfully completed Master's degree in Computer Science or other engineering discipline
Experience with recent non-relational storage technologies (NoSQL and distributed)
Experience with workflow automation tools (e.g. Jenkins, Ansible)
Experience with Nexeed MES Platform
Experience with various messaging systems (e.g. Kafka)
Experience in designing data models and choice of respective data formats
Experience with in-vehicle data collection skills, structured and analytical connectivity
Robert Bosch Tool Corporation