D&G Solutions
Cloud Business Intelligence Analyst
Hybrid mid-level full-stack developer supporting DoD transportation/logistics (IGC) modernization: building Apache Superset dashboards, RESTful APIs, microservices, and SQL data services in an Agile/DevSecOps environment. Requires 4+ years of experience, strong SQL/BI skills, and an active Secret clearance (or ability to obtain).
- Compensation
- Not disclosed
- Location
- Belleville, IL
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Full time
- Experience
- 4+ years
- Category
- Data analytics
- Posted
Skills
Must have
- 4+ years professional experience in full-stack software development, BI development, application development, or related technical field
- Experience developing front-end and back-end components for enterprise web applications (Java, C#, Python, JavaScript/TypeScript, Spring Boot, .NET, React, Angular, or comparable)
- Experience developing RESTful APIs, web services, microservices, or enterprise-system integrations
- Hands-on experience with Apache Superset or comparable BI platform (dashboards, datasets, filters, metrics, data-source connections)
- Strong SQL skills with relational databases, data modeling, query optimization, and application-to-database integration
- Experience with Git, CI/CD workflows, automated testing, secure coding, Agile delivery, and DevSecOps practices
- Ability to analyze functional/technical requirements, troubleshoot complex application and data issues, and communicate with technical and nontechnical stakeholders
- Bachelor's degree in Computer Science or related discipline, or one current certification (CCSP, CFR, FITSP-M, GSEC, CompTIA Security+, or SSCP)
- Active Secret security clearance or ability to obtain and maintain one
- U.S. person status (U.S. citizens, permanent residents, and other protected individuals under 8 U.S.C. 1324b(a)(3))
Nice to have
- Experience modernizing SAP Business Objects or other legacy reporting to Apache Superset or modern BI platform
- Experience with Python, Flask, JavaScript/TypeScript, React, Angular, Spring Boot, .NET, or comparable for BI customization and application integration
- Experience supporting applications in AWS GovCloud or authorized DoD cloud environment, including Amazon Aurora/PostgreSQL
- Familiarity with Docker, Kubernetes, Amazon ECS/EKS, GitLab Runners, Terraform, AWS CloudFormation, or comparable cloud/DevSecOps technologies
- Experience supporting transportation, logistics, cargo, passenger, asset-visibility, readiness, or other mission-oriented data and reporting
Full description
Cloud Business Intelligence Analyst
Hybrid | Scott AFB, Illinois | Secret Clearance Required (TS/SCI Eligible)
If you want to work on modern cloud analytics, build meaningful business intelligence solutions, and support mission-critical decision making for the Department of Defense, we would love to talk.Why This Role Exists
The work we do has real impact, and the people behind it matter just as much.
D&G Solutions is seeking a Cloud Business Intelligence Analyst to support USTRANSCOM's cloud modernization initiatives. In this role, you will develop and maintain business intelligence solutions, modernize legacy reporting capabilities, and deliver dashboards, reports, and analytics that provide actionable insights to Government stakeholders and mission users.
What You Will Do
- Design, develop, enhance, test, deploy, and maintain SQL queries, views, reporting datasets, and data transformations using relational databases (Oracle, PostgreSQL, Amazon Aurora/RDS), along with Apache Superset dashboards, reports, datasets, charts, filters, calculated metrics, visualizations, and other business intelligence products supporting IGC reporting, analytics, and operational decision-making.
- Work with Government stakeholders, Product Owners, cloud migration team, functional analysts, and mission users to understand reporting and analytical requirements and translate them into secure and reliable reporting capabilities (i.e. dashboards, reports, key performance indicators (KPIs), metrics, and decision-support products).
- Validate dashboard calculations, business rules, filters, metrics, SQL results, source data, and report outputs to ensure analytical products are accurate, consistent, traceable, and reliable.
- Support modernization and migration of legacy reports, including SAP Business Objects or comparable reporting products, into Apache Superset or other Government-approved analytics and visualization technologies.
- Develop and maintain documentation for all objects and processes generated.
- Participate in Agile delivery activities, including requirements refinement, sprint planning, demonstrations, testing, backlog development, and stakeholder reviews.
What We Are Looking For
Required
- 4+ years of professional experience in data analysis, business intelligence, reporting, data visualization, analytics, or a related technical field.
- Hands-on experience developing and maintaining dashboards, reports, and related items for executives using an enterprise business intelligence platform.
- Strong SQL skills, including experience querying, joining, aggregating, filtering, and analyzing data from relational databases.