Cleared PowerBI Analyst (5674)

SMX; Cheyenne (WY); On-site; USD 90,000 - 165,000; Full time

Job summary

SMX is seeking a Power BI developer to support a federal customer’s multi-domain technology platform, delivering structured analytics and interactive dashboards for decision makers and analysts across the organization.

You will specialize in Power BI modeling, DAX, visuals, data sources integration, and reporting administration, ensuring secure, scalable analytics in a DoD-aligned environment. Strong communication and collaboration with the client team are expected.

Qualifications

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

Responsibilities

• Expertise in Power BI data modeling, DAX, calculated columns, measures and KPIs.
• Build interactive reports, dashboards, and visualizations using Power BI Desktop.
• Administer Power BI tasks such as 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 diverse data sources (databases, spreadsheets, APIs).
• Publish and share reports in Power BI Service and enable collaboration.
• Design intuitive dashboards for different user needs.
• Use Power Query for data import, cleaning, transforming, merging, and appending.
• Troubleshoot totals, filters, relationships, refresh failures, and source changes.
• Draft requirements, designs, SOPs, training, and other client documentation.
• Collaborate in a team and learn from senior colleagues.

Skills

Power BI

Data modeling

DAX

Power BI Desktop

Power BI Service

Power Query

Dashboard design

Data sources integration

Verbal & written communication

Education

Bachelor’s degree or equivalent experience

Tools

Power BI

SQL

Job description

SMX is seeking a Power BI developer to support our federal customer's multi-domain technology platform which offers military and business decision makers, analysts, and users at all levels unprecedented access to authoritative enterprise data and structured analytics in a scalable, reliable, and secure environment.

Essential Duties and Responsibilities:

• Expertise in Power BI, including data modeling, DAX, creating calculated columns, measures, and KPIs.

• Proficiency in building interactive reports, dashboards, and visualizations using Power BI Desktop.

• Knowledge of Power BI administration tasks such as managing workspaces, security, and data refresh schedules.

• Strong understanding of data analysis concepts and methodologies, translating complex data into clear, actionable insights through visualization.

• Proficiency in creating custom visuals and advanced visualizations for storytelling and data exploration.

• Ability to connect Power BI to various data sources, including databases, spreadsheets, APIs, and online services.

• Experience with Power BI Service for publishing, sharing, and collaborating on reports and dashboards.

• Designing intuitive and interactive dashboards tailored to different user requirements.

• Familiarity with Power Query to include importing, cleaning, transforming, merging and appending data

• Ability to troubleshoot incorrect totals, filters, relationships, refresh failures, and changing source columns

• Draft requirements, designs, SOPs, training, and other documentation for client use. This requires a good eye for grammar and readability.

• Work in a team environment and be eager to learn from more experienced co-workers and subject-matter experts.

• Communicate in a polished and professional manner with management and clients.

Required Skills and Experience:

• 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

• Possession of excellent verbal and written communication skills

• Ability to display a positive, can-do attitude to solve the challenges of tomorrow

Desired Skills and Experience:

• Preferred: GFEBS experience and/or experience with Army financials

The SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

The proposed salary for this position is:

$90,000—$165,200 USD

At SMX, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.

We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.

SMX is an Equal Opportunity employer including disabilities and veterans.

Selected applicant may be subject to a background investigation and/or education verification.

SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).