Senior Data & Business Intelligence Analyst

Modern Technology Solutions, Inc. (MTSI)

. Partner with enterprise stakeholders to clarify business questions, gather requirements, define KPIs, and develop analytics solutions .

Posted 10/30/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in developing and enhancing Power BI dashboards and reports, utilizing DAX and SQL for data analysis and visualization. Proficient in gathering requirements, defining KPIs, and ensuring data quality while adhering to governance and security standards.

Highest-signal resume keywords

Power BI Dashboard DevelopmentDAX ProficiencySQL Server ExperienceData Warehousing KnowledgeBusiness Intelligence Expertise

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisReportingKPI DefinitionETL ConceptsDimensional ModelingData Visualization PracticesData Quality ValidationAd Hoc AnalysisData Integration ProcessesBusiness Operations

Soft Skills

CommunicationCollaborationProblem-SolvingTrainingDocumentation

Tools & Technologies

Power BIPower QueryMicrosoft FabricAzure Data ServicesSQL ServerPower AutomateAPIsMicrosoft SharePoint

Certifications & Qualifications

Power BI Data Analyst Associate

Industry Keywords

Business IntelligenceData GovernanceOperational AnalyticsRegulated Data EnvironmentsEnterprise Systems Integration

Tech Stack

Tools & technologies

AzureETLMS SQL ServerPythonSQL

About the role

Key responsibilities & impact

Partner with enterprise stakeholders to clarify business questions, gather requirements, define KPIs, and develop analytics solutions
Lead analytics and reporting projects from discovery through deployment, including scope, milestones, testing, documentation, and adoption support
Analyze trends, performance drivers, and operational results and communicate decision-oriented findings
Provide ad hoc analysis and convert recurring requests into governed, reusable solutions
Design, develop, maintain, and enhance Power BI dashboards, reports, semantic models, scorecards, and paginated reports
Prepare, model, validate, and present enterprise data using DAX, Power Query, SQL, and related tools
Monitor report accuracy, refresh reliability, usability, and performance; troubleshoot and improve products
Curate the enterprise report catalog and retire or consolidate redundant reporting
Build and maintain reporting datasets and dimensional models using data warehouse practices
Work with Microsoft Fabric, Azure data services, SQL Server, APIs, and data integration processes
Validate data quality and follow governance, security, privacy, records, and access-control requirements
Document data lineage, report logic, business rules, data definitions, dependencies, and support procedures
Use Power Automate and approved AI-assisted analytics capabilities to streamline workflows and enhance reporting
Evaluate Microsoft data ecosystem capabilities and recommend practical improvements
Provide training and support for self-service analytics users
Participate in peer reviews, testing, knowledge sharing, cross-training, backup coverage, and team standards

Requirements

What you’ll need

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 able to obtain Secret Clearance
US Citizenship required
Hands-on experience developing Power BI reports and dashboards
Working knowledge of DAX, Power Query, semantic models, and data visualization practices
Working proficiency in SQL, 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
Relevant Microsoft certification, such as Power BI Data Analyst Associate, is desired
Desired experience with Python, R, version control, collaboration, work tracking, release practices, executive reporting, enterprise KPI development, financial or operational analytics, regulated data environments, and Microsoft SharePoint

Benefits

Comp & perks

New hires accrue 20 days of PTO and 10 holidays per year
Zero deductible health insurance plans
Flexible schedules
Up to $10,000 annual education/training reimbursement
Company-funded Employee Stock Ownership Plan (ESOP)
6% 401(k) match with immediate vesting
Semi-annual bonus opportunity
Career mentorship programs
Life and disability insurance
100% employee-owned company