Senior Business Intelligence Analyst at DCM Services

Bloomington, Minnesota, United States -

Full Time

Start Date

Immediate

Expiry Date

04 Aug, 26

Salary

100000.0

Posted On

06 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Power BI, DAX, T-SQL, Power Query, VBA, Power Automate, Data Modeling, Excel, Root Cause Analysis, A/B Testing, Cohort Analysis, Financial Analytics, Stakeholder Management, Data Governance, Storytelling

Industry

Financial Services

Description

Description Senior Business Intelligence Analyst Location: Minneapolis / Twin Cities Hybrid Employment Type: Full-Time Bonus Eligible: Yes About DCM Services DCM Services is a trusted leader in receivables management, partnering with financial institutions, healthcare providers, and government agencies to deliver ethical, compliant, and results-driven recovery solutions. With a strong focus on data, compliance, and continuous improvement, DCM leverages analytics and technology to improve outcomes for clients while maintaining the highest standards of consumer protection. At DCM, data isn’t just reporting — it drives strategy. Our Business Intelligence team plays a critical role in shaping operational decisions, client insights, pricing strategies, and performance optimization across the organization. Position Summary DCM Services is seeking a Senior Business Intelligence Analyst to serve as a key analytical partner across Operations, Finance, Client Services, Compliance, and Business Development. This role is ideal for a hands-on analyst with deep experience in SQL and Power BI who thrives on turning complex, multi-source data into clear, actionable insights. This is a senior individual contributor role with high visibility, ownership of enterprise reporting, and regular interaction with senior leadership and external clients. Strong communication skills and the ability to proactively partner with stakeholders are essential. Requirements What You’ll Do Reporting & Dashboard Development 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 Analytics & Business Intelligence 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 Design and analyze randomized controlled experiments (A/B tests) to evaluate operational and strategy changes Serve as a subject-matter expert on client KPIs, operational benchmarks, and reporting standards Data Management & SQL Development Write advanced T-SQL queries using CTEs, window functions, complex joins, and conditional logic Independently navigate SQL Server environments (SSMS) to explore schemas, views, and stored procedures Ensure data accuracy and integrity; document assumptions and escalate data quality issues as needed Partner with IT on ETL and upstream data flows to troubleshoot and improve reporting pipelines Business Partnership & Communication Collaborate with Finance and Business Development on data-driven pricing models for prospective clients Ensure reporting aligns with regulatory requirements including FDCPA, TCPA, GLBA, and HIPAA where applicable Present insights and recommendations to senior leadership and clients using clear, executive-ready storytelling What You Bring Required Qualifications 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 Preferred Experience Collections industry metrics (RPC%, coverage rates, liquidation curves, portfolio performance) Power Automate for report distribution and workflow automation Experimental design and statistical significance testing Python or R for advanced analytics or modeling Familiarity with SQL Server performance and concurrency concepts Why Join DCM Services? High-impact analytics role with visibility across the organization Opportunity to shape reporting standards and analytics strategy Collaborative, data-driven culture with strong leadership support Stable, growing organization with long-term client relationships #DCMHP1

Responsibilities

The role involves owning the full reporting lifecycle by designing Power BI dashboards and automating processes to provide actionable insights. The analyst will partner with various departments to translate business questions into analytical frameworks and present findings to senior leadership.