Technical Solutions Analyst

Commercial Capital Company, LLC.; Lenexa (KS); On-site; USD 70,000 - 90,000; Full time

Job summary

Commercial Capital Company, LLC. in Lenexa, Kansas, seeks a Technical Solutions Analyst to enhance reporting, automation, and process efficiency across the organization. The candidate will work closely with leadership to identify operational inefficiencies and assist with technology projects using Microsoft Dynamics, Power BI, and Power Automate.

A background in analytics or business systems, along with relevant problem-solving skills, is essential for this role. Strong educational credentials or equivalent hands-on experience are desired.

Qualifications

• 3–7 years of experience preferred in analytics or reporting.
• Strong aptitude for operational tasks may substitute for formal education.
• Familiarity with business systems and troubleshooting is helpful.

Responsibilities

• Build and maintain dashboards, reports, and operational analytics.
• Assist with Power Automate workflows and process improvements.
• Support Microsoft Dynamics and Power Platform administration tasks.
• Identify operational inefficiencies and recommend improvements.
• Troubleshoot data, workflow, and system-related issues.
• Coordinate and support technology initiatives and projects.
• Assist with documentation, SOP creation, and process mapping.
• Work with business teams to validate information and resolve inconsistencies.
• Help monitor reporting accuracy and operational performance metrics.
• Clearly document findings, recommendations, and completed work.

Skills

Problem solving

Analytics

Microsoft Dynamics

Power BI

Power Automate

Excel

Education

Associate or bachelor’s degree in Business, IT, Data Analytics

Tools

Power BI Fundamentals or PL-300

Microsoft Power Platform certifications

Data analytics or reporting certifications

Job description

The Technical Solutions Analyst supports reporting, automation, process improvement, and business systems initiatives across the organization. This role works closely with leadership to improve operational visibility, troubleshoot system and data issues, and assist with business technology projects involving Microsoft Dynamics, Power BI, Power Automate, Excel, and related platforms. This position is ideal for someone who enjoys problem solving, analytics, and helping bridge business operations with technology.

Education:

• Associate or bachelor’s degree preferred, but not required
• Business, Information Technology, Data Analytics, or related field preferred
• Equivalent hands-on experience is absolutely fine

Certifications (not required, but bonuses):

• Power BI Fundamentals or PL-300
• Microsoft Power Platform certifications
• Data analytics or reporting certifications

Years of Experience:

• 3–7 years preferred
• Experience with analytics, reporting, systems administration, or business systems helpful
• Strong aptitude and operational experience may substitute for formal education

Key Responsibilities:

• Build and maintain dashboards, reports, and operational analytics
• Assist with Power Automate workflows and process improvements
• Support Microsoft Dynamics and Power Platform administration tasks
• Identify operational inefficiencies and recommend improvements
• Troubleshoot data, workflow, and system-related issues
• Coordinate and support technology initiatives and projects
• Assist with documentation, SOP creation, and process mapping
• Work with business teams to validate information and resolve inconsistencies
• Help monitor reporting accuracy and operational performance metrics
• Clearly document findings, recommendations, and completed work