Ascensus is the leading independent technology and service platform powering savings plans across America. As an Associate Power BI Analyst, you will enable data-driven decision making by collecting, transforming, and visualizing data, building Power BI dashboards and maintaining data processing systems.
Responsibilities
- Responsible for protecting, securing, and proper handling of all confidential data held by Ascensus to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to Ascensus or our clients
- Our I-Client service philosophy and our Core Values of People Matter, Quality First and Integrity Always® should be visible in your actions on a day to day basis showing your support of our organizational culture
- Build Power BI dashboards and reports that translate data into clear, decision‑ready insights for stakeholders
- Build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services)
- Assist with EIM project definition and planning
- Implement and troubleshoot deployments
- Data Modeling
- Assist with conceptual, logical and physical data models
- Update the Entity Relationship diagrams and Dimensional models
- Data Integration
- Build data ingestion tools, metrics, alerts and notifications, metadata management
- Build data replication services and Change Data Capture (CDC) processes to incrementally update data in the data warehouse / data marts from Ascensus systems of record
- ETL development
- Follow standards and best practices for implementing ETL tools in support of the EIM vision and reference architecture
- Build and maintain ETL solutions and platform
- Participate in creating long term ETL application support model
- Data Warehouse and Data Marts
- Follow technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management
- Build processes for loading data into and extracting data from the warehouse / marts
- Assist with other tasks and projects as assigned
Skills
- 1+ years of relevant experience in data/software development, including data warehousing and ETL tools, techniques and technology
- Bachelor's degree or equivalent work experience
- Excellent analytical skills
- Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents
- Working experience with SQL
- Understanding of data modeling techniques
- Understanding of Data Warehousing and ETL design/tools
- Working experience with C# Python or other data related programming languages
- Experience with PowerBI, Cognos Analytics and Cognos Framework Manager
- Experience with relational databases: SQL Server, Sybase ASE, Oracle, MySQL
- Experience with NoSQL databases such as MongoDB, Redis
- Experience with Fabric
- Experience with data modeling tools like IDERA's Embarcadero ER/Studio Data Architect
- Experience with SSIS
- Experience with SSAS
Benefits
- 401(k) match
- Medical
- Dental
- Vision
- Paid-Time-Off
Company Overview
Ascensus delivers high-quality solutions for every segment of the retirement plan marketplace. It was founded in 1980, and is headquartered in Dresher, Pennsylvania, USA, with a workforce of 5001-10000 employees. Its website is https://www2.ascensus.com/.Company H1B Sponsorship
Ascensus has a track record of offering H1B sponsorships, with 9 in 2025, 7 in 2024, 9 in 2023, 23 in 2022, 14 in 2021, 19 in 2020. Please note that this does not guarantee sponsorship for this specific role.