Business Intelligence / Data Analyst at MAGNUS Management Group LLC in DC Fully Remote - US

Job description

• 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.

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.

Requirements

• 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.

Skills

Required

• Microsoft Power BI
• Tableau
• Salesforce
• SharePoint
• Microsoft Power Platform
• Power Automate
• Power Apps
• Excel
• Microsoft 365
• SQL
• Data analysis
• Data profiling

Benefits

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance
• Magnus Management Group offers a competitive, comprehensive benefits package, which includes:
• 3 Weeks Paid Time Off
• All Federal Holidays
• Medical, Dental, and Vision insurance
• 401K Retirement Plan
• Long Term Disability
• Tuition Reimbursement and Professional Development Support