Data Engineer / BI Developer

Description Xcelerate Solutions seeks a Data Engineer / BI Developer to play a key role in designing, building, maintaining, and optimizing robust data architectures and business intelligence systems. Operating under established technical performance standards, the successful candidate will bridge the gap between complex raw backend data systems and intuitive, actionable frontend business intelligence interfaces. 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: 1. Data Pipeline & ETL/ELT Development 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. 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. 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) Microsoft Certified: Power BI Data Analyst Associate (PL-300) Tableau Certified Desktop Professional or Data Analyst Certified Data Management Professional (CDMP) Security & Clearance Requirements Due to the secure nature of the enterprise environment and associated federal mandates: 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. 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 the top DC Metro employers! 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 Solutions will 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.