Senior QuickSight 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 $90,000 - $110,000 annually, depending on experience, skills, and location.

Employees may also be eligible for performance-based incentives and additional benefits as part of our total rewards package.

POSITION SUMMARY

We are seeking a highly skilled and analytical Senior QuickSight Report Analyst to lead the development, optimization, and management of dashboards and reports using Amazon QuickSight. This role will work closely with stakeholders across business units to transform data into actionable insights, supporting strategic decision-making and operational excellence.

You will be responsible for owning the QuickSight reporting environment, designing efficient and visually compelling reports, ensuring data integrity, and mentoring junior analysts in best practices for data visualization and analysis.

What You'll Do

• Design, develop, and maintain dynamic dashboards, KPIs, and analytical reports   
  using Amazon QuickSight.
• Collaborate with business leaders to gather reporting requirements and translate   
  them into effective data visualizations.
• Build and optimize SPICE datasets, SQL queries, and data pipelines to support report   
  performance and scalability.
• Partner with data engineers and architects to ensure data quality, integrity, and   
  security.
• Perform in-depth data analysis to identify trends, anomalies, and opportunities for   
  business improvement.
• Act as a subject matter expert (SME) on QuickSight, advocating for its best practices   
  and efficient usage across the organization.
• Create documentation for report specifications, metadata definitions, and data   
  lineage.
• Mentor junior analysts and provide guidance on data storytelling and QuickSight   
  functionality.
• Stay updated on new QuickSight features and AWS BI ecosystem advancements.

What You'll Need to Succeed

Required

• 4+ years of hands-on experience with Amazon QuickSight, including SPICE data modeling   
  and dashboard development
• Strong SQL skills and experience querying large datasets from cloud-based data   
  warehouses (e.g., Redshift, Snowflake, Athena)
• Proven ability to design visually effective, user-friendly dashboards
• Experience working in Agile or fast-paced environments
• Excellent communication skills and ability to translate business needs into data solutions  

Preferred

• Experience with AWS ecosystem tools (e.g., S3, Lambda, Glue)
• Familiarity with other BI tools (Power BI, Tableau, etc.)
• Background in data warehousing or ETL processes
• Knowledge of data governance and compliance best practices  

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)
• Business Travel Accident Insurance
• Corporate Travel Discounts
• Bonus & Incentive Compensation Programs
• 401(k) with Employer Match (Traditional/Roth/Safe Harbor)
• Corporate Travel Discounts
• Bonus & Incentive Compensation Programs
• 401(k) with Employer Match (Traditional/Roth/Safe Harbor)
  

Paid Time Off

• 9 Company Holidays
• PTO Accrual
• Sick Time Accrual
• Parental Leave
• Jury Duty
• 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
  

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