Data and Analytics Engineer

Pittsburgh Tomorrow; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

Life in Pittsburgh in Pittsburgh, PA is seeking a data analytics professional with hands-on experience in AI technologies (MCP or RAG), Lakehouse architectures, and cloud platforms. The role focuses on data modernization of on-prem systems and building scalable data platforms.

You will work with business and data analysts to translate needs into analytical solutions, develop and test databases, queries, views, reports, and dashboards, and ensure data quality.

Qualifications

• BA or BS degree required.
• Experience with MCP or RAG AI technologies and Lakehouse architecture.
• Experience with cloud platforms (AWS preferred) and MS T-SQL.

Responsibilities

• Collaborate with Business Information and Data Analysts to understand customer needs.
• Analyze data to improve business metrics and customer experience.
• Develop and test BI tools, reports and dashboards.
• Assist in data conversions, imports and exports across systems.
• Document models, solutions and implementations.
• Design and build reporting and analysis tools to streamline reporting and forecasting.
• Support integration of analytical platforms with enterprise systems.
• Troubleshoot analytics tools and track performance issues.
• Adhere to policies and standards.

Skills

MCP/RAG AI

Lakehouse architecture

AWS cloud platform

APIs integration

SSIS

MS T-SQL

On-prem legacy systems

Education

BA or BS

Tools

SSIS

Job description

Position Overview:

This role requires hands-on expertise in AI technologies such as MCP or RAG, along with Lakehouse architecture, cloud platforms (AWS preferred), APIs, SSIS, and Microsoft T-SQL. The ideal candidate will be comfortable working with on-premises legacy systems while helping design and implement forward-looking data solutions. You will play a key role in driving data modernization initiatives and enabling scalable, future-ready data platforms.

Primary Responsibilities:

• Works with Business Information and Data Analysts to understand customer needs.
• Collects, analyzes and shares data to help business teams drive improvement in key business metrics, customer experience and business results.
• Utilizes database and web application technologies to develop and evaluate innovative business intelligence tools and automated reports.
• Develops and tests analytical solutions such as databases, queries, views, reports and dashboards.
• Assists in data conversions, imports and exports of data within and between internal and external software systems.
• Documents new and existing models, solutions and implementations.
• Designs and builds reporting and analysis tools that help streamline the business and makes reporting, analyzing, planning and forecasting more efficient.
• Supports and assists with the integration of analytical platforms with enterprise systems and applications.
• Troubleshoots analytics tools, systems, and software.
• Tracks performance and production issues.
• May assist in performance tuning of analytics applications.
• Escalates production issues as appropriate.
• Ensures the collected data is within required quality standards.
• May maintain the quality of Metadata Repository by adding, modifying and deleting data.
• Adheres to process, policies and standards.
• Keeps customers informed about business intelligence tool problems and resolutions.
• Tracks and reports on issues and enhancement requests for the business in a timely manner.
• Performs regular assignments using own judgment and following the corporation's data policy, while keeping supervisor informed as necessary.
• Receives general guidance on new projects as to methods, procedures and desired end results.
• Uses discretion to make decisions within the scope of their responsibilities.
• Complex assignments are usually reviewed upon completion.
• Performs other related duties and projects as assigned.

Minimum Level of Education Required to Perform the Primary Responsibilities of this Position: BA or BS