Cloud Business Intelligence Analyst

D&G Support Services
      30+ days ago

      Job 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

      • 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.

      ‍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. 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.
       

      Numbers & Facts

      Location
      Websitehttps://www.dngspt.com/open-positions/

      Skills

      • Access Controlunmatched
      • Agile Programming Methodologiesunmatched
      • Amazon Relational Database Service (RDS)unmatched
      • Analysis Skillsunmatched
      • Apacheunmatched
      • Automationunmatched
      • Backlog Prioritizationunmatched
      • Business Analysisunmatched
      • Business Developmentunmatched
      • Business Intelligenceunmatched
      • Business Solutionsunmatched
      • CCSP - Cisco Certified Security Professionalunmatched
      • Cargo/Freightunmatched
      • Cloud Computingunmatched
      • Code of Federal Regulationsunmatched
      • Communication Skillsunmatched
      • Community Supportunmatched
      • CompTIA Security+unmatched
      • Computer Scienceunmatched
      • Computer Securityunmatched
      • Continuous Deployment/Deliveryunmatched
      • Continuous Integrationunmatched
      • Data Analysisunmatched
      • Data Modelingunmatched
      • Data Profilingunmatched
      • Data Qualityunmatched
      • Data Scienceunmatched
      • Data Setsunmatched
      • Data Visualizationunmatched
      • Database Technologyunmatched
      • Decision Supportunmatched
      • Detail Orientedunmatched
      • Dockerunmatched
      • Documentationunmatched
      • Functional Analysisunmatched
      • GSEC - GIAC Security Essentials Certificationunmatched
      • Gitunmatched
      • Governmentunmatched
      • Identify Issuesunmatched
      • Information Technology & Information Systemsunmatched
      • Information/Data Security (InfoSec)unmatched
      • Internet Securityunmatched
      • Leadershipunmatched
      • Logisticsunmatched
      • Mathematicsunmatched
      • Metadataunmatched
      • Metricsunmatched
      • Microsoft SQL Serverunmatched
      • MySQLunmatched
      • Operational Auditunmatched
      • Oracleunmatched
      • Oracle Databaseunmatched
      • Performance Analysisunmatched
      • Performance Metricsunmatched
      • PostgreSQLunmatched
      • Product Demonstrationunmatched
      • Product Supportunmatched
      • Python Programming/Scripting Languageunmatched
      • Query Optimizationunmatched
      • Reconciliationunmatched
      • Relational Databases (RDBMS)unmatched
      • Reporting Dashboardsunmatched
      • Reporting Skillsunmatched
      • Requirements Managementunmatched
      • SAP BusinessObjectsunmatched
      • SQL (Structured Query Language)unmatched
      • SSCP - Systems Security Certified Practitionerunmatched
      • Sprint Planningunmatched
      • Statisticsunmatched
      • Test Plan/Scheduleunmatched
      • Testingunmatched
      • Training Data Setsunmatched
      • Trend Analysisunmatched
      • United States Citizenship and Immigration Services (USCIS)unmatched
      • United States Department of Defense (DoD)unmatched

      Level up your application

      Professional resume templates

      Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

      Free resume templates

      Resume Builder

      Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

      Resume Builder