Data Engineer / BI Developer

Xcelerate-Solutions-5; McLean (VA); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Xcelerate Solutions is seeking a Data Engineer / BI Developer to design and maintain scalable data pipelines, build enterprise dashboards, and ensure data integrity. You will work in an Agile GovCon environment with cross-functional teams to deliver secure data products that drive decision-making.

The role emphasizes SQL proficiency, ETL/ELT development, and BI visualization using Power BI, Tableau, or Qlik, with emphasis on data quality, security, and compliance.

Qualifications

• 5+ years of professional data engineering, BI development, or database development experience.
• 3+ years designing ETL/ELT pipelines and dimensional data models.
• 3+ years building enterprise dashboards/reports with Power BI or Tableau.

Responsibilities

• Design, implement, and maintain scalable data pipelines for ingesting, transforming, and loading data from diverse sources.
• Develop SQL scripts, stored procedures, and ETL workflows to support data migration and synchronization.
• Monitor and optimize data integration processes for freshness and low latency.
• Create and maintain BI dashboards and reports using enterprise visualization tools.

Skills

SQL

Python

Scala

C#

Education

Bachelor's degree in Computer Science, Data Science, Information Systems

Tools

Power BI

Tableau

Qlik

Job description

Information Technology CareersRemote , Remote,United States

This position requires a strong technical background in data pipeline (ETL/ELT) development, data warehousing, and modern BI visualization platforms. Working in an Agile environment, the candidate will collaborate with software developers, database administrators, and business analysts to deliver scalable, secure, and compliant data products that drive strategic decision-making. Come join our award-winning organization and work with some of the most talented and brightest minds in the GovCon industry.

Location: Remote

Key Responsibilities

In accordance with established technical guidelines and data management objectives, the Data Engineer / BI Developer will perform the following duties:

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

2. Data Warehousing & Architecture

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

3. Business Intelligence & Reporting Visualization

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

4. Data Quality, Security & Compliance

• Implement rigorous automated data validation and quality check procedures within the data pipelines to identify, log, and resolve data anomalies.

  Required Qualifications

  • Education: Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related technical field (equivalent professional experience may be considered).
  • Experience:
    • 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.
  • Technical Skills:
    • 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.
  • Soft Skills:
    • Excellent analytical, problem‑solving, and critical thinking skills.
    • Strong communication skills, with the ability to convey complex data concepts to non‑technical business stakeholders.

  Preferred Qualifications

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

  Certifications

  To meet technical and cybersecurity compliance baselines, candidates must possess or be willing to obtain:

  1. Cybersecurity Baseline Certification (Required)

  Active DoD 8570.01-M / DoD 8140 Information Assurance Technical (IAT) Level II certification (or higher). Acceptable certifications include:

  • CompTIA Security+ CE (highly preferred)
  • GIAC Security Essentials (GSEC)
  • Systems Security Certified Practitioner (SSCP)
  • CCNA‑Security

  2. Professional/Technical Certifications (Preferred but not required)

  • Certified Data Management Professional (CDMP)

  Security & Clearance Requirements

  Due to the secure nature of the enterprise environment and associated federal mandates:

  • 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.
  About Xcelerate Solutions:

  Founded in 2009 and headquartered in McLean, VA, Xcelerate Solutions (www.xceleratesolutions.com) is one of America's fastest‑growing companies. Xcelerate’s culture is defined by our diversified workforce of dynamic and versatile professionals, supported with growth and development opportunities that contribute to individual and company growth. This strong commitment to our employees has been recognized by our inclusion on the Washington Business Journal’s “50 Best Places to Work” list as well as being a “Great Place to Work” certified company with a 4.6 star, and a 99% CEO approval Glassdoor rating. Come find out why Xcelerate Solutions is one of thetop DC Metroemployers!

  Xcelerate Solutions is an Equal Employment Opportunity/Affirmative Action Employer.We evaluate qualified applicants without regard to race, color, national origin, religion, age, equal pay, disability, veteran status, sex, sexual orientation, gender identity, genetic information, or expression of another protected characteristic. As part of this commitment to the full inclusion of all qualified individuals, Xcelerate Solutions provides reasonable accommodation if needed because of an applicant's or an employee's disability. Pay Transparency Notice:Xcelerate Solutionswill not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.