TransAmerica Technology Services
Intermediate Business Intelligence Reporting Analyst (Hybrid)
Work From Home, USA · Mid
Sponsorship not specified$80k-$95kDetected 30 days ago
SQLData VisualizationExcelAuditingSASResearchCommunicationProblem SolvingMentoringInternal Audit
About the role
- We understand the potential of leveraging the talents of a diverse workforce.
- We embrace an environment where employees enjoy a balance between their careers, families, communities, and personal interests.
- Our insurance, retirement, and investment solutions help people make the most of what's important to them.
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 database and/or data presentation solutions to deliver information to end-users accurately and efficiently
- 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.
- Develop & maintains expertise with MSBI tools including: Excel/PowerPivot, SSRS, PerformancePoint, SSIS, & SSAS/BISM.
Requirements
- 5 years (depending on the level) work experience.
- Strong understanding of BI concepts & tools.
- Demonstrated ability to write SQL/TSQL queries to retrieve/modify data
- Previous experience with BIDS/MSBI Stack.
- Ability to abstract a concept into a series of lifecycle components and events.
- significant experience 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".
- Bachelor's degree or equivalent education/experience. Minimum of 2 - 5 years (depending on the level) work experience.
- Significant experience developing physical dimensional models, OLAP processes or data visualizations OR
Nice to have
- SAS programming experience
- Reporting and Visualization tools - Alteryx, Tableau, Microsoft PowerBI
- Strong 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
- Insurance Industry experience preferred
- Working knowledge of multiple IT platforms
- Ability to anticipate future needs and challenges
Compensation
- The Salary for this position generally ranges between $80,000 - $95,000 annually.
Benefits
- For eligible employees, we offer a comprehensive benefits package designed to support both the personal and financial well-being of our employees.
- Compensation Benefits
- Bonus for Eligible Employees
- Employee Stock Purchase Plan
- Tuition Reimbursement
- Disability Insurance
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Bachelor's degree or equivalent education/experience.
Company info
- We believe everyone deserves to live their best life. More than a century ago, we were among the first financial services companies in America to serve everyday people from all walks of life.
- Today, we're part of an international holding company, with millions of customers and thousands of employees worldwide. Our insurance, retirement, and investment solutions help people make the most of what's important to them.
- We're empowered by a vast agent network covering North America, with diversity to match. Together with our nonprofit research institute and foundation, we tune in, step up, and are a force for good - for our customers and the communities where we live, work, and play. United in our purpose, we help people create the financial freedom to live life on their terms.
- What We Do
- At Transamerica, hard work, innovative thinking, and personal accountability are qualities we honor and reward.
- Transamerica is organized into three distinct businesses.
- These are supported by Transamerica Corporate, which includes Finance, People and Places, General Counsel, Risk, Internal Audit, Strategy and Development, and Corporate Affairs, which covers Communications, Brand, and Government and Policy Affairs.
- Ultimately, we appreciate the uniqueness of a company where talented professionals work collaboratively in a positive environment - one focused on helping people look forward and plan for the best life possible while providing tools and solutions that make it easier to get there.
- We believe everyone deserves to live their best life.
- More than a century ago, we were among the first financial services companies in America to serve everyday people from all walks of life.
- Today, we're part of an international holding company, with millions of customers and thousands of employees worldwide.
Apply directly at TransAmerica Technology Services →Create a free account for alerts like thisView TransAmerica Technology Services immigration profile
This listing is sourced directly from TransAmerica Technology Services's careers page and normalized into a canonical job model.