[Remote] Associate Data Analyst
Note: The job is a remote job and is open to candidates in USA. Rackner is a software consultancy focused on building mission-critical systems for the U.S. government. The Associate Data Analyst will develop, modernize, and maintain enterprise analytics and business intelligence solutions using Power BI and Microsoft Fabric, while supporting dashboard migration, requirements gathering, documentation, training, 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
Skills
- • 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
- • 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
Benefits
- 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
Company Overview