BI / Data & Reporting Analyst

Title: BI / Data & Reporting Analyst (Subcontract for Ark Technology Consultants)

Through Ark Technology Consultants (Ark) and Strategic Resource Services (SRS), we offer custom talent solutions to help our clients meet their evolving technology and business needs. We help effectively match the right technology professional to their organization, recruiting for contract, contract-to-hire, and direct roles. Please note that this is a (contract/contract to hire/direct hire) opportunity with our client and NOT with Ark.

Position Summary

We are seeking a Business Intelligence / Data & Reporting Analyst to develop and support reporting, dashboards, analytics, and data solutions across the organization. This role will work closely with business and technical teams to transform data into meaningful insights, improve operational reporting, and ensure accurate and reliable information is available for decision-making.

The ideal candidate will have hands-on experience with Power BI, SQL, relational databases, reporting, data integration, and Microsoft tools, along with the ability to understand business requirements and translate them into practical reporting and analytics solutions.

Key Responsibilities

·      Design, develop, and maintain Power BI dashboards and reports supporting operational and business needs.

·      Build data visualizations that effectively communicate KPIs, trends, performance metrics, and business insights.

·      Develop and maintain Power BI solutions using DAX and Power Query.

·      Write and troubleshoot SQL queries to retrieve, analyze, validate, and manipulate data.

·      Work with relational databases, data models, tables, views, and related database structures.

·      Develop and maintain operational, KPI, and ad hoc reports for business stakeholders.

·      Perform data validation and reconciliation to ensure reporting accuracy and consistency.

·      Assist with data integrations, including APIs, ETL processes, data imports/exports, and system-to-system integrations.

·      Partner with business users to gather requirements and translate them into effective reporting and analytics solutions.

·      Troubleshoot reporting, database, data quality, and integration issues.

·      Create documentation for reports, dashboards, data processes, and technical solutions.

·      Utilize Microsoft 365, Excel, Teams, SharePoint, and Visio to support collaboration, analysis, documentation, and process improvement.

Required Skills & Experience

·      Hands-on experience developing dashboards and reports with Power BI

·      Experience with DAX and Power Query

·      Strong working knowledge of SQL

·      Experience working with relational databases and data modeling

·      Experience creating operational reports, KPI reporting, and ad hoc analytics

·      Strong understanding of data validation, data quality, and reporting accuracy

·      Exposure to ETL processes, APIs, imports/exports, and data integrations

·      Strong Microsoft Excel skills

·      Experience with the broader Microsoft 365 environment

·      Ability to gather business requirements and translate them into technical reporting solutions

·      Strong analytical, troubleshooting, and problem-solving skills

·      Ability to communicate effectively with both technical and non-technical stakeholders

Preferred / Nice-to-Have

·      Experience supporting enterprise or ERP applications

·      Experience integrating data from multiple business systems

·      Experience with advanced Excel reporting and analysis

·      Familiarity with SharePoint and Visio

·      Experience documenting data flows, integrations, and business processes

·      Experience working in an environment where reporting and analytics support multiple departments or business functions

Core Technology Stack

Power BI | DAX | Power Query | SQL | Relational Databases | Data Modeling | Reporting & Analytics | ETL | APIs | Excel | Microsoft 365 | Teams | SharePoint | Visio