Business Intelligence Architect / Developer Intermediate Level (2-4 Years Experience)Location: DMV Area (Washington DC, Maryland, Virginia)Work Type: Full-Time | On-site or Hybrid (based on contract requirements) Overview Navteca is seeking a Business Intelligence (BI) Architect/Developer with strong experience in data analysis, business intelligence, and data engineering. This role supports enterprise data initiatives by designing, developing, and maintaining data pipelines, reporting systems, and analytics solutions. The ideal candidate will have hands-on experience across the full data lifecycle-from data ingestion and transformation to reporting and visualization-and will play a key role in enabling data-driven decision-making across multiple systems. Key Responsibilities
Design, develop, and maintain business intelligence and data analytics solutions Gather, define, and document data requirements, including data flows and architecture diagrams Perform data modeling and support the design of data warehouses and data lake architectures Develop and manage ETL processes, including data extraction, transformation, cleansing, and loading Support query development and reporting for enterprise data systems Integrate and manage data across multiple platforms and systems Analyze and optimize data structures, including denormalization and performance tuning Collaborate with stakeholders to ensure accurate and efficient data delivery Support advanced analytics initiatives, including Machine Learning and AI use cases Ensure compliance with Fairfax County standards and data governance practices
Core Skills & Technologies
Data Platforms & Tools:
SQL Server Integration Services (SSIS) Azure Data Factory SQL Server Reporting Services (SSRS) Databricks Data Studio
Data Processing & Formats:
ETL processes, data cleansing, denormalization JSON, Parquet
Programming & Analytics:
SQL, R
Cloud & Big Data:
Microsoft Azure, AWS, Google Cloud Platform Apache Spark Elastic
BI & Visualization:
Power BI
Data Warehousing Technologies:
Snowflake, Teradata, SAS
Emerging Technologies:
Machine Learning (ML) AI / Prompt Engineering
Qualifications
2-4 years of experience in business intelligence, data engineering, or analytics Strong understanding of data architecture, data modeling, and data integration Experience working with multiple data systems and enabling data sharing across platforms Ability to translate business requirements into technical data solutions Strong analytical, problem-solving, and communication skills Experience in government or regulated environments is a plus
Work Location & Schedule
On-site or hybrid depending on contract requirements Primary location: Fairfax County Government Center12000 Government Center Parkway, Fairfax, VA 22035 Standard hours: Monday-Friday, 8:00 AM - 4:30 PM (30-minute lunch) May require participation in an on-call rotation Must adhere to Fairfax County and/or FCPS holiday and inclement weather policies
Additional Requirements
Ability to work on-site at County or approved offsite locations as needed Time worked outside approved hours is not billable Timesheets must be submitted for all work performed Staff may not perform work for other clients during assigned County hours
Benefits Navteca offers a comprehensive benefits package, including:
Medical Insurance Dental Insurance Life and AD&D Insurance Short-Term and Long-Term Disability (STD/LTD) 401(k) Retirement Plan Paid Vacation Paid Holidays Paid Sick Leave Comp/Flex Time