Junior Data Analytics Engineer

*Attention: DoD Top Secret, DHS EOD, or IT-1 clearances or Single Scope Background Investigation (SSBI) based clearances is required. Applicants who do not possess this will not considered.* Considering making an application for this job Check all the details in this job description, and then click on Apply. *Job Overview* 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 Jr. Data Analytics Engineer to work for our company. This position will allow candidates to develop skills in SAP BusinessObjects, SQL Development, Databricks, AWS, Data Analytics. *Duties* * *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. *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)* * 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. *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. xtnlbfm * Strong communication skills with ability to present technical findings to non-technical stakeholders. Pay: $60,000.00 - $90,000.00 per year Benefits: * Dental insurance * Health insurance * Paid time off * Professional development assistance * Referral program * Vision insurance Education: * Bachelor's (Preferred) Experience: * SAP BusinessObjects: 1 year (Required) * Databases: 1 year (Required) * Databricks: 1 year (Preferred) * AWS: 1 year (Preferred) * SQL: 1 year (Required) * Power BI: 1 year (Preferred) * Tableau: 1 year (Preferred) * Python: 1 year (Preferred) * R: 1 year (Preferred) Security clearance: * Top Secret (Required) Ability to Relocate: * Ashburn, VA 20147: Relocate before starting work (Preferred) Work Location: Hybrid remote in Ashburn, VA 20147