Systems Analyst II job in Cincinnati

Cincinnati, Ohio - OH Ohio National Financial Services

Job Ref:	3908
Employer:	Ohio National Financial Services
Sector:	Life Insurance Professional/Financial Services
Qualifications:	Unclassified
Software:	Excel Python SQL VBA
Job Type:	Full Time
Salary and Benefits:	Competitive
Remote:	No
Location
Country:	United States
State/Province/County:	Ohio - OH
City:	Cincinnati
Post Code:	45242
Map:	(Show on map)
Description
Job Description At the Constellation Insurance family of companies, we are dedicated to building a diverse, inclusive, and equitable workplace. If you are excited about this role but your previous experience and education doesn't align perfectly with every qualification of the job description, we encourage you to apply. You may be the right candidate for this or other roles within the organization. What you will be doing The Systems Analyst II will support the delivery of technical solutions including actuarial data processing/management, process automation, SQL database management, and consolidated reporting. Responsibilities may include, but are not limited to, the following: Developing and maintaining automated processes and SQL procedures Working with actuaries to identify and resolve production errors as well as perform ad-hoc analysis Using SQL and other programming languages to navigate, perform calculations, analyze and manipulate data Creating batch jobs to extract data from various sources, transform, and load data to various destinations Developing ad hoc and quarterly excel spreadsheets using advanced functions and VBA macros Producing processes, data analytics and reports to support business decisions Acquire actuarial, accounting and product knowledge. What benefits you will see Competitive compensation Medical, dental and vision insurance effective your first day Company paid life insurance 401(k) with company match 100% paid parental leave Adoption and surrogacy benefits Tuition reimbursement Flexible time off Why we are different We promote a diverse and inclusive workplace that respects the cultures, life experiences and traditions of our associates and the community You receive time away from the office including PTO, holidays, wellness day and community service to rest and recharge Associate resource groups provide opportunities to help you reach personal and professional goals A wide variety of associate services and programs including a college scholarship fund, corporate discounts, and recognition programs We offer a whole person approach to your health and well-being including financial resources and an Employee Assistance Program Learn more about our associate benefits and perks focused on you Requirements What you need to be successful Required: A bachelor's degree in information systems, business analytics, or similar field Experience in writing SQL queries Knowledge of relational database systems Proficiency with Microsoft Excel Strong analytical and problem solving skills Excellent communication skills Work well both independently and as part of a team Willingness to learn new concepts Drive to improve existing processes and build new ones Preferred: Experience with a source control system, such as Git Experience with Visual Studio, IBM DataStage or similar ETL tool Experience with Python Experience with Windows batch programming Understanding of financial statements Two to three years of experience in similar role What your work environment will look like An inclusive work environment in which any group feels welcome, respected, supported, valued to fully participate at work Flexible work arrangements including remote, traditional and hybrid Associate well-being programs to balance your life in ways that suit you best Engagement opportunities on-site and virtually to connect with your co-workers Dress for your day work attire Compensation Statement Individual compensation packages are based on various factors unique to each candidate, including skill set, experience, qualifications, and other job-related reasons. Roles may also be eligible for additional compensation, including annual incentive programs.

ref: (3908) 20 days ago

Back to search results

Featured Jobs

MORE JOBS LIKE THESE

Systems Analyst II job in Cincinnati

Cincinnati, Ohio - OH Ohio National Financial Services

Location

Description

Featured Jobs

JOBSEEKERS

EMPLOYERS

ABOUT PROACTUARY

POPULAR JOBS

ADDRESS

Registration Number