Want to hear how I work? Hit play.Kablio AI applies for you. You just show up to the interviewKablio AI helps you secure roles in construction, clean energy, facilities management, engineering, architecture, sustainability, environment and other physical world sectors.
Get hired, get rewarded!
Land a job through Kablio and earn a 5% salary bonus.
Exclusive benefits
5%Bonus
Data Management Supervisor
Terra Contracting Inc
Specializes in underground utility installation and maintenance across southwestern U.S.
Supervise data team, design dashboards, develop tools, and analyze data
Tool Development: Create custom, dynamic tools to enhance data efficiency across departments using Excel and or other software.
Foster a culture of accountability, accuracy, and continuous improvement in data processes.
Data Aggregation: Build custom business logic to aggregate data at scale accurately.
Directly supervise one team member, providing guidance, coaching, and performance feedback.
Data Transformation: Process raw, unstructured data from multiple sources, converting it into accessible and visually appealing reports, dashboards and summaries for non-technical stakeholders.
Ad-Hoc Reporting: Deliver ad-hoc reports accurately and efficiently, leveraging Excel expertise and domain knowledge.
Trend Analysis: Analyze and identify the root causes of high-level trends at the most granular level to uncover actionable business insights.
Dashboard Design: Develop and implement KPI dashboards using Excel or data visualization software.
What you bring
excel
power query
power pivot
vba
bachelor's
analytical
Data Visualization
Data Integration and Management (Preferred)
Proficiency in data cleansing techniques, including removing duplicates, text-to-columns, and using formulas like TRIM and SUBSTITUTE.
Familiarity with conditional formatting for highlighting trends and anomalies in data.
Data Management: Demonstrated ability to manage and organize large volumes of data with a high level of accuracy.
Knowledge of array formulas and dynamic arrays (e.g., UNIQUE, FILTER, SORT).
Automation and Efficiency (Preferred)
Experience in importing/exporting data to/from databases or other software via Excel.
Analytical Skills: Exceptional analytical and problem-solving skills, with the ability to derive meaningful insights from complex data sets.
Knowledge of Power Pivot for managing and analyzing large datasets efficiently.
Skilled in handling large datasets without performance degradation by using techniques like efficient formulas, filtering, and workbook optimization.
Competent in designing custom dashboards using charts, slicers, and interactive elements.
Communication: Ability to translate technical data into understandable and actionable insights for non-technical audiences.
Attention to Detail: Strong data management skills with meticulous attention to detail.
Expertise in using advanced formulas such as VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP.
Skilled in Excel VBA/Macros for automating repetitive tasks and creating custom tools.
Skilled in leveraging nested IF statements, conditional logic, and error-handling functions (e.g., IFERROR).
Experienced in using Excel's What-If Analysis tools (e.g., Goal Seek, Data Tables, Scenario Manager).
Expertise in building dynamic and interactive charts (e.g., combination charts, sparklines).
Proficiency in using Power Query for transforming and merging data from multiple sources.
Experience with data validation for creating drop-down lists and ensuring data integrity.
Proficient in creating and managing pivot tables for dynamic data analysis.
Organizational Skills: Excellent organizational and multi-tasking abilities, capable of handling multiple projects simultaneously.
Advanced Data Handling and Analysis
Ability to link and manage data across multiple workbooks and external data sources.
Education: Bachelor’s degree in business, Mathematics, Information Systems, Engineering, or a related field preferred.
Hey there! Before you dive into all the good stuff on our site, let’s talk cookies—the digital kind. We use these little helpers to give you the best experience we can, remember your preferences, and even suggest things you might love. But don’t worry, we only use them with your permission and handle them with care.