Remote Senior BI & Data Analytics Lead

Modern Technology Solutions, Inc.; Colorado Springs (CO); Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

PTO 20 days

Holidays

ESOP

Educational reimbursement up to $10k

Flexible schedules

Medical benefits

Job summary

Modern Technology Solutions, Inc. is seeking a Senior Data & Business Intelligence Analyst to join our Digital Data Services team within the Information Technology department.

This 100% remote role requires US Citizenship and proximity to an MTSI office in Huntsville AL, Alexandria VA, Dayton OH, or Colorado Springs CO. Responsibilities include designing and maintaining Power BI dashboards, ensuring data quality and governance, and delivering analytics that support strategic decisions across

Qualifications

• At least 5 years of BI, data analysis, or related experience.
• Experience developing Power BI reports and dashboards using DAX and Power Query.
• Strong SQL skills in Microsoft SQL Server.
• Experience defining KPIs and translating business needs into analytics specifications.
• Knowledge of relational data, dimensional modeling, and data warehousing.

Responsibilities

• Partner with stakeholders to clarify business questions, gather requirements, define KPIs, and translate needs into analytics solutions.
• Lead 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 with effective information design, 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 retirement or consolidation of redundant reporting.

Skills

Analytical thinking

Communication

Stakeholder collaboration

Data storytelling

Problem-solving

Education

Bachelor's degree or equivalent experience

Tools

Power BI

DAX

Power Query

SQL Server

Azure Data Services

APIs

Microsoft Fabric

Job description

Modern Technology Solutions, Inc. is seeking a Senior Data & Business Intelligence Analyst to join our Digital Data Services team within the Information Technology department.

This 100% remote role requires US Citizenship and proximity to an MTSI office in Huntsville AL, Alexandria VA, Dayton OH, or Colorado Springs CO. Responsibilities include designing and maintaining Power BI dashboards, ensuring data quality and governance, and delivering analytics that support strategic decisions across