Data / Reporting Architect - Federal Health

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

Driven by Innovation and built on Trust, rockITdata is a unique SDVOSB services company that partners with leading commercial healthcare/life sciences organizations on cutting edge innovations—think AI, automation and data transformation. We then bring those commercially tested solutions to government entities to deliver predictable, measurable impact for the American taxpayer and consumer.

Data / Reporting Architect

Join rockITdata as a Data / Reporting Architect supporting one of the nation's largest federal healthcare modernization initiatives. In this role, you'll design and implement enterprise reporting solutions that transform complex operational, financial, and technical data into meaningful insights for program leadership and Government stakeholders. Working closely with Business Analysts, Data Analysts, engineering teams, and Program Management, you'll develop reporting architectures, data models, and business intelligence solutions that improve decision-making and program performance.

Key Responsibilities

• Design and maintain enterprise reporting architecture supporting program management, operational reporting, and executive dashboards.
• Develop scalable data models, reporting frameworks, and business intelligence solutions using industry best practices.
• Collaborate with business stakeholders to define reporting requirements, key performance indicators (KPIs), and data visualization strategies.
• Design and optimize SQL queries, stored procedures, and data pipelines supporting enterprise reporting initiatives.
• Develop executive dashboards and interactive reports using Power BI, Tableau, or similar business intelligence platforms.
• Ensure reporting accuracy through data validation, quality assurance, and data governance processes.
• Partner with Data Analysts, Business Analysts, and technical teams to identify new reporting opportunities and improve data accessibility.
• Maintain technical documentation, data dictionaries, reporting standards, and architectural diagrams.
• Support executive governance meetings by providing reporting solutions and analytical insights that inform strategic decision-making.
• Recommend continuous improvements to reporting architecture, data integration processes, and business intelligence capabilities.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Information Technology, Business Intelligence, or a related field.
• Five (5) years of experience designing enterprise reporting solutions, business intelligence platforms, or data architecture within complex IT environments.
• Strong experience developing SQL queries, relational databases, and enterprise reporting solutions.
• Experience with Power BI, Tableau, SSRS, or similar business intelligence and data visualization tools.
• Experience designing data models, reporting frameworks, and executive dashboards.
• Familiarity with ETL processes, data integration, cloud-based reporting platforms, and enterprise data governance principles.
• Experience supporting AWS, Azure, Snowflake, SQL Server, Oracle, PostgreSQL, or similar enterprise data platforms is preferred.
• Experience supporting VA, VHA, DHA, or other Federal healthcare organizations, health IT, telehealth, or Federal program management is preferred.
• Strong analytical, communication, and technical documentation skills.
• Ability to obtain and maintain a Level 3 Public Trust clearance.

#LIREMOTE

rockITdata has become aware of a recruitment scam where unauthorized individuals are impersonating rockITdata recruiters, issuing fake job offers, and attempting to set up payment for the job seeker’s new hire costs. No one is ever required to complete any monetary transactions before starting employment with rockITdata. Legitimate rockITdata communications only come from @rockitdata.com email addresses and our official Applicant Tracking system, JazzHR (@applytojob.com email addresses). Please refer to our official Careers page at www.rockitdata.com/careers to accurately submit your application with us. You may also verify any suspicious communication by contacting our recruitment team directly through our official email, [e-mail].

rockITdata is an equal opportunity employer and is committed to non-discrimination in all employment practices and decisions. All qualified applicants will receive consideration for employment without regard to disability status, veteran status, or any characteristic protected by Federal, state, or local law.

rockITdata wants all interested and qualified candidates to be able to use our career site to review and apply for employment opportunities. If you have a disability and need an accommodation to access the application process, please contact us for assistance at [e-mail].