Remote BI Data Analyst | Dashboards & Automation

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

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