Note: The job is a remote job and is open to candidates in USA. Xcelerate Solutions is an organization serving the government contracting industry. The Data Engineer / BI Developer will design, build, maintain, and optimize data pipelines, data architectures, data warehouses, and business intelligence systems. The role also develops dashboards and reports, ensures data quality and security compliance, and collaborates with technical and business stakeholders in an Agile environment.
Responsibilities
- Design, implement, and maintain scalable data pipelines to ingest, transform, and load structured and unstructured data from disparate enterprise sources
- Develop clean, optimized SQL scripts, stored procedures, and ETL workflows to support data migration and synchronization
- Monitor, troubleshoot, and tune data integration processes to ensure maximum pipeline efficiency, data freshness, and minimal system latency
- Participate in formal **Analysis of Alternatives (AoA)** to evaluate and determine optimal enterprise **Business Intelligence (BI) Architecture Solutions**, analyzing key factors such as platform scalability, data ingestion performance, system integration, licensing, and data governance capabilities
- Assist in designing and maintaining robust data warehouse schemas, data marts, and dimensional models (Star/Snowflake schemas) to optimize analytical queries
- Collaborate with database administrators to ensure data integrity, database performance tuning, indexing, and partitioning strategies are aligned with reporting needs
- Develop, publish, and maintain interactive, high-performance dashboards and paginated reports using enterprise BI tools (such as Power BI, Tableau, or Qlik)
- Translate complex business requirements into intuitive, user-friendly data visualizations that clearly communicate trends, KPIs, and anomalies
- Create and maintain complex data models within BI tools, utilizing advanced calculation languages (such as DAX or MDX) to perform advanced calculations and time-series analyses
- Implement rigorous automated data validation and quality check procedures within the data pipelines to identify, log, and resolve data anomalies
- Ensure all developed dashboards, reports, and underlying data sources strictly comply with Section 508 accessibility standards and Web Content Accessibility Guidelines (WCAG)
- Align all data warehousing and reporting solutions with enterprise security protocols, ensuring proper row-level security (RLS), data masking, and access controls are implemented
Skills
- **Education:** Bachelor's degree in Computer Science, Data Science, Information Systems, or a related technical field (equivalent professional experience may be considered)
- Minimum of 5+ years of professional experience in data engineering, BI development, or database development roles
- 3+ years of hands-on experience designing and implementing ETL/ELT pipelines and dimensional data models
- 3+ years of experience developing enterprise-grade dashboards and reports using tools like Power BI or Tableau
- Expert-level proficiency in SQL, including writing, optimizing, and debugging complex queries, views, and stored procedures
- Strong programming skills in languages commonly used in data pipelines (e.g., Python, Scala, or C#)
- In-depth understanding of data warehousing concepts, ETL methodologies, and data architecture patterns
- Solid understanding of the Software Development Life Cycle (SDLC) and Agile/Scrum development methodologies
- Excellent analytical, problem-solving, and critical thinking skills
- Strong communication skills, with the ability to convey complex data concepts to non-technical business stakeholders
- Work Status Allowable: U.S. citizenship
- Minimum Clearance to Start: Public Trust or Favorably Adjudicated Secret Clearance
- Compliance: Must strictly adhere to government cybersecurity policies, operations security (OPSEC) requirements, and system access regulations
- Experience with cloud data platforms (such as Azure Synapse, Snowflake, AWS Redshift, or Databricks)
- Familiarity with modern data orchestration tools (such as Apache Airflow, Azure Data Factory, or dbt)
- Experience implementing Row-Level Security (RLS) and managing workspace permissions within enterprise BI environments
- Knowledge of advanced statistical analysis, predictive modeling, or machine learning integration with BI tools
- Practical experience performing Section 508 accessibility compliance testing on BI reporting outputs
- **CompTIA Security+ CE** (highly preferred)
- Active **DoD 8570.01-M / DoD 8140** Information Assurance Technical (IAT) Level II certification (or higher)
Benefits
- Remote work arrangement
- Growth and development opportunities
Company Overview