• Develop and maintain dashboards and reports • Perform data analyses • Integrate data from multiple sources, ensuring data quality and consistency • Ensure the availability and security of information in BI environments.

Role Description Cardinal Technology Systems Corp. is currently seeking a Reports Engineer to work for our company. - Must possess IT-I security clearance or have a current National Agency Check with Local Agency Check and Credit Check (NACLC). - 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. Qualifications - 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

• Design, develop, and maintain business intelligence dashboards, reports, and data solutions to support business decision-making.

• Design and develop interactive Power BI dashboards and reports. • Create DAX measures and Power Query transformations for optimized data modeling. • Perform ETL operations using SQL, Power Query, and data connectors. • Implement row-level security (RLS) and other data security measures. • Collaborate with business users to define KPIs and reporting requirements.