[Hiring] Senior BI Developer @D&G Solutions

Role Description

D&G Solutions is seeking a Senior BI Developer specializing in Apache Superset to support IGC business-intelligence modernization, analytics, and reporting. The selected candidate will lead complex BI development, modernize legacy reporting capabilities, and provide technical leadership across Superset, SQL, data modeling, integration, performance, security, and validation.

BI Modernization & Apache Superset Development

• Lead the design, development, integration, testing, deployment, and sustainment of enterprise Apache Superset business-intelligence solutions.
• Work with Government Product Owners, functional analysts, logistics subject-matter experts, and users to define reporting, analytics, visualization, and decision-support requirements.
• Lead modernization of legacy IGC reporting capabilities, including SAP Business Objects where directed, to Apache Superset or other Government-approved target BI technologies.
• Analyze legacy reports, prompts, calculations, filters, business rules, data dependencies, and workflows to preserve required functionality during BI modernization.
• Create and optimize advanced dashboards, charts, filters, calculated metrics, datasets, drill-downs, and reusable semantic-layer components.
• Configure Superset metadata, database connections, caching, authentication, RBAC, row-level security, dataset permissions, and dashboard access; validate calculations, data accuracy, and functional equivalence.

SQL, Data Modeling & Integration

• Develop and optimize complex SQL queries, views, functions, materialized views, and analytics-ready database objects supporting dashboards, reports, and downstream analytics.
• Develop reporting-oriented logical data models, semantic structures, views, and datasets required by Superset and related BI capabilities.
• Integrate Superset with approved relational data platforms, including Oracle, PostgreSQL, Amazon Aurora/RDS, or other Government-approved sources where implemented.
• Coordinate with database and data-ingestion teams on data structures, refresh requirements, interfaces, lineage, dependencies, and data-quality controls.
• Develop embedded analytics and API integrations and troubleshoot complex dashboard, SQL, connectivity, data-quality, access-control, caching, and performance issues.

Security, Performance & Validation

• Define Superset application, integration, data-access, scalability, and deployment requirements within the approved IGC cloud architecture and established DevSecOps processes.
• Coordinate with cloud and DevSecOps personnel to implement and sustain Superset in approved containerized and AWS environments without owning the underlying platform.
• Optimize dashboard load times, SQL/query performance, caching, database connections, refresh behavior, and resource utilization.
• Identify BI application, authentication, authorization, data-access, and integration risks and coordinate mitigations with cybersecurity, architecture, database, and cloud personnel.
• Support applicable DoD cybersecurity, RMF, software-assurance, STIG, GVT, GAT, release-validation, and technical-review activities for BI capabilities.
• Maintain Superset code, SQL, configuration, dashboard exports, and deployment artifacts in Git and integrate BI changes into established GitLab CI/CD processes.

Technical Leadership & Documentation

• Lead BI design and code reviews and provide technical guidance on Superset, SQL, visualization, semantic-layer design, performance, security, and integration practices.
• Mentor mid-level developers and analysts and assist the team in resolving complex BI design, migration, integration, and performance challenges.
• Prepare and maintain dashboard inventories, data-flow diagrams, interface specifications, technical designs, configuration guidance, release documentation, and operational runbooks; participate in Agile planning, demonstrations, and release activities.

Qualifications

• 8 years of experience in business-intelligence development, software development, data analytics, data engineering, or a related technical field.
• Bachelor's degree in Computer Science, Information Systems, Data Science, Software Engineering, Information Technology, Business Analytics, or a related technical discipline; equivalent directly relevant experience may be considered where permitted by the applicable labor category.
• Demonstrated advanced experience designing, developing, deploying, and sustaining enterprise Apache Superset solutions.
• Advanced experience with Superset dashboards, datasets, calculated metrics, filters, semantic-layer components, database connections, authentication, RBAC, and row-level security.
• Advanced SQL skills, including complex queries, joins, functions, views, materialized views, data validation, and performance optimization.
• Experience modernizing or migrating enterprise reporting/BI solutions while preserving business rules, calculations, security, and user functionality.
• Experience with relational databases such as Oracle, PostgreSQL, Amazon Aurora/RDS, MySQL, SQL Server, or comparable platforms and with reporting-oriented data models and integrations.
• Experience with Git and established CI/CD processes; familiarity with cloud-hosted and containerized application environments and with Python, Flask, REST APIs, JavaScript, HTML, or CSS for Superset customization.
• Strong technical leadership, troubleshooting, documentation, analytical, and stakeholder-communication skills.
• When assigned to PWS activities carrying DCWF 628 Intermediate requirements, must satisfy applicable DoD 8140/DCWF qualification and IGC Computing Environment Certification requirements.
• Active Secret security clearance or the ability to obtain and maintain one, as required by assigned duties and contract requirements.

Preferred Qualifications

• Experience modernizing SAP Business Objects or other legacy enterprise BI/reporting capabilities to Apache Superset.
• Experience developing dashboards or analytics for transportation, logistics, cargo, passenger, readiness, asset-visibility, performance, or operational data.
• Experience supporting Apache Superset in AWS GovCloud or another authorized DoD cloud environment and integrating Superset with Aurora/PostgreSQL and enterprise identity services.
• Familiarity with Docker, Kubernetes, Amazon ECS/EKS, Terraform, AWS CloudFormation, Helm, or comparable technologies used by supporting cloud/DevSecOps teams.
• Knowledge of data lineage, metadata management, data quality, accessibility, visualization standards, RMF, and federal software-authorization processes.