Data Analytics & Operations Specialist

Overview

PITT OHIO, a $900 million, high service, highly profitable, transportation solutions provider offering SUPPLY CHAIN, LTL and TRUCKLOAD services is seeking a Data Analytics & Operations Specialist to join our team at our Corporate Headquarters in Pittsburgh, Pa. 

 

We offer competitive compensation, hospital/medical insurance with no monthly premiums or deductibles, vision, discount prescription, dental, 401K, profit sharing, paid vacations, pleasant work environment, and much more!

Responsibilities

Purpose:

This position is responsible for the analysis of company data and database systems in order to design, develop, and support custom reports for Pitt Ohio business units and external customers. Functions include planning, designing, coding, testing, and deploying of custom reports using Microsoft SSRS, Power BI, and other toolsets. This position also works with Data Engineers and Administrators to assist with application database support and/or escalate incidents when appropriate.

 

Essential Duties:

Support Services (60-70%)• Assist Data & Analytics team with resolution of data issues across a suite of technologies as required to meet a 99% uptime SLA.• Actively monitor and maintain Tier 2 Data & Analytics ticket support queue; updating, re-prioritizing, and escalating issues as required to maintain SLA.• Provide technical assistance to end users, vendors, and business groups as required.• Provide process automation support, gathering requirements, and promote requests to Tier 3 for development when ready.• Develop, maintain, and support a large number of reports using MSSQL Reporting Services, Power BI and other toolsets.• Manage multiple reporting requests in a deadline-driven, high-pressure environment.• Analyze, evaluate and interpret data from key business systems.• Responsible for maintaining regularly scheduled reports (daily, weekly, monthly) for internal/external customers.• Ability to react to change quickly and handle other essential tasks as assigned.• Assists users, business analysts, and vendors in troubleshooting business service problems and data inconsistency.• Complete daily, weekly, and monthly maintenance tasks.

 

Implementation Services (20-30%)• Develop, model, and design data architecture solutions, integration, and access in collaboration with engineers, admins and other IT groups.• Work with business analysts and data consumers to translate business requirements into data design.• Work independently on moderate to complex projects serving as lead as well as working within a team environment throughout project implementation.• Develop process automation solutions using Microsoft Power Automate• Researches new technologies and presents recommendations and justifications on moderate to major hardware and software purchases.• Complete reviews, upgrades, and replacements of current data analytical technology systems and products on a 3-5 year ongoing cycle.• Implementation of changes as requested by business analysts and system owners for current application integrations and new application implementations.

 

Administration (10-15%)• Lead, mentor, and/or provide guidance to data user community, where applicable, including guidance for troubleshooting and design.• Work directly with supervisor to strategize and plan 3-5 year data services, capabilities, and self-goals.• Assists with ongoing review and documentation of analytical data environment and remediation as needed to address technology gaps and improve support.

 

Other Duties:

•Promote analytics to the edge of our business focusing on data structure over visualizations.• Help resolve data architectural disputes among architects, analysts, and/or development groups.• Effectively communicate project status and ensure accuracy of project documentation.• Timely submission of daily hours and status reports, salary calendars, and project documentation.• Document and maintain access, processes, and operating methods.• Draft support documentation (knowledge base articles).• Attend and actively participate in team and department meetings.• Participate in 24x7 support and on-call rotation as required; available by cell at all times.• Assist and work on enterprise projects as required within IT organization.• Schedule flexibility and weekend work as required by project implementation and major break/fix.

Qualifications

• 8-10+ years of hands-on experience with reporting development, management, support, and implementation in a Microsoft SQL environment.• Education: Associates Degree in a technical discipline and/or 8+ years of industry experience OR a Bachelor’s Degree in a technical discipline and 5+ years of industry experience.

• Certification: Microsoft SQL MCSA preferred but not required• High level of expertise in the follow