Junior Data Analyst

Join Our Team at Duncan Solutions, LLC

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.

WORK LOCATION

This is a remote position with eligibility in the following states: AZ, CA, CO, CT, DE, FL, GA, IL, IN, IA, KS, LA, MD, MA, MI, MO, MN, NJ, NY, NC, OH, PA, SC, TN, TX, VA, WA, WI, WV, VT, D.C. Candidates must reside in one of the following locations for consideration.

Please note: Duncan Solutions, LLC, does not provide visa sponsorship now or in the future. Candidates must be legally authorized to work in the United States without current or future sponsorship requirements. 

PAY TRANSPARANCY

This role will offer $27.00 – $30 hourly, depending on experience, skills, and location.

POSITION SUMMARY 

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.

ESSENTIAL DUTIES AND 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.

What You’ll Need to Succeed

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

EDUCATION / EXPERIENCE / SKILLS

• High school diploma or GED required.
• Minimum of two (2) years of experience with Amazon QuickSight or comparable business intelligence tools.

Preferred

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

DECISION-MAKING LATITUDE

• Decisions are made with the best interests of the company in mind, guided by ethical considerations and sound judgment. All decisions will be subject to oversight to ensure alignment with business objectives and organizational integrity.
• Works under close supervision and may help others complete more complex tasks.
• Decision making is limited to strictly defined parameters. Accountable for quality and accuracy of own tasks.

Physical Demands and Working Conditions

• Primarily a sedentary position requiring prolonged periods of sitting or standing at a workstation. Frequent use of a computer and keyboard; repetitive wrist/hand movements and fine motor skills for typing and mouse use.

WHAT WE OFFER

Duncan Solutions, LLC, offers a professional environment, stability, upward mobility, and a wide breadth of benefits. We offer our full-time regular employees who meet eligibility criteria the following which include:

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)

Duncan Solutions, LLC is proud to be an Equal Opportunity Employer. We actively encourage applications from everybody. All qualified job applicants will receive consideration without regard to race, color, religion, creed, national origin, aboriginality, genetic information, ancestry, marital status, sex, sexual orientation, gender identity or expression, physical or mental disability, pregnancy, veteran status, age, political affiliation or any other non-merit characteristic.

Please visit our website to learn more about us https://www.duncansolutions.com/

To view all of our current job opportunities, please visit
 https://businessprocessingsolutions.bamboohr.com/careers