Senior Data & Business Intelligence Analyst

Modern Technology Solutions, Inc.; Dayton (OH); Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Great benefits

Employee Stock Ownership Plan (ESOP)

Job summary

Modern Technology Solutions, Inc. (MTSI) seeks a Senior Data & Business Intelligence Analyst to join the Digital Data Services team. This role is 100% remote and requires US citizenship.

The analyst will design and maintain Power BI products, leverage SQL, DAX, and Power Query, and partner with business leaders to turn data into actionable insights. Responsibilities include building scalable analytics, supporting data governance, and driving self-service analytics adoption across enterprise

Qualifications

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

Responsibilities

• Partner with stakeholders to clarify business questions, gather requirements, define KPIs, and translate needs into analytics solutions.
• Lead analytics and reporting from discovery through deployment, including scope, milestones, testing, stakeholder reviews, and adoption support.
• Design, develop, and maintain Power BI dashboards, reports, models, scorecards, and paginated reports.
• Ensure data quality, governance, lineage, and reporting reliability; promote reuse and consolidate legacy reporting.
• Support enablement of self-service analytics across the organization.

Skills

Power BI

DAX

Power Query

SQL

KPIs definition

Requirements gathering

Stakeholder communication

Education

Bachelor's degree or equivalent

Tools

Microsoft Fabric

Azure data services

SQL Server

APIs

Job description

We are currently seeking to hire a Senior Data & Business Intelligence Analyst to join the Digital Data Services team within the Information Technology department.

This role is 100% remote and requires US Citizenship. Candidate must reside near an MTSI office in Huntsville Alabama, Alexandria, Virginia, Dayton, Ohio, or Colorado Springs, Colorado.

The Data & Business Intelligence Analyst turns enterprise data into trusted, actionable insight. This role partners with business leaders, program teams, and technical stakeholders to define meaningful measures, develop scalable reporting solutions, and improve how the organization uses data to make decisions. The analyst designs and maintains Power BI products, supports modern Microsoft data platforms, strengthens data quality and governance, and helps users confidently adopt self-service analytics.

Why Join Us?

At MTSI, you'll work alongside experienced professionals to drive meaningful change through data. You'll have opportunities to lead, mentor, and innovate, all while contributing to projects that shape organizational strategy and success. We foster a culture of collaboration, growth, and data-driven decision-making.

Key Responsibilities:

Business Partnership & Analytics Delivery

• 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.

Business Intelligence Products

• 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.

Data Integration, Quality & Governance

• 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.

Automation, AI & Continuous Improvement

• 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.

Enablement & Team Contribution

• 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.

Qualifications:

Education and Experience:

• 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.

Required Clearance:

Must be able to obtain Secret Clearance: US Citizenship required.

Required Skills:

• 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.

Desired Skills

• 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

#LI-AT1

Interesting Work:

Our co-workers support some of the most important and critical programs to our national defense and security.

Values:

Our first core value is that employees come first. We challenge our co-workers to provide the highest level of support and service, and reward them with some of the best benefits in the industry.

100% Employee Owned:

We have a stake in each other's success, and the success of our customers. It's also nice to know what's going on across the company; we have company wide town-hall meetings three times a year.

Great Benefits - Most Full-Time Staff Are Eligible for:

• Starting PTO accrual of 20 days PTO/year + 10 holidays/year
• Flexible schedules
• 6% 401k match with immediate vesting up to $9k annually
• Semi-annual bonus eligibility (July and December)
• Company funded Employee Stock Ownership Plan (ESOP) - a separate qualified retirement account
• Up to $10,000 in annual educational reimbursement
• Other company funded benefits, like life and disability insurance
• Optional zero deductible Blue Cross/Blue Shield health insurance plan

Track Record of Success:

We have grown every year since our founding in 1993.

Modern Technology Solutions, Inc. (MTSI) is a 100% employee-owned engineering services and solutions company that provides high-demand technical expertise in Digital Transformation, Modeling and Simulation, Rapid Capability Development, Test and Evaluation, Artificial Intelligence, Autonomy, Cybersecurity and Mission Assurance

MTSI delivers capabilities to solve problems of global importance. Founded in 1993, MTSI today has employees at over 20 offices and field sites worldwide.

For more information about MTSI, please visit www.mtsi-va.com

MTSI embraces nine core values including our first core value of Employees come first. Consistent with our Core Values, we are committed to Equal Opportunity, making decisions without regard to race, color, religion, sex, national origin, age, military/veteran status, disability, or any other characteristics protected by applicable law. MTSI is committed to Equal Employment Opportunity and providing reasonable accommodations to applicants and employees with physical and/or mental disabilities.