Hybrid Lead Business Intelligence Developer – Caesar-Informix, 4GL

Posted last week

Apply now

About the role

  • Lead Developer for Business Intelligence at Transamerica, spearheading database solutions and analytics product development. Directing BI projects with a focus on data warehousing and visualization tools.

Responsibilities

  • Spearhead the development of database solutions and data presentation systems.
  • Demonstrated extensive knowledge and experience with SQL and relational databases, particularly Informix.
  • Investigate and troubleshoot issues, create and modify programs in Caesar using Informix 4GL and/or 4Js Genero BDL.
  • Experience with AIX or similar operating systems, alongside shell scripting capabilities.
  • Analyze, document, and understand user requirements to ensure accurate fulfillment of internal business customers’ requests.
  • Maintain continuous development of expertise in Business Intelligence technology, data warehousing, dimensional modeling, OLAP functionality, and reporting tools.
  • Execute and optimize Extract, Transform, Load (ETL) processes using SQL/4GL.
  • Contribute to and lead project teams in the development or modification of sophisticated information solutions.
  • Administer, maintain, and enhance the data warehouse.
  • Potentially construct data models, data dictionaries, and report glossaries as needed.
  • Conduct user interviews and provide training sessions to enhance understanding and usage of data solutions.
  • Conduct and facilitate internal testing and user acceptance testing to ensure quality deliverables.

Requirements

  • Bachelor’s degree in a relevant field or equivalent experience.
  • Seven years of experience in business intelligence or data management.
  • Strong understanding of BI concepts and tools.
  • Experience leading a full lifecycle BI project team from a technical leadership perspective.
  • Experience with Microsoft BI stack.
  • Experience with Tableau or other visualization tool.
  • Significant experience developing physical dimensional models or data visualizations.
  • Significant experience in data modeling, data discovery and the application of data to resolve business problems.
  • Problem-solving ability and a willingness to think “outside-the-box”.

Benefits

  • Competitive Pay
  • Bonus for Eligible Employees
  • Benefits Package
  • Pension Plan
  • 401k Match
  • Employee Stock Purchase Plan
  • Tuition Reimbursement
  • Disability Insurance
  • Medical Insurance
  • Dental Insurance
  • Vision Insurance
  • Employee Discounts
  • Career Training & Development Opportunities
  • Health and Work/Life Balance Benefits
  • Paid Time Off starting at 160 hours annually for employees in their first year of service.
  • Ten (10) paid holidays per year (typically mirroring the New York Stock Exchange (NYSE) holidays).
  • Be Well Company holistic wellness program, which includes Wellness Coaching and Reward Dollars
  • Parental Leave – fifteen (15) days of paid parental leave per calendar year to eligible employees with at least one year of service at the time of birth, placement of an adopted child, or placement of a foster care child.
  • Adoption Assistance
  • Employee Assistance Program
  • Back-Up Care Program
  • PTO for Volunteer Hours
  • Employee Matching Gifts Program
  • Employee Resource Groups
  • Inclusion and Diversity Programs
  • Employee Recognition Program
  • Referral Bonus Programs

Job title

Lead Business Intelligence Developer – Caesar-Informix, 4GL

Job type

Experience level

Senior

Salary

$115,000 - $125,000 per year

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job