IT BUSINESS SOLUTIONS ANALYST

IT Business Solutions Analyst

Carpenters Services Administrative Corporation (CSAC) Los Angeles, CA 90071

Full-Time, Non-Exempt

About the Role

We are seeking a proactive IT Business Solutions Analyst with strong analytic and technical capabilities to serve as a key liaison between fund office departments and IT. In this hands-on role, you will leverage data analysis to drive project execution, manage deliveries, and support technology initiatives for our Taft-Hartley benefit plans. Successful candidates will bring experience in all areas of stakeholder management, project management, and business analysis. The position requires proven proficiency in Excel, SQL, Python, Smartsheet, and business intelligence (e.g., Power BI, Tableau) or similar tools. Candidates with degrees or backgrounds in Business Analytics, MIS, Accounting, Economics, CS, or related fields are encouraged to apply. This is a growth position within an expanding, industry-leading organization, offering meaningful opportunities to be part of our continued success.

Key Responsibilities

• Analyze & Visualize: Conduct data validation and discrepancy analysis using SQL to ensure data accuracy and integrity; analyze trends and support decision-making through well-structured reports and dashboards.
• Bridge the Gap: Translate business needs into functional specifications and technical concepts into "business-friendly" language for leadership and stakeholders.
• System Optimization: Interpret complex plan rules to configure benefit systems, maintain rule engines, and recommend automation opportunities.

· Hands-On Project Execution: Actively perform assigned project tasks and deliverables while facilitating daily project activities. This includes managing documentation, tracking tasks in project management tools, and supporting change management through training materials and communication plans

Qualifications

• Experience: 3-5 years as a Business Analyst, or similar position, ideally in benefits administration, healthcare, or union trust fund settings.

Technical Skills: Advanced proficiency in Microsoft Office, Excel is a must. 1+ year(s) of experience in SQL and Python is a strong plus. Smartsheet and BI experience is also a plus.

• Communication: Strong interpersonal skills with the ability to provide excellent customer service and present findings to governance committees.
• Compliance: Familiarity with ERISA and HIPAA requirements is a plus.

Work Environment & Schedule

• This is a five day-a-week on-site position in an office setting, located in Los Angeles, CA. No hybrid or remote work options available.
• Regular paid overtime is required and considered an essential function of the position.
• Minimal travel may be required for business-related events or seminars.

· Applicants must be authorized to work in the United States. Visa sponsorship or transfer of sponsorship is not available for this position.

NOTE:

The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar related or a logical assignment to the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. CSAC is an equal opportunity employer and encourage applications from all qualified candidates regardless of gender, race, ethnicity, national origin, age, sexual orientation, marital status, religion, disability or any other classification protected by law.

Job Type: Full-time

Pay: $31.52 - $40.33 per hour

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Professional development assistance
• Retirement plan
• Vision insurance

Application Question(s):

• Tell me about a time you used SQL to identify a data discrepancy. What was the impact?
• How do you validate data accuracy when working with large eligibility datasets?
• What visualization or reporting tools have you used (e.g., Power BI, Tableau, Excel advanced features)?
• Describe your approach to gathering and documenting business requirements from non-technical users.
• Tell me about a workflow you analyzed and improved. What was the outcome?
• Have you used any automated testing tools? If yes, which ones and what scripts did you write?
• Will you now or will you in the future require employment visa sponsorship?

Experience:

• SQL : 1 year (Required)

Ability to Commute:

• Los Angeles, CA 90071 (Required)

Work Location: In person