Junior Data Analyst
About The Position
Duncan Solutions, LLC, is a full-service transportation management company that focuses on connecting people, technology, and data to make cities more livable and efficient. As a leading provider of parking and tolling management solutions, we support municipal and commercial clients with citation processing, debt collection, DMV registered owner identification, back-office transaction processing, image review, customer service center and customer experience (CX) operations, integrated on-street parking management, and more. The Junior Data Analyst supports the design, development, and maintenance of business intelligence dashboards and reports using Amazon QuickSight. This role works collaboratively with business stakeholders to deliver accurate, timely, and user-friendly reporting solutions that support operational and strategic decision-making. The Data Analyst, Staff contributes to data modeling, report development, and ongoing analysis while developing deeper expertise in data visualization tools, SQL querying, and business intelligence best practices.
Requirements
- Working knowledge of SQL and experience querying structured datasets.
- Experience developing dashboards and visual reports in a corporate environment.
- Strong analytical and problem-solving skills.
- Working knowledge of SQL and experience querying structured datasets.
- Experience developing dashboards and visual reports in a corporate environment.
- High school diploma or GED required.
- Minimum of two (2) years of experience with Amazon QuickSight or comparable business intelligence tools.
Nice To Haves
- Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business, or related field; equivalent experience may be considered.
- Familiarity with AWS data services and data warehousing concepts preferred.
Responsibilities
- Develop and maintain dashboards, KPIs, and standard reports using Amazon QuickSight.
- Collaborate with business stakeholders to gather reporting requirements and support the creation of effective data visualizations.
- Build and maintain SPICE datasets and SQL queries to support reporting needs.
- Partner with data engineers and senior analysts to ensure data accuracy and consistency.
- Perform data analysis to identify trends, performance metrics, and operational insights.
- Support documentation of report specifications, data definitions, and reporting processes.
- Assist in troubleshooting report performance issues and implementing enhancements.
- Contribute to continuous improvement of reporting standards and visualization practices.
- Stay current on updates to QuickSight and related business intelligence tools.
- Support cross-functional reporting initiatives as assigned.
Benefits
- Medical, Dental, & Vision Insurance
- Medical, Dental, & Vision Insurance
- Healthcare & Dependent Flexible Spending Accounts (FSA)
- Health Savings Account (HSA) with Employer Contribution
- Company Paid Life and AD&D Insurance
- Company Paid Short- & Long-Term Disability
- Employee Assistance Program (EAP)
- 401(k) with Employer Match (Traditional/Roth/Safe Harbor)
- Paid Time Off
- 10 Company Holidays
- PTO Accrual
- Sick Time Accrual
- Parental Leave
- Jury Duty
- Military Leave
- Bereavement
- Other Voluntary Benefits
- Life and AD&D Insurance for Employees/Spouse/Child(ren)
- Critical Illness
- Accident Insurance
- Identity Theft Insurance
- Pre-paid Legal Insurance
- Dependent Care Flexible Spending Account (DCFSA)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Education Level
High school or GED
