Data Solutions Analyst Job at Prequel Solutions, Pittsburgh, PA

MHFXcllDV3VuMzVXMjhXYkZ4Zkk2c3BETFE9PQ==
  • Prequel Solutions
  • Pittsburgh, PA

Job Description

We are seeking a skilled Contract Full Stack Data Solutions Engineer to enhance and support our enterprise-wide reporting and analytics program. This role focuses on designing and managing data pipelines (ETL), building conceptual, logical, and physical data models, and delivering reliable, high-quality reporting solutions. The ideal candidate blends strong technical expertise with a clear understanding of business needs to make data-driven insights accessible across the organization.

Key Responsibilities:

  • Design, develop, and maintain ETL pipelines to extract, transform, and load data from diverse source systems (ERP, CRM, work order management, etc.).

  • Build and maintain scalable data models (conceptual, logical, physical) to support business intelligence, analytics, and operational reporting.

  • Develop, maintain, and document standardized reporting solutions, including paginated reports and interactive dashboards.

  • Maintain data dictionaries, metadata repositories, and clear technical documentation for pipelines and data models.

  • Monitor and improve data quality, consistency, and pipeline performance; proactively troubleshoot and resolve data issues.

  • Collaborate with business stakeholders and technical teams to translate reporting requirements into reliable data solutions.

Skills & Requirements:

Education / Experience:

  • 3–5 years of experience in data engineering, data modeling, database design, or data architecture.

  • Hands-on experience building ETL pipelines with platforms like Azure Data Factory, Microsoft Fabric, Databricks, or similar tools.

  • Proven ability to design and implement enterprise-scale data models.

  • Experience developing reports and dashboards using Power BI or similar visualization tools.

  • Strong attention to detail, with focus on data accuracy, formatting consistency, and reliability.

  • Disciplined documentation practices, including versioning of data logic, reports, and changes.

  • Experience working in team environments with version control (e.g., Git) and CI/CD practices for data solutions.

Preferred Skills / Abilities:

  • Budget and cost data experience, including forecasting, variance analysis, and financial metrics.

  • Experience with Microsoft Fabric, including workspace management and semantic model development.

  • Familiarity with Power BI as a visualization tool.

  • Hands-on experience with ETL processes and data warehousing using Spark, Databricks, or Microsoft Fabric.

Job Tags

Remote job, Contract work

Similar Jobs

Curtis Contracting, Inc.

Project Administrative Assistant Job at Curtis Contracting, Inc.

Description:: Project Administrative Assistant The Project Administrative Assistant provides essential administrative and clerical support to project managers, superintendents, and other team members involved in highway construction projects. This role is responsible for... 

Computechsale

Bookkeeper Job at Computechsale

A fast-growing ecommerce company looking for a skilled Bookkeeper to maintain our financial records, including purchases, sales, returns, shipping, receipts and payments. Work closely with our team to create and analyze financial reports, Audit and reconciliation . The... 

StaffManagement

Forklift Operator - Order Picker / Reach / Sit-Down Job at StaffManagement

 ...involves operating multiple types of equipmentincluding order pickers, reach trucks, and sit-down forkliftswhile also assisting with...  ...environment. Job Responsibilities: Operate Order Picker (Cherry Picker), Reach Truck, and Sit-Down (Propane) forklifts safely... 

Logan's Roadhouse

Host / Hostess Job at Logan's Roadhouse

 ...up a stool because opportunity and good times are calling. NOW HIRING / IMMEDIATELY HIRING FULL TIME & PART TIME HOSTS / HOSTESSES Your role is to be the best first and last impression to everyone passing through our doors. It is essential to our restaurants... 

Next Technology Professionals Ltd.

Senior Software Engineer Job at Next Technology Professionals Ltd.

 ...Utilidata is a fast-growing NVIDIA-backed edge AI company enabling greater visibility and control of power utilization in energy-intensive infrastructure, like the electric grid and data centers. Karman, the companys distributed AI platform powered by a custom NVIDIA...