Data & Reporting Analyst

Experience Level: 3–7 years of professional data experience Employment Type: Full-Time About CCA Financial CCA Financial is a leading independent commercial equipment and technology financing company dedicated to helping businesses acquire the equipment and technology they need to grow. We are seeking a Data Professional to drive the future of business intelligence at our organization. While our data lives in a structured SQL Server environment, we are looking for a candidate who brings fresh perspectives, and the technical confidence to evolve our reporting capabilities. This is a collaborative position designed for an analyst who wants to move beyond standard report maintenance and directly shape how our business interacts with data. Key Responsibilities Data Strategy & Tool Selection: Evaluate our current data workflows and recommend modern reporting solutions. Database Operations & Maintenance: Write, optimize, and manage complex T-SQL queries, stored procedures, and views within our existing SQL Server environment. Transformation Management: Maintain and optimize current data pipelines using SSIS, while looking for modern ways to automate and improve ETL processes. Modern Workflow Innovation: Explore and integrate AI-assisted tools (e.g., Copilot, Claude) to optimize query writing, automate routine data tasks, and accelerate development. Data Stewardship: Ensure maximum data integrity, quality, and security across both legacy systems and new reporting platforms. Required Qualifications Core Database Skills: Strong proficiency with SQL Server and relational databases, including the ability to write clean queries and troubleshoot SSIS packages. Analytical Mindset: Proven ability to look at raw financial and operational data, identify trends, and design entirely new reporting frameworks from scratch. Adaptability & Autonomy: Comfortable working in a changing tech landscape, with a proven track record of researching, learning, and adopting new software tools independently. Advanced Excel: Mastery of deep Excel functions, data modeling, and handling complex datasets. Communication: Ability to pitch new technical ideas to leadership and translate complex data structures into clean, executive-ready dashboards. Preferred Qualifications (Plus Factors) AI/ML Exposure: Experience using generative AI for SQL prompt engineering, automation, or data discovery. Financial Software Experience: Experience querying, extracting, or managing data in an ERP or accounting systems. Leasing Platform Knowledge : Familiarity with specialized leasing software data structures. What Will Make You Successful Strong analytical and problem-solving skills with the ability to transform complex data into meaningful business insights. Advanced proficiency in SQL Server, including writing, optimizing, and troubleshooting complex queries, stored procedures, and database objects. A proactive mindset with the curiosity to evaluate new technologies, challenge existing processes, and recommend innovative reporting solutions. Experience working with data transformation and ETL processes, coupled with a commitment to data accuracy, integrity, and governance. Advanced Excel skills and the ability to manage, analyze, and model large, complex datasets. Excellent communication skills with the ability to translate technical concepts into clear, actionable insights for business leaders and stakeholders. A self-starter mentality with the ability to independently learn new tools, adapt to evolving business needs, and manage multiple priorities effectively. Salary Range: $91,000 – $120,000 Individual compensation will be based on relevant experience, qualifications, and market considerations. #J-18808-Ljbffr CCA Financial