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

• Develop, maintain, and optimize BI dashboards and reports for various business functions (marketing, sales, operations). • Analyze business performance metrics, trends, and KPIs to provide actionable insights. • Collaborate with cross-functional teams to understand business needs and design data solutions. • Translate complex data into easy-to-understand visualizations and presentations for stakeholders. • Monitor key metrics and provide regular reporting on sales, customer behavior, and operational performance. • Identify areas for process improvements using data-driven insights. • Ensure data quality, accuracy, and consistency across reporting tools. • Support the implementation of data warehouses and BI tools to improve reporting capabilities. • Assist in ad hoc analysis and deep-dive studies to answer business questions.

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

• Develop, maintain, and enhance BI dashboards and reports (Power BI, Tableau, DOMO) to monitor supply chain performance. • Analyze large datasets to identify trends, bottlenecks, and opportunities in inventory management, order fulfillment, and supplier performance. • Collaborate with supply chain, logistics, and operations teams to improve key metrics such as OTIF, fill rates, shrink, location accuracy, and inventory turnover. • Extract, clean, and structure data from multiple sources (ERP, WMS, TMS, and external vendor systems). • Automate reporting processes to improve efficiency and reduce manual efforts. • Support cost optimization initiatives by analyzing spend patterns, forecasting demand, and improving freight and distribution strategies. • Work closely with cross-functional teams (Finance, Operations, Procurement, and IT) to align data insights with business objectives. • Maintain data accuracy, integrity, and security while ensuring compliance with industry regulations (GMP, FDA, GDP, etc.).