Data Analyst

ICON Consultants, LP; United States; Vor Ort; USD 96.000 - 124.000; Teilzeit

Benefits dieser Stelle

401K

Health insurance

Dental

Vision

Zusammenfassung

ICON Consultants, LP in the United States seeks a Truck Service Digital Intelligence Specialist to build governed reporting, dashboards, data reconciliations, and decision-support across the Truck Service organization. This role bridges approved business definitions with data controls and requires working across SAP S/4, Dynamics 365 Field Service, Power BI, Cognos, and cloud data platforms.

The incumbent will deliver advanced SQL, data quality rules, KPI logic, and root-cause analysis,

Qualifikationen

• Experience delivering analytics and reporting across multi-system ERP/CRM environments.
• Strong SQL and data modeling skills for source-to-target mappings and data lineage.
• Experience building governed reporting and dashboards in enterprise settings.

Aufgaben

• Write and optimize complex SQL queries; develop end-to-end data lineage and semantic models.
• Reconcile SAP S/4 postings with D365 Field Service activity and resolve variances.
• Design and maintain Power BI and Cognos dashboards, scorecards, and embedded views.
• Define and enforce data quality rules and governance processes.

Kenntnisse

SQL

Data governance

KPI logic

Root-cause analysis

Tools

Power BI

Cognos

Excel

SAP S/4

D365 Field Service

Dataverse

Jobbeschreibung

Benefits: Comprehensive benefits (401K, Health, Dental, and Vision) through Icon Consultants are available

Travel Expectation: Approximately 10% travel to Truck Service locations and corporate headquarters

Job Type: 6 – month contract role

Position Metadata

• Employment Status: Open – TBD (May be filled contract-to-permanent)


• Travel Expectation: Approximately 10% travel to Truck Service locations and corporate headquarters

Position Summary

The Truck Service Digital Intelligence Specialist is a hands-on analytics and intelligence role responsible for building governed reporting, dashboards, data reconciliations, and decision-support systems across the Truck Service organization. This role absorbs the hands-on technical scope of the retired Metrics & Insights Lead role.

The Specialist acts as an essential operational bridge, turning approved business definitions and core operational questions into reliable data controls, fully reconciled financial/operational measures, and actionable intelligence.

The incumbent will regularly work across a multi-system enterprise data environment, including:

• Core ERP & CRM Platforms:


• SAP S/4: Finance, Controlling, Sales, Procurement, Inventory, Asset Management, and Master Data.


• Microsoft Dynamics 365 Field Service & Dataverse: Work Orders, Bookings, Resource Management, Assets, Accounts, and Products.


• Data Warehouses & Cloud Platforms: Azure, AWS, Snowflake, Databricks, and Oracle.


• Reporting & Analytics: Microsoft Power BI, IBM Cognos, and Controlled Excel Data Sources.

Key Responsibilities & Core Functions

• Advanced Querying & Modeling: Write and optimize complex SQL queries; construct robust source-to-target mapping logic, semantic data models, and end-to-end data lineage.


• Cross-System Financial Reconciliation: Reconcile SAP S/4 financial postings and results with D365 Field Service operational activity. Investigate and resolve variances related to timing, mapping, posting errors, interface failures, and master data discrepancies.

2. Reporting & Embedded Analytics

• Dashboard & Report Engineering: Design, build, and maintain Power BI and Cognos dashboards, operational scorecards, embedded D365 views, and standardized recurring reports.


• Operational Monitoring: Monitor data refresh cycles, user access permissions, platform performance, and user adoption rates.


• Governance Transition: Proactively identify and replace uncontrolled Excel-based reporting with centralized, governed reporting solutions.

3. Governance Execution & Data Quality

• Data Standards Maintenance: Update and maintain business glossary entries, data lineage tracking, and data quality rules.


• SQL Controls Implementation: Build and enforce SQL-based automated controls for data completeness, accuracy, timeliness, referential integrity, and financial balancing.


• Defect Escalation: Identify source-system and data-process defects and route them with supporting evidence to the accountable business or technical owner.

4. Insight Delivery & Analytics

• KPI Logic Implementation: Code and maintain approved KPI logic, including operational cases and SLA metrics derived from D365 case data.


• Root-Cause Analysis: Conduct detailed variance analysis and deliver actionable root-cause findings to business stakeholders.

Primary Deliverables

• SQL Assets: Advanced SQL scripts, automated data controls, financial/operational reconciliations, and semantic models.


• Analytics Assets: Power BI/Cognos dashboards, operational scorecards, embedded D365 analytical views, and recurring management reports.


• Documentation: Data lineage maps, test cases/evidence, data quality documentation, and variance analysis reports.

Decision Rights & Operational Boundaries

Domain

Scope & Rights

Decides

Technical implementation approach within established organizational and architectural standards.

Data definitions, metric calculations, data controls, and project priorities (subject to Manager approval).

Upstream and downstream source-system changes that impact reporting pipelines and reconciliation workflows.

Does NOT Own

Final KPI methodology definitions, strategic priority setting, report publication approvals, standard-job design, or source-system IT ownership.

Performance Measures & Success Criteria

Outcome Area

Illustrative Performance Measures

Technical Quality

SQL code accuracy, semantic model reliability, comprehensive test coverage for data pipelines.

Reporting Service

Automated refresh reliability, dashboard query performance, prompt issue resolution times.

Reconciliation accuracy, auditability/traceability, speed and aging of exception resolution.

Role Expectations & Operational Context

• Governance: Executes tasks within technical and operational standards set by the Level G Digital Intelligence Manager.