Systems Analyst II

4 weeks ago

Cincinnati, United States Ohio National Financial Services Full time
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.

  • Systems Analyst II

    4 weeks ago

    Cincinnati, Ohio, United States Ohio National Financial Services Full time

    Job DescriptionAt 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...

  • Credit Analyst II

    3 weeks ago

    Cincinnati, United States Fifth Third Full time

    Make banking a Fifth Third better We connect great people to great opportunities. Are you ready to take the next step? Discover a career in banking at Fifth Third Bank. GENERAL FUNCTION: The Credit Analyst II is primarily responsible for partnering with Portfolio Managers, supporting the daily duties of underwriting and monitoring credit while performing...

  • Credit Analyst II

    3 weeks ago

    Cincinnati, United States Fifth Third Full time

    Make banking a Fifth Third better We connect great people to great opportunities. Are you ready to take the next step? Discover a career in banking at Fifth Third Bank. GENERAL FUNCTION: The Credit Analyst II is primarily responsible for partnering with Portfolio Managers, supporting the daily duties of underwriting and monitoring credit while performing...

  • Software System Analyst

    6 days ago

    Cincinnati, United States Encore Talent Solutions Full time

    Encore Talent is currently searching for a Business Systems Analyst III for an end client requirement. Must have analysis of business requirements and system designs, Business System Analyst, and Project Management and Business Analysis. Full lifecycle application development Designing, coding and debugging applications in various software languages....

  • Software System Analyst

    1 week ago

    Cincinnati, United States Encore Talent Solutions Full time

    Encore Talent is currently searching for a Business Systems Analyst III for an end client requirement. Must have analysis of business requirements and system designs, Business System Analyst, and Project Management and Business Analysis. Full lifecycle application development Designing, coding and debugging applications in various software languages....

  • Software System Analyst

    1 week ago

    Cincinnati, United States Encore Talent Solutions Full time

    Encore Talent is currently searching for a Business Systems Analyst III for an end client requirement. Must have analysis of business requirements and system designs, Business System Analyst, and Project Management and Business Analysis. Full lifecycle application development Designing, coding and debugging applications in various software languages....

  • Software System Analyst

    1 week ago

    Cincinnati, United States Encore Talent Solutions Full time

    Encore Talent is currently searching for a Business Systems Analyst III for an end client requirement. Must have analysis of business requirements and system designs, Business System Analyst, and Project Management and Business Analysis. Full lifecycle application development Designing, coding and debugging applications in various software languages....

  • Business System Analyst

    1 week ago

    Cincinnati, United States Perfict Full time

    About Us:Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...

  • Business System Analyst

    1 week ago

    Cincinnati, United States Perfict Full time

    About Us:Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...

  • Business System Analyst

    1 week ago

    Cincinnati, United States Perfict Full time

    About Us:Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...

  • IST Business Systems Analyst

    9 hours ago

    Cincinnati, United States Talison Lithium Full time

    Business/Systems Analysts (Information & Communication Technology) Lithium plays a critical role in the transition to clean energy, and Talison Lithium is the world's leading lithium minerals producer with the largest high-grade ore body in the world - join us and be a part of the transition. Talison Lithium aims to maximise local employment where possible...

  • AGE Senior Systems Analyst

    3 days ago

    Cincinnati, United States NavitsPartners Full time

    Job DescriptionJob DescriptionPosition: AGE Senior Systems AnalystLocation: Blue Ash, OHDuration: 2 MonthsJob SummaryThe client is looking for a skilled, experienced, and motivated Senior Systems Analyst with expertise in software systems analysis and quality assurance. The ideal candidate will play a crucial role in ensuring the integrity, efficiency, and...

  • AGE Senior Systems Analyst

    2 days ago

    Cincinnati, United States NavitsPartners Full time

    Job DescriptionJob DescriptionPosition: AGE Senior Systems AnalystLocation: Blue Ash, OHDuration: 2 MonthsJob SummaryThe client is looking for a skilled, experienced, and motivated Senior Systems Analyst with expertise in software systems analysis and quality assurance. The ideal candidate will play a crucial role in ensuring the integrity, efficiency, and...

  • Sr. Analyst, Quality

    2 weeks ago

    Cincinnati, United States Cincinnati Children's Hospital Medical Center Full time

    Expected Starting Salary Range: 42.17 - 53.64 Representative Responsibilities * Training Courses - Develop materials and support for Training Courses. Train others in the use of CCHMC data systems, the wiki data dictionary, the Performance Measurement and Reporting System, and other institution-wide systems for creating, managing and reporting performance...

  • Dispatcher II, Public Safety Dispatch Center

    2 weeks ago

    Cincinnati, United States UC Health Full time

    Dispatcher II, First Shift, Public Safety Dispatch Center UC Health is hiring a full-time Dispatcher II for the Public Safety Dispatch Center department. This is a first shift position with UC Health, LLC. The Dispatcher II will support Public Safety Dispatch Center delivering high-quality care to patients based on assessed needs, established standards of...

  • Dispatcher II, Public Safety Dispatch Center

    2 weeks ago

    Cincinnati, United States UC Health Full time

    Dispatcher II, Second Shift, Public Safety Dispatch Center UC Health is hiring a full-time Dispatcher II for the Public Safety Dispatch Center department. This is a second shift position with UC Health, LLC. The Dispatcher II will support Public Safety Dispatch Center delivering high-quality care to patients based on assessed needs, established standards...

  • Dispatcher II, Public Safety Dispatch Center

    6 days ago

    Cincinnati, United States UC Health Full time

    Dispatcher II, Second Shift, Public Safety Dispatch Center UC Health is hiring a full-time Dispatcher II for the Public Safety Dispatch Center department. This is a second shift position with UC Health, LLC. The Dispatcher II will support Public Safety Dispatch Center delivering high-quality care to patients based on assessed needs, established standards...

  • ServiceNow HAM/SAM Analyst

    2 weeks ago

    Cincinnati, United States Apex Systems Full time

    :Title: ServiceNow HAM/SAM Analyst IVLocal or Remote: Local to Cincinnati, OH preferred, remote if willing to travelType: 6+ month ContractMust Have’s:Security – IAM / IDM Nice to Have’s:EOL CycleITAMPlanviewVBScript Job Description:Design and implement technology solutions using modern engineering tools and Agile practices. Work with self-directed,...

  • ServiceNow HAM/SAM Analyst

    2 weeks ago

    Cincinnati, United States Apex Systems Full time

    :Title: ServiceNow HAM/SAM Analyst IVLocal or Remote: Local to Cincinnati, OH preferred, remote if willing to travelType: 6+ month ContractMust Have’s:Security – IAM / IDM Nice to Have’s:EOL CycleITAMPlanviewVBScript Job Description:Design and implement technology solutions using modern engineering tools and Agile practices. Work with self-directed,...

  • Senior Fixed Income Analyst

    4 weeks ago

    Cincinnati, Ohio, United States Fort Washington Investment Advisors, Inc Full time

    Born as a modest, door-to-door life insurance business and built to last foreverThe Senior Fixed Income Analyst works closely with the Securitized Products Group portfolio managers to enhance the portfolio management process via the development and maintenance of various databases, financial models and information systems.The Senior Fixed Income Analyst...