DCM Services

Senior Business Intelligence Analyst

DCM Services

full-time

Posted on:

Location Type: Remote

Location: FloridaNorth CarolinaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $80,000 - $100,000 per year

Job Level

Tech Stack

About the role

  • Own the full reporting lifecycle, from requirements gathering through automation, access governance, and ongoing performance review
  • Design, build, and publish Power BI dashboards and paginated reports using DAX, Power Query, data modeling, and row-level security
  • Ensure reports are intuitive, visually consistent, and aligned with business needs, including correct date logic and “as-of” reporting
  • Automate recurring reporting processes using VBA macros and Power Automate workflows
  • Translate ambiguous business questions into well-defined analytical frameworks and measurable outcomes
  • Perform root cause analysis to explain changes in key performance metrics
  • Conduct cohort analysis, liquidation curve modeling, coverage rate analysis, and forecasting to support portfolio and collections performance
  • Present insights and recommendations to senior leadership and clients using clear, executive-ready storytelling

Requirements

  • Bachelor’s degree in Business, Finance, Information Systems, Data Science, Computer Science, or related field
  • 3–5 years of analytics or business intelligence experience in financial services, healthcare, or collections
  • Advanced T-SQL skills (CTEs, window functions, complex joins, debugging)
  • Strong Power BI experience, including DAX, data modeling, RLS, and Power BI Service
  • Advanced Excel skills, including Power Pivot and VBA automation
  • Ability to manage multiple priorities in a fast-paced, stakeholder-driven environment
  • Excellent written and verbal communication skills; comfortable presenting to non-technical audiences
  • Working familiarity with AI/ML concepts applied to analytics, such as anomaly detection or predictive modeling.
Benefits
  • Bonus Eligible 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
DAXPower Querydata modelingrow-level securityVBAPower AutomateT-SQLPower Pivotanomaly detectionpredictive modeling
Soft Skills
communicationpresentationanalytical thinkingproblem-solvingstakeholder managementtime managementstorytellingcollaborationadaptabilityattention to detail