
Senior Business Intelligence Analyst
DCM Services
full-time
Posted on:
Location Type: Remote
Location: Florida • North Carolina • United States
Visit company websiteExplore more
Salary
💰 $80,000 - $100,000 per year
Job Level
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