Data Analyst

Job Description Mid-America Carpenters Regional Benefit Services is a third-party administrator that oversees multiple benefit plans for union carpenters and their families in Southern Illinois, Missouri, and Kansas. We strive to provide the best benefits to the most participants for as long as possible by providing extraordinary service, driving innovative approaches, and being deeply devoted to the Carpenters’ Union, our participants, and our organization. The Data Analyst helps refine and review the business practices and rules of the organization as it relates to our Health & Welfare, Pension, Annuity and Vacation Funds. They are responsible for analyzing and understanding the organization's systems, processes, and business requirements to work closely with different departments within the organization to translate their needs into technical solutions.Job ResponsibilitiesGather, analyze, and validate data to ensure internal processes meet operational requirementsCreate and maintain operational reports from multiple sourcesDevelop and maintain deep understanding of rules and policies of each FundDevelop recommendations and assist in facilitating opportunities to optimize workflowsPull data and generate files for Year End Processing, Annual Audits, and other regulatory processesCreate and maintain interactive dashboards to help track metricsBasic QualificationsMinimum of 3 years of experience mining data as a data analystExperience with Microsoft Power Platform, including Power Apps, Power BI, and Power AutomateAbility to manage multiple tasks concurrently with competing deadlinesInitiative-taking self‐starter requiring minimal oversight and guidanceExcellent critical thinking, creativity, communication, and analytical skillsExperience with ERISA and Self‐funded Employer Benefit Plans a plusDemonstrated success collaborating in a team environmentKnowledge in Microsoft 365 products with advanced skills in ExcelHigh comfort with a variety of technology platformsPreferred QualificationsMinimum of 2 years’ experience in SQLWork AuthorizationNo calls or agencies please. The Mid-America Carpenters Regional Benefit Services will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1, H-1, H-2, L, B, J, or TN or who need sponsorship for work authorization now or in the future, are not eligible for hire.Equal Opportunity Employer The Mid-America Carpenters Regional Benefit Services is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, age, marital status, political affiliation, sexual orientation, gender identity, genetic information, disability or protected veteran status. We are committed to providing a workplace free of any discrimination or harassment.