Data Analytics Engineer

Role Description

Cardinal Technology Systems Corp. is currently seeking a Data Analytics Engineer to work for our company.

• Must possess DoD Top Secret, DHS EOD, CBP Full BI, or IT-I security clearance or have a current Single Scope Background Investigation (SSBI). (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)
• Assist in the design, development, and deployment of reports, dashboards, and data visualizations using business intelligence (BI) tools such as SAP Business Objects or similar platforms.
• Collaborate with data engineering teams to support the use of dimensional models, including fact and dimension tables (star/snowflake schemas), for reporting.
• Write and maintain SQL queries within Oracle and Databricks environments to extract and prepare data for reporting applications.
• Work with business analysts and stakeholders to help gather requirements, translate business needs into technical specifications, and support the delivery of reporting solutions.
• Assist in monitoring and improving the performance of reports and underlying queries to help ensure a reliable and user-friendly experience.
• Gain exposure to and support the use of AWS services (e.g., S3, EMR, Redshift, Glue) for cloud-based reporting solutions.
• Support the management of reporting assets, including documentation, version control, scheduled refreshes, and ongoing maintenance and enhancements.

Qualifications

• Bachelor’s degree in computer science or related engineering field.
• 1-3 (maximum of 5 years) of hands-on experience with SQL programming.
• 1-3 (maximum of 5 years) of experience with at least one major BI platform (e.g. PowerBI, Tableau, Qlik).
• Experience with performing data analysis and interpreting results.
• Conceptual understanding of data warehousing concepts and dimensional modeling, including a clear ability to articulate the difference and use cases for star vs. snowflake schemas.
• High level of self-motivation, willingness to learn new technologies and work in a distributed team environment.
• The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, or to communicate with co-workers, management, and customers, which may involve delivering presentations.

Requirements

• Must possess DoD Top Secret, DHS EOD, CBP Full BI, or IT-I security clearance or have a current Single Scope Background Investigation (SSBI). (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)

Preferences

• 1-3 years of experience in dedicated reporting, business intelligence, or data analytics role.
• Experience developing reports and running queries within a Databricks environment (using notebooks, SQL Warehouses, etc.).
• Familiarity with navigating the AWS ecosystem, specifically with services related to data storage and access like S3 and IAM.
• AWS Certification (e.g. AWS Certified Data Analytics – Specialty or Solutions Architect).
• Proficiency in a scripting language, particularly Python (Pandas, Pyspark) for data manipulation or automation.
• Strong communication skills with ability to present technical findings to non-technical stakeholders.

Benefits

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