Data Ops & Analytics Specialist

On Site Full TimePittsburgh, Pennsylvania, United StatesPITT OHIO

Role Overview

The Data Ops & Analytics Specialist will support services, develop and maintain reports, analyze and interpret data, and provide process automation support. The role will also involve implementation services, such as developing data architecture solutions and working with business analysts to translate business requirements into data design. The Specialist will also be responsible for administration tasks, such as submitting status reports and participating in weekly team status meetings.

What You Will Do

The Data Ops & Analytics Specialist will provide technical assistance to end users, vendors, and business groups, develop and maintain reports, analyze and interpret data, and provide process automation support. The role will also involve developing data architecture solutions, working with business analysts to translate business requirements into data design, and implementing and deploying data changes as requested by business analysts and system owners.

Why It Might Be a Fit

The Data Ops & Analytics Specialist will be a good fit for someone with 5-8+ years of hands-on experience with reporting development, management, support, and implementation in a Microsoft SQL environment. The role requires a high level of expertise in areas such as Microsoft SSRS 2022, Microsoft Power BI, and complex SQL query writing. The Specialist will also need to have strong problem-solving and analytical skills to make sense of unclear data and requirements.

Requirements

  • 5-8+ years of hands-on experience with reporting development, management, support, and implementation in a Microsoft SQL environment
  • Education: Associate 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 Data Analyst Associate preferred but not required
  • High level of expertise in the following areas: Microsoft SSRS 2022 (SQL Server Reporting Services), Microsoft Power BI, Microsoft Visual Studio and Report Builder, Microsoft SQL Server (2019, 2022, 2025) administration, complex SQL query writing, SSAS (SQL Server Analysis Services) and SOA (Service-Oriented Architecture) administration, data backup and recovery techniques, ETL/data transformation methods and implementation, data virtualization, analytics, and integration techniques, knowledge of multi-server, high availability RPO/RTO in a Microsoft SQL environment, 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
  • Microsoft Azure, Microsoft Fabric, Snowflake, basic understanding of AI technologies and how to prepare and cleanse data for AI consumption
  • 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)

Benefits

  • Competitive pay
  • Excellent benefits including medical insurance with no weekly premiums, dental, vision, 401(k) and profit sharing
  • Paid time off and holidays
  • A respectful, people first work environment
  • Well-maintained equipment & modern facilities

To apply for this job please visit careers-pittohio.icims.com.

Tired of manual job applications?

JobCopilot auto-applies to thousands of RevOps and GTM roles on your behalf — so you can focus on interviews, not applications.

RevOps Careers Favicon

Get the latest RevOps jobs every Monday.

No noise. Just the best GTM roles, curated weekly.

We don’t spam! Read our privacy policy for more info.

Applying for this role?

Tailor your resume to this exact role — hiring managers notice the difference.

Latest articles on the blog

RECRUITERS!

Reduce the risk of your recruitment process (applicant quality, long and inefficient process) by selecting from a relevant pool of candidates.

POST A NEW JOB NOW!