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. • Working knowledge of relational databases, data modeling concepts, reporting datasets, data relationships, and query optimization. • Experience translating business, mission, or operational requirements into reports, dashboards, metrics, visualizations, and analytical products. • Experience validating data, calculations, business rules, report outputs, and dashboard results to ensure accuracy, completeness, and consistency. • Ability to analyze complex datasets, identify trends and anomalies, troubleshoot data and reporting issues, and communicate findings to both technical and nontechnical stakeholders. • Experience documenting data definitions, metrics, reporting logic, analytical requirements, and dashboard functionality. • Ability to manage multiple analytical and reporting requirements while maintaining attention to detail, data quality, and mission relevance. • Bachelor's degree in Data Science, Data Analytics, Business Analytics, Computer Science, Information Technology, Information Systems, Statistics, Mathematics, or a related technical or analytical discipline; or one current certification from the following: Certified Cloud Security Professional (CCSP), CyberSec First Responder (CFR), Federal IT Security Professional–Manager (FITSP-M), GIAC Security Essentials Certification (GSEC), CompTIA Security+, or Systems Security Certified Practitioner (SSCP).
Preferred
- Experience developing and administering Apache Superset objects and role-based access controls. • Experience modernizing or migrating SAP Business Objects or other legacy enterprise reporting capabilities to Apache Superset or another modern BI platform. • Experience with Python, particularly for data analysis, data preparation, automation, validation, or supporting Apache Superset capabilities. • Experience with data profiling, data-quality analysis, reconciliation, metadata management, or data-governance practices. • Experience working with relational database technologies (i.e. PostgreSQL, Amazon Aurora, Oracle, SQL Server, or MySQL). • Experience creating executive, operational, performance, readiness, or mission-focused dashboards and reports. • Familiarity with Git, GitLab, CI/CD processes, Docker, or comparable technologies used to manage and deploy BI configuration, SQL, or analytical assets. • Experience supporting transportation, logistics, cargo, passenger, asset-visibility, readiness, or other mission-oriented data and reporting capabilities. • Familiarity with DoD cybersecurity, RMF, data-access controls, and security requirements applicable to enterprise analytics and reporting environments.
Clearance and Eligibility
- Active DoD Secret clearance required with eligibility for TS/SCI. • This role is restricted to U.S. person(s) (U.S. citizens, permanent residents, and other protected individuals under 8 U.S.C. 1324b(a)(3)).
Location
- Hybrid in support of USTRANSCOM at Scott Air Force Base, Illinois.
Who We Are: D&G is one of the fastest-growing companies in the Washington, DC area and honored to be named one of the “Best Places to Work” in the nation. We are an 8(a), Service-Disabled Veteran-Owned Small Business (SDVOSB), and Women-Owned Small Business (WOSB) that has been recognized at the highest levels, including the DHS Secretary and Secretary of the Army PM and Team of the Year Awards. We are driven to mission success through a combination of ownership, leadership, and accountability. We believe in giving back to our community and proudly supporting organizations such as Homes for Our Troops, SemperK9, and Wreaths Across America.
Why choose us?
We invest in our employees in all aspects of their life and we value family. We offer market-competitive salary, a generous PTO package, and comprehensive medical, dental, vision and life insurance plans. We also offer 401K, short/long-term disability insurance, a fun and engaging culture, and training opportunities to keep you up to speed with the latest technologies.
Commitment to Non-Discrimination
All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran, or any other status protected by applicable federal, state, local, or international law.
Know Your Rights Poster (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf)
E-Verify Participation Poster (uscis.gov)
Accommodations If you are an individual with a disability and would like to request a reasonable workplace accommodation for any part of our employment process, please contact the Human Resources Staff by sending an email to hr@dngsolutions.com (https://dgiss771-my.sharepoint.com/personal/christina_hillegas_dngsolutions_com/Documents/Desktop/hr@dngsolutions.com) . This option is reserved only for individuals who are requesting reasonable workplace accommodation. It is not intended for other purposes or inquiries.
Notification for current or previously cleared professionals:
Official U.S. Government information appearing in the public domain shall not automatically be considered UNCLASSIFIED or approved for public release. D&G recognizes that information contained in resumes of current or previously cleared professionals may be sensitive, containing potentially proprietary and/or protected information. Protected Information is considered classified, in the process of a classification determination, or unclassified, but protected by statute. Therefore, all resumes should be approved for public release by a U.S. Government Official with Original Classification Authority, prior to posting the resume to D&G ’s applicant tracking system.
By submitting my resume, I understand that I am NOT authorized to upload content with Official U.S. Government information that is considered, sensitive, proprietary, or protected.