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

Solerity; O'Fallon (IL); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical coverage

Vision coverage

Dental coverage

401(k) plan

Flexible schedule

Paid Time Off

Tuition assistance

Referral bonuses

Pet insurance

Employee discounts

Job summary

Solerity is hiring a Software Developer to create professional dashboards using the Maven Analytics methodology. You will model data, visualize insights, and communicate business intent effectively for federal and Intel community projects.

Responsibilities include Power BI development, advanced SQL querying, and Python-based BI applications. A strong emphasis on storytelling, data quality, and stakeholder alignment drives the role.

Qualifications

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

Responsibilities

• Power BI: develop relational data models and publish web apps via Power BI Service.
• Advanced SQL: craft performant queries to extract data from relational databases.
• Python for BI: use Plotly, Dash, or Pandas for interactive data apps.
• Dashboard design and storytelling with clear information hierarchy.
• Measurment planning and audience-focused analytics.

Skills

Power BI

SQL

Python

Excel

Tools

JavaScript

HTML & CSS

SQL

Python

M Code

R

Job description

DescriptionTake 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!

Job Type Full-time

DescriptionTake 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.
• Dashboard Design & Storytelling

Tools

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

Requirements Required Skills, and Abilities:

• 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