Ascension LLC is seeking a Data Analyst II / BI Developer to support the U.S. National Science Foundation (NSF), Office of the Chief Human Capital Officer (OCHCO) in advancing enterprise-wide workforce analytics and decision-making capabilities.

This role is critical to enabling NSF’s transition from manual, fragmented reporting to automated, governed, and self-service analytics that empower executives, HR specialists, and program staff with real-time insights.

The ideal candidate is a data-driven problem solver who thrives in a federal environment, understands workforce analytics, and can design dashboards and reporting solutions that directly influence strategic human capital decisions. This individual will play a key role in improving data quality, reporting efficiency, and user adoption of analytics tools across the organization.

Position Summary

The Data Analyst II / BI Developer will support NSF OCHCO and OCIO by designing, developing, and maintaining interactive dashboards, data models, and automated reporting solutions using tools such as Power BI and Tableau.

This role requires a highly analytical, detail-oriented professional who can work in a complex, multi-system environment, integrating HR data across platforms while ensuring accuracy, consistency, and governance. The candidate must be comfortable working with ambiguous requirements, engaging stakeholders, and translating business needs into actionable data products.

The ideal candidate is:

• Self-driven and capable of working independently with minimal supervision
• Skilled at anticipating data challenges and designing scalable solutions
• Experienced in federal HR/workforce analytics environments
• Adept at balancing multiple priorities and delivering high-quality outputs under tight timelines

This role directly supports NSF’s goal to:

• Reduce manual reporting burden
• Improve data governance and quality
• Enable role-based, self-service analytics
• Deliver measurable improvements in decision-making and operational efficiency

Day-to-Day Responsibilities

• Develop interactive dashboards and reports using Power BI, Tableau, or Oracle Analytics Server (OAS)
• Analyze workforce and HR datasets to identify trends, anomalies, and actionable insights
• Design and maintain semantic data models to support enterprise reporting
• Automate recurring reports and data pipelines to reduce manual effort
• Collaborate with stakeholders to gather requirements and translate them into analytics solutions
• Perform data validation, cleansing, and quality checks to ensure 98%+ data accuracy targets
• Create data visualizations that clearly communicate insights to executive leadership
• Support development of predictive workforce analytics models
• Maintain documentation for dashboards, data sources, and reporting processes
• Support SharePoint or enterprise platforms for report distribution and access management
• Participate in continuous process improvement initiatives to enhance reporting efficiency
• Respond to ad hoc data requests and reporting needs