Software Developer (Maven/BI) (Secret Clearance Re

at Preferred Systems Solutions, Inc in O'Fallon, Illinois, United States

Job Description

Job Type
Full-time
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.
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:
1. Medical, dental and vision coverage
2. Health Savings Accounts and Flexible Spending Accounts for healthcare and dependent care
3. Flexible work schedule to include onsite, hybrid or remote, as dictated by position
4. 401(k) and company-funded life insurance
5. Generous Paid Time Off (PTO)
6. Tuition and training assistance
7. Financial rewards for employee referrals.
8. Pet insurance
9. 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.

APPLY TODAY!

Job ID #368

PSS is committed to the diversity we bring to the marketplace by being an EEOC/AA employer who is committed to hiring a diverse team of professionals to provide world class services and products aimed at exceeding our customer’s expectations. All qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, protected veteran status or disability. PSS is a VEVRAA Federal Contractor.