Business Intelligence Architect / Developer

Navteca•Washington, DC

4d•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

Experience in government or regulated environments is a plus

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