Reports Engineer
Full time
Hybrid - Ashburn, VA
Responsibilities
Cardinal Technology Systems Corp. is a government IT solutions provider servicing commercial and government initiative in various parts of the United States. We are currently seeking a Reports Engineer to work for our company.
Summary
  • Must possess IT-I security clearance or have a current National Agency Check with Local Agency Check and Credit Check (NACLC). (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)
  • Design, develop, and deploy enterprise-level reports, dashboards, and data visualizations using BI platforms such as SAP Business Objects, Power BI, or similar tools.
  • Collaborate with data engineering teams to leverage dimensional data models (star and snowflake schemas) that support intuitive, high-performance reporting.
  • Write and optimize complex SQL queries across environments including Databricks and Oracle, ensuring accuracy, efficiency, and scalability for large datasets.
  • Translate business requirements into technical reporting solutions by partnering with business analysts, product owners, and stakeholders.
  • Proactively monitor, troubleshoot, and optimize reporting performance, identifying opportunities to improve query execution, data refresh cycles, and user experience.
  • Leverage AWS services such as S3, EMR, Redshift, and Glue to support cloud-native reporting and analytics workflows.
  • Manage the full life cycle of reporting assets, including documentation, version control, scheduling, and automated refresh processes.
  • Ensure data quality, consistency, and integrity across reporting outputs, implementing best practices for validation and reconciliation.
  • Provide guidance and mentorship on reporting standards, design patterns, and performance optimization, contributing to continuous improvement of the BI environment.
Requirements
  • Must possess IT-I security clearance or have a current National Agency Check with Local Agency Check and Credit Check (NACLC). (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)
  • 6+ years of experience designing, building, and supporting enterprise-level reports, dashboards, and data visualizations using BI platforms such as SAP Business Objects, Power BI, or similar tools.
  • 5+ years of experience writing and optimizing complex SQL queries to extract, aggregate, and analyze data from large datasets, including environments such as Oracle and Databricks.
  • Demonstrated experience collaborating with data engineering teams to leverage dimensional data models (star and snowflake schemas) for intuitive and high-performance reporting.
  • 4+ years of experience partnering with business analysts and stakeholders to translate business requirements into technical reporting specifications and actionable insights.
  • Proven ability to monitor, troubleshoot, and optimize report and query performance to ensure reliability, accuracy, and a positive user experience.
  • Hands-on experience leveraging core AWS services (such as S3, EMR, Redshift, and Glue) to support cloud-based reporting and analytics solutions.
  • Experience managing the full lifecycle of reporting assets, including documentation, version control, scheduling, and automated refresh processes.
  • Strong analytical and problem-solving skills, with the ability to work independently in a senior capacity while contributing to team-based solutions.
Benefits

• Medical, Dental, Vision Benefits
• Paid Life
• Paid Vacation, Holidays, Sick Leave, Floating Holidays, Bereavement Leave
• Semi-monthly pay cycle

About Us
Cardinal Technology Systems, Corp (“CTech-Sys”), www.ctech-sys.com, is an SBA Certified 8(a) and HUBZone company located in the National Capital Region (NCR) and serves both government and commercial clients such clients as US CBP, US CIS, DLA, DFuse Technologies, and American Environmental Engineering Consultants.
Cardinal Technology Systems, Corp is an Equal Employment Opportunity employer and it’s our policy to consider applicants for employment without regard to sex, race, color, creed, religion, national origin, sexual orientation, marital status, age, disability, veteran status, alienage, ancestry, or any other factors prohibited by law. Employment selections are based on company and client requirements and the qualifications and skills of the candidate. CTech-Sys is committed to actively capitalizing on the diversity of skills, talents and perspectives of our employees.