Ascensus · 22 hours ago
Associate Data Engineer
Dresher, PA
Full-time
Onsite
Entry Level
$75K/yr - $85K/yr
1+ years expAscensus is a company focused on enabling data-driven decision making. As an Associate Data Engineer, you will collect, transform, and visualize data, while building and maintaining data processing systems with a strong emphasis on security and reliability.
EducationConsultingWellnessRetirementTraining
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
Qualification
Required
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
Build Power BI dashboards and reports that translate data into clear, decision‑ready insights for stakeholders
Preferred
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
Experience with PowerBI, Cognos Analytics and Cognos Framework Manager
Benefits
401(k) match
Medical
Dental
Vision
Paid-Time-Off
Company
Ascensus
Ascensus delivers high-quality solutions for every segment of the retirement plan marketplace.
5001-10000 employees
H1B Sponsorship
Ascensus has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2024 (7)
2023 (9)
2022 (23)
2021 (14)
2020 (19)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Atlas Merchant Capital
2021-04-26Acquired
2019-02-19Secondary Market
Leadership Team
Marc Mehlman
Chief Financial Officer
Marc Doucette
Regional Vice President
Recent News
2026-01-20
2026-01-16
Company data provided by crunchbase