Apply on Employer Site

Transamerica · 5 months ago

Business Intelligence Dev/Analyst

Cedar Rapids, Iowa

Full-time

Hybrid

Mid Level

$62K/yr - $75K/yr

Transamerica is a leading financial services company committed to helping people live their best lives. The Business Intelligence Analyst will manage and build third-party data extracts, collaborating with internal stakeholders to develop Business Intelligence tools that support the company's commercial success.

Financial ServicesImpact InvestingInsurance

No H1B

Responsibilities

Continuously develops and maintains an understanding of Business Intelligence technology and architecture, including data warehousing, dimensional modeling, OLAP functionality, reporting tools, and other methods of information delivery

Develop & maintains expertise with MSBI tools including: Excel/PowerPivot, PowerBI SSRS, PerformancePoint, SSIS, & SSAS/BISM

Develop database and/or data presentation solutions to deliver information to end-users accurately and efficiently

Extracts, transforms, & loads data using data management tools and T-SQL

Analyze, understand, and document user needs to ensure accurate fulfillment of user story requests from internal business customers

Generate, analyze and interpret data extracts

Contribute to, and possibly lead, project teams that are developing or modifying highly complex information solutions

Administers & maintains the BI Portal, data warehouse, and existing BI solutions

Continuously develops expertise in the data and data models within the data warehouse, as well as an understanding of supported business domains

May construct data models, data dictionaries, and report glossaries

May conduct user interviews and training sessions

May mentor teammates on BI tools and methods

Conducts and may facilitate internal testing and user acceptance testing

Qualification

MSBI toolsSQL/TSQLData visualizationData warehousingDimensional modelingProblem solvingCommunication skillsOrganizational skills

Required

Bachelor's degree or equivalent education/experience

Conversational understanding of BI concepts & tools

Demonstrated ability to write SQL/TSQL queries to retrieve/modify data

Ability to abstract a concept into a series of lifecycle components and events

Experience/education developing physical dimensional models, OLAP processes or data visualizations OR

Experience/education in data modeling, data discovery and the application of data to solve business problems

Proven problem solving ability and a willingness to think 'outside-the-box'

Preferred

Experience with PowerBI or other visualization tools

Experience with MSBI tools, including SSRS, SSIS, and/or SSAS

Moderate to advanced skills with MS Excel, including Office data connections and pivot tables

Conceptual, logical and/or Physical data modeling experience is a plus

Retirement, Life Insurance or Annuity industry experience preferred

Working knowledge of multiple IT platforms

Ability to anticipate future needs and challenges

Has organizational and prioritization skills and effective judgment

Can make timely decisions with appropriate information

Has strong communication and relationship building skills

Benefits

Competitive Pay

Bonus for Eligible Employees

Pension Plan

401k Match

Employee Stock Purchase Plan

Tuition Reimbursement

Disability Insurance

Medical Insurance

Dental Insurance

Vision Insurance

Employee Discounts

Career Training & Development Opportunities

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

College Coach 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

Company

Transamerica

Glassdoor3.2

Transamerica is a private holding company that provides services for various life insurance companies and investment firms. It is a sub-organization of Aegon.

Founded in 1904