Software Developer (Maven/BI) (Secret Clearance Required)

Soilair Selection; O'Fallon (IL); Hybrid; USD 90,000 - 150,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Flexible schedule

401(k)

Job summary

Solerity is seeking a Software Developer to build professional dashboards using the Maven Analytics methodology. You will combine data modeling, data visualization, and business communication to deliver actionable insights for federal clients.

You will develop Power BI reports, craft Advanced SQL queries, and apply Python-based BI approaches to create interactive data applications. The role emphasizes storytelling, KPI measurement, and user-focused dashboard design.

Qualifications

• Secret Clearance (or eligible for one)
• Discipline with advanced data modeling and dashboard storytelling

Responsibilities

• Develop Power BI dashboards with robust relational data models and advanced DAX calculations
• Write performant SQL queries to cleanse and pull data from relational databases
• Build Python-based BI apps using Plotly, Dash, or Pandas
• Design dashboards with clear information hierarchy and contextual copywriting
• Apply measurement planning and KPI-driven storytelling for business audiences
• Leverage Excel for data cleaning, pivoting, and mock-up reporting

Skills

Secret Clearance

DAX

Dashboard storytelling

Tools

JavaScript

HTML & CSS

SQL

Python

Power Query

R

Job description

Description

Take the next steps to your professional success as Solerity is a recognized leader in providing Information Technology, Engineering Services, Program Management and Consulting Services to the U.S Federal Government and our Intel Community. We enable our clients to achieve their organizational initiatives through the application of high quality, innovative and cost-effective professional services, and solutions. Solerity needs your support to help us provide these solutions and continue our path as a recognized leader in providing resources for federal agencies and the Intel Community!

Solerity is seeking a Software Developer to develop professional dashboards using the Maven Analytics methodology. You will need a mix of structured data modeling, data visualization, and business communication skills. The Maven framework focuses heavily on solving business problems first before building any charts.

Job Description

• Power BI: Developing robust relational data models, creating complex custom analytics with Advanced Data Analysis Expressions (DAX), and publishing web apps via Power BI Service.
• Advanced SQL: Crafting performant queries to clean, filter, join, and pull raw data directly out of relational database engines.
• Python for BI: Using Plotly, Dash, or Pandas libraries to architect bespoke, highly interactive data applications.
• Dashboard design & Storytelling: Layout Structure, Visual Selection, Information Hierarch, Contextual Copywriting
• Strategic & Business Acumen: Measurement Planning, Problem-First mindset, Target Audience Focus
• Advanced Microsoft Excel: Standard formulas, data cleaning work, dynamic pivot tables, and mock-up reporting for early dashboard drafts.

Tools

• JavaScript
• HTML & CSS
• SQL (Structured Query Language)
• Python
• M Code (Power Query Formula Language)
• R: Preferred in scientific and research-heavy environments.

Requirements

• Secret Clearance (or eligible for one)
• 8140 requirement (one of these: CompTIA Security+, CySA+, CCNA, GICSP, CISSP, CISM, GSLC)

Desired Qualifications

• Layout Structure: Positioning high-priority revenue or KPI cards in prime real estate corners (like top-left) following normal reading flows.
• Visual Selection: Pairing accurate chart types (bar/column charts for categories, line charts for trends, scatterplots for variables) to the data.
• Information Hierarchy: Grouping metrics using enclosure boxes, removing duplicate axis labels, and starting high-level before introducing granular tables.
• Contextual Copywriting: Overwriting default dashboard chart titles with explicit, actionable observations that read cleanly like an analytical story.
• SQL: Writing queries to aggregate, filter, and join raw data tables.
• Data Cleansing: Profiling data, fixing null values, and formatting data types.
• Data Modeling: Building star schemas, managing table relationships, and handling data granularity.
• Calculations: Writing custom calculations for time-intelligence and complex KPIs.
• Dashboard Design & User Interface (UI)/ User Experience (UX)
• ggplot2
• Shiny web filter

Minimum Clearance:

Secret Clearance

Benefits You’ll Enjoy

• Medical, dental and vision coverage
• Health Savings Accounts and Flexible Spending Accounts for healthcare and dependent care
• Flexible work schedule to include onsite, hybrid or remote, as dictated by position
• 401(k) and company-funded life insurance
• Generous Paid Time Off (PTO)
• Tuition and training assistance
• Financial rewards for employee referrals.
• Pet insurance
• Employee discount program

EMPLOYMENT OPPORTUNITIES:

Solerity is committed to the range of perspectives we bring to the marketplace by being an employer dedicated to hiring a highly qualified team of professionals, providing world class services and products aimed at exceeding our customer’s expectations. Solerity is an equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities. Solerity is a VEVRAA Federal Contractor.

Job ID #368