Note: The job is a remote job and is open to candidates in USA. Xcelerate Solutions is seeking a Data Engineer / BI Developer to design, build, maintain, and optimize data architectures and business intelligence systems. The role focuses on ETL/ELT pipelines, data warehousing, BI dashboards and reporting, data quality, security, and compliance while collaborating 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
- To meet technical and cybersecurity compliance baselines, candidates must possess or be willing to obtain:
- Active **DoD 8570.01-M / DoD 8140** Information Assurance Technical (IAT) Level II certification (or higher). Acceptable certifications include:
- * GIAC Security Essentials (GSEC)
- * Systems Security Certified Practitioner (SSCP)
- * CCNA-Security
- * 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)
- * Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- * Tableau Certified Desktop Professional or Data Analyst
- * Certified Data Management Professional (CDMP)
Benefits
- Remote work
- Growth and development opportunities
Company Overview