Senior Data & Business Intelligence Analyst

Modern Technology Solutions Inc•Dayton, OH

5d•Remote

About The Position

The Senior Data & Business Intelligence Analyst joins the Digital Data Services team within the Information Technology department. The role turns enterprise data into trusted, actionable insight by partnering with business leaders, program teams, and technical stakeholders to define measures, develop scalable reporting solutions, and improve data-informed decision-making. The position is 100% remote, requires U.S. citizenship, and requires candidates to reside near an MTSI office in Huntsville, Alabama; Alexandria, Virginia; Dayton, Ohio; or Colorado Springs, Colorado. The analyst designs and maintains Power BI products, supports Microsoft data platforms, strengthens data quality and governance, and helps users adopt self-service analytics. The role leads analytics and reporting work from discovery through deployment, delivers clear analysis to support decisions, and maintains datasets and dimensional models. It also supports automation, approved AI-assisted analytics, user enablement, documentation, and continuous improvement across analytics services.

Requirements

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.
Must be a U.S. citizen and able to obtain Secret Clearance.
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, and organization.
Ability to manage work independently while collaborating across teams.
Excellent written, verbal, and visual communication skills, including ability to explain technical concepts to non-technical audiences.
Must reside near an MTSI office in Huntsville, Alabama; Alexandria, Virginia; Dayton, Ohio; or Colorado Springs, Colorado.

Nice To Haves

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 or visualization assets.
Strong communication skills and ability to convey technical concepts to non-technical audiences.
Collaborative mindset and ability to work independently and as part of a team.

Responsibilities

Partner with enterprise stakeholders 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, and communicate findings clearly to support decisions.
Provide ad hoc analysis and identify 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, accessible, consistent, audience-appropriate visual experiences and data 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 improve high-value products.
Curate the enterprise report catalog, promote reuse, and support retirement or consolidation of redundant and legacy reports.
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 accuracy, completeness, consistency, and appropriate use before release to business users.
Follow data governance, security, privacy, records, and access-control requirements; 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 capabilities across Power BI, Microsoft Fabric, and the broader Microsoft data ecosystem, and 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 to help 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.