Follow Us


image for Ascensus job detail page
Share this post

Apply Now    

Senior Software Engineer

Location:Newton, MA
Level:Full Time
Category: Information Technology


In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux based 
Oracle 11g RAC 2 node cluster. The Data Warehouse is currently under development and you will be an integral part of its design and implementation. 
You will support key strategic initiatives, including the integration of new lines of business, design and implementation of data marts and subject areas, 
and key decisions around the future of the data warehouse. You will also be involved with the implementation of new reporting tools, new ETL routines and other projects 
that are core to developing and enhancing the data warehouse environment.

Essential Job Functions:

1. Utilize excellent hands-on PL/SQL skills to design and implement data warehouse subject areas.

2. Develop high performing extraction, transformation and loading (ETL) routines for loading data from our production database into the data warehouse.

3. Create PL/SQL that performs well with large data sets, is written to scale for future growth and adheres to business rules.

4. Effectively integrate new lines of business into the DW requiring the addition of new data sources into existing tables and data marts.

5. Share knowledge and PL/SQL expertise and mentor team members in the design of efficient reporting queries.

6. Team with engineering, IT and business stakeholders to support projects of varying complexity; gather reporting and data warehousing requirements, 
evaluate best approach and propose solutions.

* BS and 5+ years developing PL/SQL code
* At least 3-5 years of hands on development experience within an Oracle Data Warehouse environment utilizing PL/SQL; this must include experience working with Oracle 10g or above. 
* Strong database analysis and design skill are essential as are data warehousing principles like dimensional modeling, de-normalized data structures and star schema design. 
* Knowledge of Oracle DWH features such as Materialized Views, Query Rewrite, Parallelism, Partitioning, Analytic Functions, OLAP or Enterprise Manager required.
* Strong business acumen and excellent service delivery and communication skills are required to succeed in this role.


* SQL Tuning skills is a plus.

* Financial experience is a plus. 

Ascensus is a place to have a career, not just a job. As the largest US independent retirement and college savings services provider, we put our focus on people.  Our culture is guided by sound principles, is committed to high standards, operates with transparency, and welcomes diversity. When you join our team, you get to go to work every day knowing that you help over 6 million Americans save for retirement and college.


Ascensus is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, national origin, ancestry, religion, age, citizenship, sex, marital or veteran status, disability or handicap, sexual orientation or any other basis prohibited by applicable law. Ascensus also takes affirmative action to employ, and advance in employment, qualified women, minorities, and covered veterans. Ascensus also makes reasonable accommodations for qualified individuals with disabilities, in accordance with the Americans with Disabilities Act and applicable state laws


Apply Now    
Link for schema

What makes any career at Ascensus so rewarding?

  • Collaborative, idea-sharing environment
  • Professional development
    • In-house training
    • Tuition reimbursement
  • Generous reward programs
  • Paid time off (additional purchase plan)
  • Medical, dental & vision benefits
  • Health savings account (employer contribution up to $1,100)
  • 401(k) & 529 match programs
  • Volunteer/charitable-giving programs
  • Business casual dress
Powered by SmashFly