Jobs · Engineering · Illinois

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

Solerity · O'Fallon, IL · 1 wk ago
EngineeringFull-time

Take the next steps to your professional success at Solerity, a recognized leader in providing Information Technology, Engineering Services, Program Management, and Consulting Services to the U.S. Federal Government and the Intelligence Community. We enable clients to achieve organizational initiatives through high-quality, innovative, and cost-effective professional services and solutions.

About the role

Solerity is seeking a Software Developer to develop professional dashboards using the Maven Analytics methodology. This role requires a mix of structured data modeling, data visualization, and business communication skills. The Maven framework emphasizes solving business problems first before building any charts.

Responsibilities

  • Power BI: Develop robust relational data models, create complex custom analytics with Advanced Data Analysis Expressions (DAX), and publish web apps via Power BI Service.
  • Advanced SQL: Craft performant queries to clean, filter, join, and pull raw data directly from relational database engines.
  • Python for BI: Use Plotly, Dash, or Pandas libraries to architect bespoke, highly interactive data applications.
  • Dashboard Design & Storytelling: Focus on layout structure, visual selection, information hierarchy, and contextual copywriting.
  • Strategic & Business Acumen: Apply measurement planning, a problem-first mindset, and target audience focus.
  • Advanced Microsoft Excel: Utilize standard formulas, data cleaning, dynamic pivot tables, and mock-up reporting for early dashboard drafts.
  • Dashboard Design & Storytelling Tools: Leverage JavaScript, HTML & CSS, SQL, Python, M Code (Power Query Formula Language), and R (preferred in scientific and research-heavy environments).

Requirements

  • Active Secret Clearance (or eligibility to obtain one).
  • 8140 requirement: One of the following certifications: CompTIA Security+, CySA+, CCNA, GICSP, CISSP, CISM, or GSLC.

Qualifications

  • Layout Structure: Position high-priority revenue or KPI cards in prime real estate corners (e.g., top-left) following normal reading flows.
  • Visual Selection: Pair accurate chart types (bar/column charts for categories, line charts for trends, scatterplots for variables) with the data.
  • Information Hierarchy: Group metrics using enclosure boxes, remove duplicate axis labels, and start with high-level summaries before introducing granular tables.
  • Contextual Copywriting: Overwrite default dashboard chart titles with explicit, actionable observations that read cleanly like an analytical story.
  • SQL: Write queries to aggregate, filter, and join raw data tables.
  • Data Cleansing: Profile data, fix null values, and format data types.
  • Data Modeling: Build star schemas, manage table relationships, and handle data granularity.
  • Calculations: Write custom calculations for time-intelligence and complex KPIs.
  • Dashboard Design & UI/UX: Experience with ggplot2, Shiny web filters, and user-centric design principles.

Benefits

  • Medical, dental, and vision coverage.
  • Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA) for healthcare and dependent care.
  • Flexible work schedule, including onsite, hybrid, or remote options 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.

Similar jobs