Data / Reporting Architect - Federal Health

rockITdata; United States; On-site; USD 120,000 - 190,000; Full time

Job summary

rockITdata is seeking a Data / Reporting Architect to design enterprise reporting solutions transforming complex data into actionable insights for federal healthcare modernization initiatives. You will work with analysts, engineers, and program management to build reporting architectures and data models that inform leadership and government stakeholders.

Ideal candidate has 5+ years in enterprise reporting or data architecture, strong SQL, BI tool experience (Power BI/Tableau/SSRS), and

Qualifications

• Bachelor's degree in a related field (see listing).
• Five years of experience designing enterprise reporting solutions or data architecture in complex IT environments.
• Strong experience with SQL, relational databases, and enterprise reporting solutions.
• Experience with Power BI, Tableau, SSRS or similar BI and visualization tools.
• Experience designing data models, reporting frameworks, and executive dashboards.
• Familiarity with ETL, data integration, cloud-based reporting, and data governance.
• Experience with AWS/Azure/Snowflake/SQL Server/Oracle/PostgreSQL is preferred.
• Experience supporting Federal healthcare organizations or program management is preferred.
• Strong analytical, communication, and technical documentation skills.
• Ability to obtain and maintain a Level 3 Public Trust clearance.

Responsibilities

• Design and maintain enterprise reporting architecture for program management, operations, and executive dashboards.
• Develop scalable data models, reporting frameworks, and BI solutions using industry best practices.
• Collaborate with stakeholders to define reporting requirements, KPIs, and data visualization strategies.
• Design and optimize SQL queries, stored procedures, and data pipelines.
• Develop executive dashboards and interactive reports using Power BI, Tableau, or similar tools.
• Ensure reporting accuracy through data validation, QA, and governance processes.
• Partner with analysts and technical teams to identify new reporting opportunities and improve data access.
• Maintain technical documentation, data dictionaries, reporting standards, and diagrams.
• Support governance meetings with reporting solutions and analytical insights.
• Recommend continuous improvements to reporting architecture and data integration.

Skills

SQL

Data Modeling

BI Tools

ETL

Data Governance

Cloud Reporting

Communication

Documentation

Public Trust

Education

Bachelor's degree

Tools

Power BI

Tableau

SSRS

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.

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.

This position is ideal for an experienced data professional who enjoys designing scalable reporting solutions, solving complex data challenges, and delivering actionable insights that support mission‑critical healthcare technology programs serving our nation's Veterans.

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.

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