Remote Enterprise Data & Reporting Architect

rockITdata; Arlington (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

rockITdata is a unique SDVOSB services company partnering with leading healthcare/life sciences organizations on AI, automation, and data transformation. We support federal healthcare modernization initiatives, translating complex data into insights for leadership and Government stakeholders.

As a Data / Reporting Architect, you will design enterprise reporting solutions, data models, and BI dashboards, collaborating with analysts, engineers, and program management to drive performance and

Qualifications

• Bachelor's degree in CS/IS/DA/IT/BI or related field.
• 5 years of experience designing enterprise reporting solutions or data architecture.
• Strong SQL queries and relational databases experience.
• Experience with Power BI, Tableau, SSRS, or similar BI tools.
• Experience designing data models, reporting frameworks, and executive dashboards.
• Familiarity with ETL, data integration, cloud reporting, and governance.
• Experience with AWS, Azure, Snowflake, SQL Server, Oracle, or PostgreSQL preferred.
• Experience supporting VA/VHA/DHA or federal healthcare programs preferred.
• Ability to obtain and maintain Level 3 Public Trust clearance.

Responsibilities

• Design and maintain enterprise reporting architecture for program management and executive dashboards.
• Develop scalable data models, reporting frameworks, and BI solutions.
• Collaborate with stakeholders to define reporting requirements, KPIs, and visualization strategies.
• Design and optimize SQL queries, stored procedures, and data pipelines.
• Develop executive dashboards and interactive reports using BI platforms.
• Ensure reporting accuracy via data validation and governance processes.
• Partner with analysts and technical teams to identify new reporting opportunities.
• Maintain technical documentation, data dictionaries, and standards.
• Support governance meetings with reporting insights for strategic decisions.
• Recommend improvements to reporting architecture and data integration processes.

Skills

SQL queries

Relational databases

Data architecture

Data modeling

BI solutions

Executive dashboards

Data governance

ETL processes

Cloud data platforms

AWS

Azure

Snowflake

SQL Server

Tableau

Power BI

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, IT, BI, or related field

Tools

Power BI

Tableau

SSRS

SQL

Job description

rockITdata is a unique SDVOSB services company partnering with leading healthcare/life sciences organizations on AI, automation, and data transformation. We support federal healthcare modernization initiatives, translating complex data into insights for leadership and Government stakeholders.

As a Data / Reporting Architect, you will design enterprise reporting solutions, data models, and BI dashboards, collaborating with analysts, engineers, and program management to drive performance and