Secret-Cleared Power BI Analyst for Federal Dashboards

SMX; Madison (WI); On-site; USD 90,000 - 165,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement plan

Job summary

SMX is seeking a Power BI developer to support our federal customer’s multi-domain technology platform, delivering authoritative analytics for decision makers at all levels. The role requires 4+ years of Power BI experience, a current Secret security clearance, and a background in big data and cloud environments.

You will build reports, dashboards, and visuals, connect diverse data sources, and document designs and SOPs for client use.

Qualifications

• Current, valid Secret security clearance
• Bachelor’s degree or equivalent experience
• 4+ years of experience with Power BI
• 4 years of experience working in a big data and cloud environment
• Excellent verbal and written communication skills
• Positive, can-do attitude to solve challenges

Responsibilities

• Expertise in Power BI data modeling, DAX, calculated columns, measures, and KPIs.
• Build interactive reports, dashboards, and visualizations using Power BI Desktop.
• Admin tasks: managing workspaces, security, and data refresh schedules.
• Translate complex data into clear insights through visualization.
• Create custom visuals and advanced visualizations for storytelling.
• Connect Power BI to databases, spreadsheets, APIs, and online services.
• Publish and collaborate on reports via Power BI Service.
• Design intuitive dashboards tailored to user requirements.
• Work with Power Query to import, clean, transform, merge, and append data.
• Troubleshoot totals, filters, relationships, and source changes.
• Draft requirements, designs, SOPs, training, and client documentation.
• Collaborate in a team and learn from subject-matter experts.
• Communicate professionally with management and clients.

Skills

Power BI

DAX

Data modeling

KPIs

Power BI Desktop

Power BI Service

Power Query

Visualization

Education

Bachelor’s degree or equivalent experience

Tools

Power BI Desktop

Power BI Service

Power Query

Job description

SMX is seeking a Power BI developer to support our federal customer’s multi-domain technology platform, delivering authoritative analytics for decision makers at all levels. The role requires 4+ years of Power BI experience, a current Secret security clearance, and a background in big data and cloud environments.

You will build reports, dashboards, and visuals, connect diverse data sources, and document designs and SOPs for client use.