Associate Data Analyst
Location: Remote
Clearance Level: Active Secret
Overview
Rackner is seeking an Associate Data Analyst to support the development, modernization, and maintenance of enterprise analytics and business intelligence solutions using Power BI and governed data sources within the Microsoft Fabric environment.
The Associate Data Analyst will develop dashboards, reports, semantic models, and data visualizations supporting education, workforce, financial, procurement, and operational analytics. This role will work with senior analysts, data engineers, governance teams, and Government stakeholders to translate reporting needs into reliable and user-friendly analytics products.
The Associate Data Analyst will also support dashboard migration, requirements gathering, documentation, training materials, and self-service analytics initiatives.
Responsibilities
- Develop dashboards, reports, and data visualizations using Microsoft Power BI
- Build analytics products using governed data sources from the Microsoft Fabric Lakehouse
- Build and maintain semantic models supporting standardized enterprise reporting
- Develop calculated measures, KPIs, and reusable analytical logic using DAX
- Use Power Query to prepare, transform, and validate data for analytics products
- Support implementation and maintenance of row-level security and workspace access controls
- Assist with dashboard and report migration from legacy environments to the modernized analytics platform
- Validate migrated dashboards to ensure data accuracy, functionality, and alignment with user requirements
- Develop and maintain analytics products supporting areas such as:
- Student outcomes and performance
- Assessment analytics
- Enrollment and demographic trends
- HR and workforce analytics
- Financial reporting
- Procurement and acquisition analysis
- Operational and administrative reporting
- Perform data analysis, validation, and reconciliation to identify inconsistencies or reporting issues
- Support development and maintenance of KPI frameworks and standardized reporting definitions
- Assist with self-service analytics enablement for business and operational users
- Support evaluation of Copilot-assisted analytics and other AI-enabled business intelligence capabilities
- Participate in requirements gathering sessions with Government and business stakeholders
- Document current-state reporting processes, data needs, and analytical requirements
- Translate stakeholder needs into analytics use cases, process flows, functional requirements, and acceptance criteria
- Support user acceptance testing and validation of dashboards and reporting products
- Develop user documentation, quick-reference guides, training materials, and other supporting documentation
- Assist with analytics demonstrations, training sessions, and user adoption activities
- Collaborate with Senior Data Analysts, Data Engineers, Data Governance Specialists, and source-system owners to resolve reporting and data issues
- Support troubleshooting of dashboard, semantic model, data quality, and access-control issues
- Maintain documentation for reports, data sources, business logic, KPIs, and analytics processes
- Follow established analytics, governance, visualization, and data quality standards
Qualifications
- Experience with Microsoft Power BI
- Experience developing dashboards, reports, and data visualizations
- Working knowledge of DAX and calculated measures
- Experience with Power Query or comparable data transformation tools
- SQL proficiency for querying, validating, and analyzing data
- Experience developing reports for diverse technical and non-technical user audiences
- Understanding of data visualization and dashboard design principles
- Ability to analyze data and identify trends, inconsistencies, and reporting issues
- Experience gathering or documenting business and reporting requirements
- Strong organizational, analytical, communication, and documentation skills
- Ability to work collaboratively with technical teams and business stakeholders
- Active Secret clearance
Preferred Qualifications
- Experience with Microsoft Fabric
- Experience working with Fabric Lakehouse data sources
- Experience building or maintaining Power BI semantic models
- Familiarity with row-level security and Power BI workspace permissions
- Experience supporting dashboard migrations or reporting modernization initiatives
- Familiarity with education data, student information systems, or education analytics
- Familiarity with federal reporting requirements or Government data environments
- Experience with student outcomes, assessment, enrollment, HR, financial, or procurement analytics
- Familiarity with self-service analytics concepts
- Exposure to Copilot-assisted analytics or other AI-enabled business intelligence tools
- Experience developing user guides, training materials, or analytics documentation
About Rackner
Rackner is a software consultancy focused on building mission-critical systems for the U.S. government. Our teams work across cloud platforms, DevSecOps, AI/ML, distributed systems, and modern software engineering initiatives supporting federal agencies and national security missions. Rackner engineers and technical teams collaborate closely with leadership, program teams, and mission stakeholders to design, demonstrate, and improve software systems that address complex operational challenges.
Benefits & Perks
At Rackner, we believe that when our people grow, our company grows with them, and we are committed to supporting their growth, development and success. We are proud to offer a creative and forward-thinking environment that includes:
• Company-supported certifications aligned to current and future program work,
including cloud, Kubernetes, DevSecOps, security, AI/ML, project management, and
related technical areas
• Clear advancement tracks and future leadership opportunities
• 401(k) with 100% match up to 6%
• Comprehensive medical, dental, vision, life, and disability coverage
• Generous PTO and paid holidays
• Home-office equipment plan and remote work support
• Fitness and wellness reimbursement
• Weekly pay schedule and modern perks, including team events
Equal Opportunity
Rackner is an equal opportunity employer and considers all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other protected characteristics.
