ResponsibilitiesWe are currently seeking a Data Analytics Engineer to work for our company.
Summary- 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.
- 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
