Data Integration & BI Specialist (Flexible Hours)

Sophus Consulting; Northern (KY); Hybrid; USD 85,000 - 125,000; Full time

Benefits offered by this job

401K

Comprehensive health insurance

Paid holidays

Flexible spending plan

Performance incentives

Job summary

Sophus Consulting in the United States seeks a Data Integration & BI Consultant to design, build, and optimize the data layer of legal technology implementations. This role merges data integration, migration, reporting, and BI to deliver reliable, actionable insights for legal teams.

You own the data layer from integration design through reconciliation, map data fields, build dashboards, validate outputs, and ensure audit-ready documentation while coordinating with vendors, clients, and Sophus

Qualifications

• 5+ years in data, integration, or BI roles, preferably in professional services.
• Proficiency in SQL for data analysis, validation, and reporting.
• Hands-on ETL, API integrations, or data migration projects.
• Strong data mapping, transformation, and reconciliation skills.
• Familiarity with matters, intakes, contacts, documents, time, and billing concepts.
• Excellent written and verbal communication; able to translate tech findings.
• US location and authorization to work in the US.

Responsibilities

• Design and implement integrations between legal platforms and enterprise systems using ETL, APIs, or file-based exchange.
• Map source-to-target data fields, define transformation rules, and maintain design docs.
• Coordinate with vendors and IT for APIs, authentication, and data exchange formats.
• Build dashboards and KPI views using SQL and BI platforms; validate outputs.
• Lead or support data migration activities with post-load validation and reconciliation.
• Document runbooks, field mappings, and issue logs for audit-ready traceability.

Skills

SQL

Data integration

ETL

APIs

Data mapping

Data reconciliation

Data quality

BI reporting

Communication

Education

BS/BA in CS/IS/Analytics

Tools

Power BI

Tableau

Platform-native reporting

iManage / NetDocuments

Outlook / email integration

Job description

Sophus Consulting in the United States seeks a Data Integration & BI Consultant to design, build, and optimize the data layer of legal technology implementations. This role merges data integration, migration, reporting, and BI to deliver reliable, actionable insights for legal teams.

You own the data layer from integration design through reconciliation, map data fields, build dashboards, validate outputs, and ensure audit-ready documentation while coordinating with vendors, clients, and Sophus