Business Intelligence & Automation Analyst

ECS is seeking a Business Intelligence & Automation Analyst to work remotely in the Washington, D.C. area to support a critical government client. The role involves designing and maintaining dashboards, providing technical support, and analyzing financial data to enhance decision making and operational efficiency.

Responsibilities:

• Design, develop, and maintain dashboards and reports in Power BI to empower the customer’s data driven decision making
• Collaborate with stakeholders to gather requirements and translate business needs into actionable data visualizations
• Provide technical support and training to end users on Power BI, and related tools
• Assist with data preparation, integration, and validation to ensure accuracy and reliability of financial reporting
• Expertise in development, implementation, and maintenance of ETL processes to ensure efficient and accurate integration of data from multiple sources
• Analyze and interpret financial data related to contracts, payroll, forecasting, and other functions
• Recommend process improvements and best practices for managing and reporting financial information
• Develop and automate processes using Excel, VBA, and other automation tools to enhance operational efficiency
• Support general IT and analytics tasks as needed, including ad hoc reporting and data analysis
• Document solutions, workflows, and user guides to enhance operational efficiency and knowledge sharing
• Stay current with new features and best practices in business intelligence, automation, and financial systems
• Must have experience delivering solutions using the software development life cycle

Requirements:

• Hands-on experience with Power BI, PowerApps, Tableau, and other analytics tools
• Strong background working with financial systems, especially within the federal government sector
• Experience delivering solutions using the software development life cycle
• Ability to design, develop, and maintain dashboards and reports in Power BI
• Experience collaborating with stakeholders to gather requirements and translate business needs into actionable data visualizations
• Technical support and training experience for end users on Power BI and related tools
• Experience with data preparation, integration, and validation to ensure accuracy and reliability of financial reporting
• Expertise in development, implementation, and maintenance of ETL processes
• Ability to analyze and interpret financial data related to contracts, payroll, forecasting, and other functions
• Experience recommending process improvements and best practices for managing and reporting financial information
• Ability to develop and automate processes using Excel, VBA, and other automation tools
• Support for general IT and analytics tasks, including ad hoc reporting and data analysis
• Experience documenting solutions, workflows, and user guides
• Ability to stay current with new features and best practices in business intelligence, automation, and financial systems