> Markdown version of [/jobs/ext/3989825-data-reporting-developer](https://www.wearedevelopers.com/jobs/ext/3989825-data-reporting-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). --- # Data Reporting Developer - **Company:** XPECT Solutions Inc. - **Location:** Washington, DC, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, Amazon S3, Applicant Tracking Systems, Big Data, Databases, Data as a Services, Data Architecture, Data Governance, Extract Transform Load (ETL), Data Mart, Data Virtualization, Data Warehousing, Database Queries, Software Debugging, Entity Relationship Models, Network Interface Controllers, Information Model, Python (Programming Language), PostgreSQL, Logical Data Models, Meta-Data Management, Metadata Repositories, Operational Data Store, Standard Sql, Data Streaming, Workflow Management Systems, Freeform SQL, Backend, Data Strategy, Build Management, Microsoft Fabric, Gitlab-ci, Information Technology, Data Analytics, WebFOCUS, Non-relational Database, Tools for Reporting, Functional Programming, Terraform, TIBCO (Software), Amazon Redshift - **Published:** October 28, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9245550/data-reporting-developer ## About the Role * Active Top Secret clearance * Bachelor's degree in Physics, Mathematics, Information Technology, Computer Science, Business, or a related discipline * Minimum of 8 years of relevant professional experience in data architecture or related technology disciplines * Demonstrated experience leading enterprise data architecture, conceptual and logical data modeling, and metadata management on high-impact assignments * Experience designing and building relational and non-relational databases and data warehouse structures (e.g., star schemas, data marts) * Experience producing data architecture documentation such as ERDs, data models, and ETL design artifacts * Excellent oral and written communication skills, with the ability to present solution recommendations to technical and business stakeholders * Ability to work full-time onsite at client's facility in the National Capital Region, Monday-Friday. Preferred Additional Skills and Qualifications: * Experience with AWS data services, including Amazon Redshift, Aurora PostgreSQL, S3, and Lambda. * ETL design and workflow orchestration experience (e.g., Apache Airflow), with strong SQL and Python skills. * Experience building data catalogs and supporting data governance, data virtualization, or data fabric initiatives. * Experience developing canonical information models and Interface Control Documents (ICDs). * Familiarity with BI and reporting platforms (Tibco WebFOCUS a plus) and federal financial or accounting data. * Familiarity with infrastructure as code (Terraform) and GitLab CI/CD pipelines. ## Description This role is heavily focused on developing and supporting reports using WebFOCUS in a highly data-driven environment. Daily responsibilities include writing complex SQL queries, developing and debugging reports, gathering and analyzing business requirements, and working directly with stakeholders to deliver reporting solutions. The position requires learning and utilizing the WebFOCUS reporting language to build customized reports and dashboards focused on numerical and operational data. The individual will work as part of a cross-functional team and collaborate closely with business users, developers, and data teams. While the primary focus is reporting and analytics, the role is also expected to provide input and recommendations when architectural or backend changes are being considered. Experience working with Amazon Redshift and querying large data sets is highly valuable. Success in this role requires strong SQL skills, report development expertise, stakeholder engagement, and the ability to translate business requirements into effective reporting solutions. * Support the design of high-level conceptual and logical data models that provide a cross-system, cross-functional view of data requirements; translate business needs into long-term architecture solutions. * Help design and develop solutions for complex data sets; design and build relational and non-relational databases, including star schemas and data marts. * Create and maintain data model documentation, including the Canonical Information Model (CIM), Entity Relationship Diagrams (ERDs), Interface Control Documents (ICDs), and ETL diagrams; prepare Data Warehouse Design Documents for Government review. * Compile and maintain a Data Catalog for BI-supported systems (databases, tables, fields, and data descriptions) to feed the ATS Data Strategy; support implementation of a virtualized data fabric for centralized search and query. * Establish processes governing the identification, collection, and use of metadata; ensure metadata accuracy, validity, and quality; execute assigned data governance tasks. * Review object and data models and the metadata repository to structure data for better management and quicker access. * Analyze existing data warehouse capabilities and recommend and implement process and system improvement strategies; collaborate with ATS system teams on new data source ingestion and data feed integrity. * Provide technical leadership to system and local work groups, and advise stakeholders on software, hardware, and database management solutions.