Senior BI Developer - Apache Superset

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.

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

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 [email protected] (https://dgiss771-my.sharepoint.com/personal/christina\_hillegas\_dngsolutions\_com/Documents/Desktop/[email protected]) . 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.