Duties & Repsonsibilites
- Analyze and audit account-level issues and defect patterns
- Identify and correct data errors across various datasets, applying advanced formulas & functions
- Resolve data discrepancies and integration issues by performing robust ETL Processes with Power Query
- Import and clean data from diverse sources (e.g., ERP systems like SAP, CSV files, APIs), merge datasets (e.g., combining carrier invoices with internal tracking data), and expertly handle missing values, duplicates, and inconsistent formats (e.g., date standardization)
- Recommend data-driven solutions and process improvements to team members and management
- Translate complex analytical findings into clear, actionable insights
- Produce high level PowerPoints and data insights into digestible presentations for leadership
- Recommend data adjustments, corrections, and process changes in collaboration with other analysts and management
- Create custom scripts for Excel using Office Scripts
- Support advanced data visualization initiatives by exporting Excel data to Power BI for comprehensive reporting and dashboard creation
Experience & Qualifications
- Logistics and Transportation experience preferred
- College Degree in Information Science or related field is preferred
- 1-3 years of Data Analytics preferred
- In depth knowledge of advanced functions in Microsoft Excel
- Proficiency in Microsoft Powerpoint
- Expertise in PivotTables & Power Pivot for creating dynamic reports, analyzing key performance indicators, and data modeling with large datasets from multiple sources
- Proficiency in Data Validation & Conditional Formatting for ensuring data quality and highlighting outliers
Skills Required
- In-depth knowledge of advanced Microsoft Excel functions
- Expertise in PivotTables and Power Pivot for data modeling
- Proficiency with Power Query and ETL processes
- Experience creating custom Excel scripts using Office Scripts
- Experience exporting Excel data to Power BI and building reports/dashboards
- Proficiency in Microsoft PowerPoint for leadership presentations
- Experience importing and cleaning data from ERP systems (e.g., SAP), CSVs, and APIs
- Proficiency in data validation and conditional formatting to ensure data quality
- 1-3 years of data analytics experience
- Logistics and transportation experience
- College degree in Information Science or related field
What We Do
Who? FitzMark is an Indianapolis-based, third-party logistics (3PL) company. What? Simply put, we serve as a liaison between a shipper and a carrier in order to move freight. We make the connection between companies who have items to ship and the transportation companies that ship them. FitzMark plays a key role in the supply chain, allowing businesses to become leaner and reduce assets. Why? At FitzMark, we strive to provide best-in-class logistics services for our customers. Our mission is to create significant customer value through delivering reliability in the flow of customer goods and provide creative and technologically-advanced supply chain solutions. This is achieved by cultivating relationships based on trust and mutual respect with everyone we partner with and creating a goal-driven and fulfilling environment for all FitzMark employees. Where do you come in? The driving force behind FitzMark's remarkable success and growth are the people who call themselves FitzMarkers. Here at FitzMark, we have cultivated a fast-paced, energy-infused environment to drive productivity and accelerate growth to achieve wildly successful results. We are a team of driven and motivated individuals who work hard and laugh harder. To learn more, visit www.fitzmark.com.
