About this position
About the Role
We are seeking a highly analytical and detail-oriented Fixed Operations Analyst to join our team. In this role, you will be responsible for delivering data-driven insights that drive performance across our fixed operations departments — including service, parts, and body shop. You will leverage your Qlik expertise to build, manage, and maintain enterprise-level dashboards and reporting solutions that empower leadership to make informed decisions.
Key Responsibilities
• Design, develop, and deploy Qlik Sense and QlikView applications from the ground up, including data modeling, scripting, and front-end visualization.
• Manage the full Qlik environment: server administration, user access controls, security rules, licensing, and performance optimization.
• Serve as the internal Qlik subject matter expert, providing guidance and training to stakeholders and business users.
• Analyze fixed operations KPIs including effective labor rate (ELR), parts gross profit, technician productivity, and customer pay vs. warranty performance.
• Develop standardized reporting packages and ad hoc analytical outputs for department heads and executive leadership.
• Collaborate with fixed ops managers to identify data gaps and implement process improvements backed by data insights.
• Monitor data pipeline integrity and troubleshoot ETL issues, ensuring the accuracy and timeliness of all reports.
• Maintain data governance documentation, including data dictionaries, source mapping, and refresh schedules.
• Partner with IT to ensure seamless integration between Qlik and source systems such as DMS platforms (e.g., CDK, Reynolds & Reynolds, Dealertrack).
• Track and report on departmental trends, flagging anomalies and providing actionable recommendations.
What We Offer
• Competitive base salary commensurate with experience.
• Comprehensive health, dental, and vision insurance.
• 401(k) with company match.
• Generous PTO and paid holidays.
• Ongoing professional development and Qlik certification support.
• A collaborative, data-forward culture that values innovation and continuous improvement.
Required Qualifications
• 2+ years of hands-on experience with Qlik Sense and/or QlikView, including end-to-end application development.
• Demonstrated experience in Qlik server setup, configuration, and ongoing environment management.
• Proficiency in QlikView/Qlik Sense scripting (load scripts, set analysis, aggr functions, etc.).
• Strong understanding of fixed operations within an automotive dealership or similar environment.
• Experience with data modeling, ETL processes, and connecting to multiple data sources (SQL, Excel, ODBC, REST APIs).
• Solid analytical and problem-solving skills with the ability to translate complex data into clear business narratives.
• Advanced proficiency in Microsoft Excel and working knowledge of SQL.
• Excellent verbal and written communication skills; comfortable presenting to senior leadership.
Preferred Qualifications
• Qlik Sense or QlikView certification (Business Analyst, Data Architect, or System Administrator).
• Experience with automotive DMS systems (CDK Global, Reynolds & Reynolds, Dealertrack).
• Familiarity with Qlik NPrinting for automated report distribution.
• Background in service operations, parts management, or dealer group analytics.
• Experience with cloud platforms (AWS, Azure) and modern data warehousing concepts.