Business Intel Analyst

System One; Merrifield (VA); In loco; USD 65.000 - 90.000; Tempo pieno

Descrizione del lavoro

System One is seeking a data analytics professional in Merrifield, VA to deliver QC reporting and analytics for the Real Estate Lending and audit stakeholders. You will maintain dashboards, validate outputs, and analyze trends to inform leadership decisions.

Ideal candidates have 2–5 years in data analysis, strong Power BI/SQL/Excel skills, and a solid understanding of risk reporting lifecycles. This on-site role offers growth in modernization initiatives and cross-functional collaboration.

Competenze

• 2–5 years of experience in data analysis, reporting, or business intelligence.
• Understanding of business operations, risk management, and reporting lifecycles.
• Proficient with Power BI, SQL, Excel, Power Query, and data visualization tools.
• Knowledge of data validation, reconciliation, and quality practices.
• Strong analytical and troubleshooting skills with attention to detail.
• Effective communication and stakeholder management skills.
• Bachelor’s degree in Business Administration, Statistics, Data Analytics, or related field.
• Regulatory or audit reporting experience is a plus.

Mansioni

• Support Quality Control Risk Management by delivering accurate, timely reporting and analytics for QCRM leaders and stakeholders.
• Maintain recurring reports and dashboards, validate outputs, analyze trends and risks.
• Create, refresh, validate, and distribute monthly QC reporting and management-level reports.
• Analyze QC results, trends, defects, exceptions, and emerging risks to inform leadership.
• Apply data validation, cleaning, reconciliation, and quality control techniques.
• Maintain documentation and evidence records with designated reviewers.
• Use Power BI, SQL, Excel, and Power Query to build and improve reports.
• Facilitate stakeholder discussions to gather requirements and align with business needs.
• Support reporting request management via ADO, SharePoint, and other tools.
• Assist with system administration, access governance, and security for reporting tools.
• Develop procedures and audit-ready materials; document data sources and calculations clearly.
• Identify reporting gaps and data quality issues; recommend improvements.
• Participate in modernization initiatives including automation and dashboard migration.
• Communicate findings and updates to technical and non-technical stakeholders.

Conoscenze

Power BI

SQL

Excel

Power Query

Data visualization

Data validation

Stakeholder management

Analytical thinking

Formazione

Bachelor's degree in Business Administration, Statistics, Data Analytics, or related field

Strumenti

SharePoint

ADO

Descrizione del lavoro

• Support Quality Control Risk Management by delivering accurate, timely, and actionable reporting and analytics for QCRM leaders, Real Estate Lending business partners, and audit or exam stakeholders.
• Maintain recurring reports and dashboards, validate reporting outputs, analyze trends and risks, support system administration activities, and translate business needs into clear reporting requirements.
• Create, refresh, validate, and distribute various recurring reports and dashboards including monthly QC reporting and management-level reports.
• Analyze QC results, trends, defects, exceptions, operational patterns, and emerging risks to inform leadership and support decision-making.
• Apply data validation, cleaning, reconciliation, and quality control techniques to ensure reporting accuracy and reliability.
• Maintain documentation, validation, approval, and evidence records in coordination with designated reviewers.
• Utilize business intelligence tools such as Power BI, SQL, Excel, and Power Query to build, troubleshoot, and improve reports.
• Facilitate stakeholder discussions to gather requirements, define audiences, confirm data sources, and align deliverables with business needs.
• Support reporting request management through tools such as ADO, SharePoint, and others.
• Assist with system administration, access governance, and security activities related to reporting tools.
• Develop and maintain procedures, technical documentation, and audit-ready support materials.
• Support audit, regulatory, and management requests by documenting data sources, calculations, and conclusions clearly and defensibly.
• Identify reporting gaps, data quality issues, and process inefficiencies, and recommend improvements.
• Participate in modernization initiatives including automation and dashboard migration.
• Communicate findings, risks, and report updates effectively to technical and non-technical stakeholders.

Requirements

• 2 to 5 years of experience in data analysis, reporting, or business intelligence
• Understanding of business operations, risk management, and reporting lifecycles
• Proficient with Power BI, SQL, Excel, Power Query, and data visualization tools
• Knowledge of data validation, reconciliation, and quality practices
• Strong analytical and troubleshooting skills with attention to detail
• Effective communication and stakeholder management skills
• Bachelor’s degree in Business Administration, Statistics, Data Analytics, or related field
• Experience supporting regulatory or audit reporting is a plus

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.