Job Summary:
The Data Science & Automation Analyst develops advanced data-driven solutions to support organizational decision-making, operational tracking, and process automation. This role focuses on transforming loosely defined business needs into scalable analytics tools, automated workflows, and integrated data systems. By leveraging Power Platform technologies and data modeling techniques, the analyst enables real-time visibility into critical initiatives, ensures accountability across stakeholders, and improves overall program performance through intelligent automation and reporting.
Key Responsibilities: Data Analytics & Visualization Design and develop advanced Power BI dashboards to track organizational objectives, performance metrics, and operational data
Convert static reporting artifacts into dynamic, interactive visualizations with filtering and drill-down capabilities
Implement data models that connect SharePoint lists and other data sources to reporting tools
Develop visual elements such as maps, gauges, and KPI indicators to support executive-level insights
Data Engineering & Integration Build and maintain structured data environments using SharePoint lists and integrated data sources
Establish data relationships, unique identifiers, and tracking mechanisms to monitor projects and initiatives over time
Ensure data accuracy, consistency, and synchronization across platforms and workflows
Workflow Automation Develop automated workflows using Power Automate to manage data intake, approvals, and status tracking
Configure triggers, alerts, and notifications to ensure timely updates and stakeholder accountability
Maintain and enhance workflows to support evolving business processes
Application Development Design and implement data collection tools and forms that consolidate inputs from multiple stakeholders into unified systems
Build scalable solutions that support multiple users, departments, and data streams within a single interface
Maintain and optimize applications for usability, performance, and reliability
Program Tracking & Performance Monitoring Develop systems to track infrastructure projects, procurement efforts, and other critical initiatives
Monitor project status, identify gaps or delays, and enable proactive follow-up through automated alerts
Provide centralized visibility into program execution for leadership and stakeholders
Stakeholder Collaboration & Requirements Translation Engage with stakeholders to interpret high-level or ambiguous requirements and translate them into technical solutions
Conduct requirement analysis, ask clarifying questions, and iterate on solutions based on feedback
Deliver solutions that align with operational needs and improve user experience
Maintenance & Continuous Improvement Perform ongoing maintenance of dashboards, workflows, and applications, including updates to data structures and logic
Troubleshoot technical issues and optimize system performance
Continuously identify opportunities to enhance automation, reporting, and data accessibility
Minimum Requirements: Active DoD Secret Clearance.
Bachelor’s degree in Data Science, Computer Science, Information Systems, Analytics, or related field (or equivalent experience)
3+ years of experience in data analytics, automation, or business intelligence
Hands-on experience with Microsoft Power Platform (Power BI, Power Automate, Power Apps)
Experience working with SharePoint or similar data storage and collaboration tools
Strong analytical and problem-solving skills with the ability to work from ambiguous requirements
Experience designing data models and building interactive dashboards
Ability to manage multiple projects and deliver solutions in a fast-paced environment
Preferred Qualifications: Experience with data modeling, ETL concepts, or data pipeline design
Familiarity with HTML or other scripting languages for enhanced visualization capabilities
Experience developing enterprise-level tracking systems and performance…