Data Analytics & Operations Specialist - Pitt Ohio

PITT OHIO, a $900 million, high service, highly profitable, transportation solutions provider offering SUPPLY CHAIN, GROUND, 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!

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

• 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 following areas:
o Microsoft SSRS 2012/2016/2019 (SQL Server Reporting Services)
o Microsoft Power BI
o Microsoft Visual Studio and Report Builder
o Microsoft SQL Server (2008, 2012, 2016, 2019) administration
o Microsoft Power Automate
o Complex SQL query writing
o SSAS (SQL Server Analysis Services) and SOA (Service-Oriented Architecture) administration
o Data backup and recovery techniques
o ETL/data transformation methods and implementation
o Data virtualization, analytics, and integration techniques
o Knowledge of multi-server, high availability RPO/RTO in a Microsoft SQL environment
o Data performance optimization
• Strong problem solving and analytical skills to make sense of unclear data and requirements
• Understanding/experience with cloud based integration services and providers is required.
o Microsoft Azure
o Snowflake
• High level of experience in a highly virtualized, converged datacenter environment is a requirement.
• High level of experience using service desk tools for ticket management (ServiceNow).
• Full understanding of Microsoft based desktop & server operating systems.
• High level of experience with Microsoft Office, Visio, and Project.
• Strong technical writing skills and good ability to speak to different audiences on their terms.
• Experience interacting with PostgreSQL, FoxPro, MySQL, and Microsoft Access preferred.
• Outstanding customer service and interaction skills, as well as excellent verbal and written communications skills.
• Displays a high level of effort and commitment to performing quality work. Operates effectively within the organizational structure and demonstrates the ability to work independently, perform well under pressure, prioritize tasks, and meet deadlines.
• Maintains a high level of technical skill by attending technical seminars, training courses, and completing certifications. Communicates this knowledge to others as required.
• Strong skill in providing technical training (one-on-one, small group or formal presentation)

Working Conditions/Physical Requirements:

•Candidates will ideally live in close proximity to one of our data centers for on-site work needs, and will otherwise work in a Remote/Hybrid capacity.
• Travel to remote locations (once or twice a year) may be required.
• Schedule flexibility is a must (weekends, after hours).
• Must be able to lift, carry, push, or pull a minimum of 25 lbs.

• Must possess and maintain a valid driver’s license.
• Sedentary work – exerting up to 10 pounds of force occasionally and/or negligible amount of forces frequently or constantly to lift, carry, push, pull or otherwise move objects including the human body. Sedentary work involves sitting most of the time. Walking and standing are only required occasionally.
• Close visual acuity is required to perform activities such as preparing and analyzing data and figures, viewing computer terminal, and extensive reading.
• Typical exposure to interior environmental conditions like air conditioning and dust; no substantial exposure to adverse environmental conditions.
• Manual dexterity is regularly required including fingering, grasping, and typing; manual dexterity includes repetitive motion of the wrists, hands, and fingers.
• Talking and hearing required to communication with and listen to others to share or receive information. May be occasionally exposed to noise including telephone, office machinery, and conversations of others.