Senior Data & Business Intelligence Analyst

Location: remote, Huntsville, AL, USA, Alexandria, VA, USA, Dayton, OH, USA, Colorado Springs, CO, USA

Work Location: remote local

• Partner with stakeholders across the enterprise to clarify business questions, gather requirements, define KPIs, and translate needs into practical analytics solutions.
• Lead assigned analytics and reporting work from discovery through deployment, including scope, milestones, testing, stakeholder review, documentation, and adoption support.
• Analyze trends, performance drivers, and operational results, then communicate findings in a clear and decision-oriented manner.
• Provide responsive ad hoc analysis while identifying opportunities to convert recurring requests into governed, reusable solutions.

• Design, develop, maintain, and enhance Power BI dashboards, reports, semantic models, scorecards, and paginated reports.
• Create intuitive visual experiences using sound information design, accessible layouts, consistent definitions, and audience-appropriate storytelling.
• Use DAX, Power Query, SQL, and related tools to prepare, model, validate, and present data from enterprise sources.
• Monitor report accuracy, refresh reliability, usability, and performance; troubleshoot issues and continuously improve high-value products.
• Curate the enterprise report catalog, promote reuse, and support the retirement or consolidation of redundant and legacy reporting.

• Build and maintain reporting datasets and dimensional models using data warehouse practices such as facts, dimensions, and star schemas.
• Work with Microsoft Fabric, Azure data services, SQL Server, APIs, and existing data integration processes to support scalable analytics.
• Validate data for accuracy, completeness, consistency, and appropriate use before release to business users.
• Follow enterprise data governance, security, privacy, records, and access-control requirements; clearly document limitations and approved definitions.
• Document data lineage, report logic, business rules, data definitions, technical dependencies, and support procedures.

• Use Power Automate and platform-native capabilities to streamline repeatable reporting and notification workflows where appropriate.
• Apply approved AI-assisted analytics capabilities, including Copilot-enabled features, natural-language summaries, anomaly detection, and explanatory visuals, with human validation and governance controls.
• Evaluate emerging capabilities across Power BI, Microsoft Fabric, and the broader Microsoft data ecosystem; share practical recommendations, patterns, and reusable assets.
• Identify reporting and workflow inefficiencies and partner with business and technical teams to implement measurable improvements.

• Provide guidance, training, and support that helps business users interpret data and use self-service analytics effectively.
• Participate in peer reviews, testing, knowledge sharing, cross-training, and backup coverage for essential analytics services.
• Contribute to team standards for development, version control, release management, documentation, and analytics quality.

• Bachelor's degree in data analytics, information systems, computer science, statistics, mathematics, economics, finance, business, or a related field; equivalent relevant experience may be considered.
• At least 5 years of experience in business intelligence, data analysis, reporting, business operations, or a related discipline.

• Hands-on experience developing Power BI reports and dashboards, including working knowledge of DAX, Power Query, semantic models, and data visualization practices.
• Working proficiency in SQL for data retrieval, validation, troubleshooting, and reporting, preferably in a Microsoft SQL Server environment.
• Experience gathering requirements, defining KPIs, testing outputs, documenting solutions, and translating business needs into technical specifications.
• Understanding of relational data, dimensional modeling, data warehousing, ETL or ELT concepts, and enterprise systems integration.
• Strong analytical judgment, attention to detail, organization, and ability to manage work independently while collaborating across teams.
• Excellent written, verbal, and visual communication skills, including the ability to explain technical concepts to non-technical audiences.

• Advanced Power BI data modeling, DAX, Power Query, report performance optimization, or paginated reporting experience.
• Experience with Python, R, or another analytics language for data preparation, automation, forecasting, or advanced analysis.
• Familiarity with version control, collaboration, work tracking, and release practices.
• Experience supporting executive reporting, enterprise KPI development, financial or operational analytics, or regulated data environments.
• Relevant Microsoft certification, such as Power BI Data Analyst Associate
• Experience with Microsoft SharePoint for content and knowledge management.
• Strength in process documentation and creating reusable analytic/visualization assets.
• Strong communication skills, with the ability to convey technical concepts to non-technical audiences
• Collaborative mindset; able to work independently and as part of a team