Cleared PowerBI Analyst (5674)

SMX; Helena (MT); On-site; USD 90,000 - 165,000; Full time

Job summary

SMX is seeking a Power BI developer to support our federal customer’s multi-domain technology platform, delivering interactive reports and dashboards across a secure environment.

The role requires 4+ years in Power BI, experience with data modeling, DAX, and Power Query, and a current Secret security clearance; salary range listed is $90,000–$165,200 USD.

Qualifications

• Bachelor’s degree or equivalent experience.
• 4+ years of experience with Power BI.
• 4 years of experience in big data and cloud environment.
• Current, valid Secret security clearance.
• Excellent verbal and written communication skills.

Responsibilities

• Design and develop Power BI reports and dashboards.
• Create data models, DAX, KPIs and calculated columns.
• Manage Power BI workspaces, security and data refresh schedules.
• Connect Power BI to databases, spreadsheets, APIs and online services.
• Draft requirements, SOPs and client-facing documentation.
• Collaborate in a team and share knowledge with peers.
• Troubleshoot totals, filters, relationships and refresh issues.

Skills

Power BI

Data modeling

DAX

KPIs

Data visualization

Power BI Service

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