TREMEC · 10 hours ago
Data Reporting Specialist
Novi, MI
Full-time
Onsite
Entry, Mid Level
2+ years expTREMEC is seeking a Data Reporting Specialist responsible for extracting, integrating, and analyzing data to support business decision-making. The role involves designing and maintaining databases and automated reporting solutions, while applying data science principles to deliver insights and improve reporting processes.
Automotive
Responsibilities
Extract, consolidate, and validate information from systems such as QlikView, SAP, ADP, and other enterprise platforms to provide accurate, consistent, and timely datasets that support business decision-making
Design, develop, and maintain relational databases and reporting structures—using SQL, Access, and data modeling techniques—to ensure data integrity, performance, and long-term scalability
Build automated dashboards, visual reports, and analytics tools that translate complex information into meaningful insights for stakeholders across all functional areas of TREMEC (Operations, GBD, Engineering, Purchasing, Finances, IT, HR) and leadership teams
Create scripts, queries, and automations (Python, SQL, VBA, or similar tools) to streamline data workflows, enhance process efficiency, and reduce manual reporting efforts throughout the organization
Apply data science concepts—such as statistical analysis, forecasting, and pattern identification—to uncover trends, evaluate business outcomes, and support strategic initiatives with data-driven evidence
Leverage artificial intelligence to augment trend prediction planning
Ensure high standards of data quality, documentation, and governance while collaborating cross-functionally to resolve data issues, communicate insights, and continuously improve reporting capabilities
Ensure preparation and planning to meet deliverables for forecasts, long term planning, lead system and other business processes
Participate in TREMEC global projects collaborating in the design of processes and operational improvement, contributing and building solutions that improve operations in different departments
Execute, coordinate and follow up for special assignments as needed
Support to GBD sales forecasting processes and quotation status report
Ensure compliance with established Business Systems within TREMEC
Manage, improve and monitor TREMEC business processes, identify areas for improvement and suggest solutions
Other duties assigned by manager
Qualification
Required
Bachelor's degree in data science, computer science, information systems, Statistics, or a related field
2–5 years of experience in data extraction, reporting, or BI roles
Proven experience building dashboards, databases, and automated reports
Strong SQL knowledge (T-SQL, PL/SQL, or similar)
Experience with Microsoft Access (queries, forms, VBA)
Proficiency in BI tools (QlikView, Power BI, Tableau)
Programming skills in Python or R (data analysis, automation, visualization)
Understanding data modeling, ETL processes, and relational databases
Ability to read and comprehend instructions, short correspondence, and memos, and write simple correspondence
Project Management- Develops project plans. Coordinates projects. Communicates changes and progress. Completes projects on time and budget. Manages project team activities
Preferred
Master's degree is a plus
Familiarity with cloud platforms (Azure, AWS) is a plus
Company
TREMEC
TREMEC is an automotive company providing transmissions, gears, shafts, and clutches.
1001-5000 employees
H1B Sponsorship
TREMEC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (2)
2023 (1)
2022 (1)
2021 (3)
Funding
Current Stage
Late StageLeadership Team
Jeffrey Nichols
Global Vice President Business Development / Corporate Strategy
Recent News
Renewable Energy Magazine
2024-10-29
2023-12-23
aftermarketNews
2023-12-23
Company data provided by crunchbase