> Markdown version of [/jobs/ext/735673-business-intelligence-architect-developer](https://www.wearedevelopers.com/jobs/ext/735673-business-intelligence-architect-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Architect / Developer - **Company:** Navteca LLC - **Location:** Washington, DC, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Amazon Web Services, Business Analytics Applications, Data Analysis, Microsoft Azure, Big Data, Cloud Computing, Computer Programming, Data Architecture, Data Cleansing, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mining, Data Sharing, Data Structures, Data Systems, Data Warehousing, Document-Oriented Databases, JSON, Machine Learning, Performance Tuning, Power BI, SAS (Software), SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Data Streaming, Technical Data Management Systems, Teradata SQL, Parquet, Data Processing, Google Cloud, Data Ingestion, Azure Data Factory, Snowflake, Prompt Engineering, Apache Spark, Data Lakes, Data Management, Data Delivery, Data Pipelines, Databricks - **Published:** June 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=a903253fe750059f ## About the Role 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., * 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 ## Description * 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, * Primary location: Fairfax County Government Center 12000 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)