Business Data Analyst

Business Data Analyst

The Business Data Analyst ensures the accuracy, integrity, and timeliness of Dynamic Solution Group (DSG) reporting across multiple systems including, but not limited to, the Dynamic Tracking System (DTS), and Lakehouse. This position is responsible for monitoring large, complex datasets, identifying discrepancies or gaps, and supporting root cause analysis of reporting issues. The role partners closely with DSG management, DSG MIS (Management Information Services), and operational stakeholders to ensure reporting outputs meet audit, compliance, and business requirements. The duties will grow with the position as the scope and skill level increases.

Responsibilities

• Data Integrity & Reporting Oversight
  • Review and validate daily, weekly, and monthly reporting outputs for accuracy, completeness, and timeliness
  • Analyze large, complex datasets to identify inconsistencies, missing data, or anomalies
  • Ensure reporting aligns with operational workflows, compliance requirements, and audit expectations
  • Perform reconciliations between source systems (FOW, production systems, Lakehouse) and downstream reports
  • Provides overall consistency, structure, and oversight in a complex reporting landscape
• Issue Identification & Root Cause Analysis
  • Investigate reporting discrepancies and determine root cause across systems, data feeds, or processes
  • Partner with technology, RPA, and data teams to resolve errors or gaps in reporting logic
  • Track recurring issues and identify trends to mitigate future reporting risk
  • Maintain documentation of known issues, resolutions, and data dependencies
• MIS Team Coordination (Indirect Oversight)
  • Provide direction and guidance to the MIS team on reporting priorities and expectations
  • Review output from MIS team to ensure quality, consistency, and adherence to standards
  • Support training, clarification, and refinement of reporting logic and business rules
  • Act as escalation point for complex reporting issues
• Compliance, Audit, & Risk Support
  • Ensure all reporting supports audit readiness and regulatory compliance requirements
  • Maintain documentation and audit trails supporting reported data
  • Partner with audit, compliance, and leadership teams to respond to reporting inquiries
  • Identify and mitigate data-related risks impacting DSG reporting
• Process Improvement & Data Evolution
  • Identify opportunities to improve reporting efficiency, automation, and data quality
  • Support transition from legacy Excel-based reporting to scalable data environments (FOW, Lakehouse)
  • Assist in UAT, validation, and rollout of new reporting processes or data structures
  • Recommend enhancements to reporting frameworks, controls, and validations
• Technical Coordination
  • Liaise with software developers to resolve complex technical issues
• Service Partnership and Executive Reporting
  • Partner with managers to review and validate reports for accuracy and data integrity
  • Educate managers in interpreting performance data, metrics, and trends to drive informed decision making
  • Develop and deliver concise executive summaries for senior leadership, highlighting key findings, trends, risks, and opportunities

Requirements

• 3–5+ years of experience in data analysis, reporting, or similar role
• Advanced Excel skills (required), including the ability to audit, troubleshoot, and validate large datasets, complex formulas, pivot tables, and data structures
• Experience working with large, complex datasets from multiple sources
• Demonstrated ability to identify data issues and perform root cause analysis
• Strong attention to detail with a focus on accuracy and completeness
• Effective communication skills with ability to translate data issues to non-technical stakeholders

Preferred Experience

• Bachelor's degree in Business, Analytics, Data Science, Information Systems, Finance, or a related field
• Experience with Power BI or similar data visualization tools
• Experience with data environments such as FOW, Snowflake, Lakehouse, or similar
• Basic SQL or querying knowledge (not required but beneficial)
• Experience working with distributed teams
• Background in title, escrow, financial services, or a regulated environment
• Familiarity with audit, compliance, or risk-related reporting

Key Competencies

• Analytical thinking and problem-solving
• Data quality mindset with curiosity and ability to question outputs
• Organization and prioritization
• Collaboration and cross-functional partnership
• Accountability and ownership of deliverables