Business Intelligence Data Analyst

Magnus Management Group LLC; Washington (District of Columbia); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

401(k)

Dental insurance

Health insurance

Paid time off

Vision insurance

Job summary

Magnus Management Group LLC is seeking an experienced BI/Data Analyst to develop and maintain enterprise dashboards, perform data analysis, automate reporting, and improve data quality. The role collaborates closely with business stakeholders to translate requirements into reports and data-driven solutions for executive decision-making.

You will design dashboards with Power BI, Tableau, Salesforce, SharePoint, and Power Platform; analyze operational and financial data to identify trends and

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.
• Minimum 5 years of experience in BI, data analytics, reporting, or data management.
• Experience designing and developing enterprise dashboards and executive reporting solutions.
• Experience gathering business requirements and translating them into technical reporting solutions.
• Experience performing data analysis, data profiling, and data quality management.
• Experience documenting business processes, workflows, and data flows.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Design, develop, deploy, and maintain dashboards and reports using Power BI, Tableau, Salesforce, SharePoint, and Power Platform.
• Analyze operational, financial, project, contract, and security data to identify trends, patterns, risks, and opportunities.
• Develop automated reporting solutions using Power BI, Power Automate, Power Apps, Excel, and Microsoft 365 technologies.
• Establish and implement best practices for enterprise data management, governance, reporting, and data stewardship.
• Perform data cleansing, validation, transformation, reconciliation, and quality assurance to ensure data integrity.
• Develop ad hoc reports, executive dashboards, scorecards, KPIs, and performance metrics supporting organizational objectives.
• Gather and document business requirements through stakeholder interviews, workshops, and meetings.
• Document business processes, workflows, and data flows using process maps and visual diagrams.
• Maintain inventories of enterprise data sources, reporting systems, and business processes.
• Automate manual reporting and data processing activities to improve operational efficiency.
• Perform SQL queries, data extraction, analysis, and reporting from multiple enterprise data repositories.
• Support ongoing enhancements to dashboards, reports, and enterprise reporting solutions.
• Collaborate with business owners to identify reporting improvements and recommend data-driven solutions.
• Present analytical findings and reporting solutions to technical and non-technical stakeholders.
• Support continuous process improvement initiatives by recommending innovative reporting and analytics solutions.

Skills

Analytical skills

Problem solving

Communication

Stakeholder collaboration

Data governance

Education

Bachelor's degree in Computer Science / Information Systems / Data Analytics

Tools

Power BI

Tableau

Salesforce

SharePoint

Power Platform

Power Automate

Power Apps

Excel

SQL

Job description

Benefits

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Overview

We are seeking an experienced Business Intelligence (BI) / Data Analyst to support our client. The successful candidate will develop and maintain enterprise dashboards, perform data analysis, automate reporting processes, improve data quality, and support data governance initiatives. This role requires close collaboration with business stakeholders to translate operational requirements into meaningful reports, dashboards, process documentation, and data-driven solutions that support executive decision-making.

Key Responsibilities

• Design, develop, deploy, and maintain interactive dashboards and reports using Microsoft Power BI, Tableau, Salesforce, SharePoint, and Microsoft Power Platform.
• Analyze operational, financial, project, contract, and security data to identify trends, patterns, risks, and business opportunities.
• Develop automated reporting solutions using Power BI, Power Automate, Power Apps, Excel, and Microsoft 365 technologies.
• Establish and implement best practices for enterprise data management, governance, reporting, and data stewardship.
• Perform data cleansing, validation, transformation, reconciliation, and quality assurance activities to ensure data integrity.
• Develop ad hoc reports, executive dashboards, scorecards, KPIs, and performance metrics supporting organizational objectives.
• Gather and document business requirements through stakeholder interviews, workshops, and meetings.
• Document business processes, workflows, system processes, and data flows using process maps and visual diagrams.
• Maintain inventories of enterprise data sources, reporting systems, and business processes.
• Automate manual reporting and data processing activities to improve operational efficiency.
• Perform SQL queries, data extraction, analysis, and reporting from multiple enterprise data repositories.
• Support ongoing enhancements to dashboards, reports, and enterprise reporting solutions.
• Collaborate with business owners to identify reporting improvements and recommend data-driven solutions.
• Present analytical findings and reporting solutions to technical and non-technical stakeholders.
• Support continuous process improvement initiatives by recommending innovative reporting and analytics solutions.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Information Technology, Statistics, Mathematics, or a related field.
• Minimum 5 years of experience in Business Intelligence, Data Analytics, Reporting, or Data Management.
• Experience designing and developing enterprise dashboards and executive reporting solutions.
• Experience gathering business requirements and translating them into technical reporting solutions.
• Experience performing data analysis, data profiling, and data quality management.
• Experience documenting business processes, workflows, and data flows.
• Strong analytical, problem-solving, and communication skills.
• Experience supporting Federal Government clients is preferred.

This is a remote position.