Cleared PowerBI Analyst (5674)

SMX; Columbus (OH); On-site; USD 90,000 - 165,000; Full time

Job summary

SMX is seeking a Power BI developer to support a federal customer with a multi-domain technology platform for decision-makers and analysts.

You will build interactive reports, dashboards, and visualizations, modeling data and implementing KPIs while collaborating with team members and stakeholders. A Secret clearance and strong communication are required.

Qualifications

• Active Secret security clearance required.
• 4+ years of experience with Power BI.
• 4+ years of experience in big data and cloud environments.
• Excellent verbal and written communication.
• Ability to work in a team and learn from others.

Responsibilities

• Develop and maintain Power BI reports and dashboards.
• Model data, create DAX measures and KPIs.
• Administer Power BI workspaces and data refresh schedules.
• Translate data into actionable insights via visualizations.
• Create custom visuals for storytelling.
• Connect Power BI to databases, APIs, and spreadsheets.
• Publish and share reports in Power BI Service.
• Draft client-facing docs and SOPs.
• Collaborate with team and communicate professionally.

Skills

Power BI

Data modeling

DAX

KPIs

Report building

Dashboard design

Data visualization

Communication skills

Teamwork

SOP drafting

Education

Bachelor’s degree or equivalent experience

Tools

Power BI Desktop

Power BI Service

Power Query

SQL databases

APIs

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