Senior Data Engineer

Ascensus is the leading independent technology and service platform powering savings plans across America, providing products and expertise that help nearly 16 million people save for a better today and tomorrow.Section 1: Position SummaryAs a Senior Data Engineer at Ascensus, you will enable data-driven decision making by collecting, transforming and visualizing the data. You will design, build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault-tolerance, scalability, fidelity, and efficiency. You will be part of the Enterprise Information Management (EIM) team.Section 2: Job Functions, Essential Duties and ResponsibilitiesResponsible 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.Use Artificial Intelligence to accellerate development of ETL components and Data Analysis.Design, 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 ModelingCreate conceptual, logical and physical data models.Create Entity Relationship diagrams and Dimensional models.Data IntegrationServicesDesign and build data ingestion tools, metrics, alerts and notifications, metadata management.Design and 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 developmentContribute to 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 MartsDevelop technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management.Organize metadata and define processes for loading data into and extracting data from the warehouse / marts.Proactively mentor junior staffServe in an on-call rotation for production issues / outages Assist with other tasks and projects as assignedSection 3: Experience, Skills, Knowledge RequirementsRequired skills and experience5+ 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.Strong knowledge of Oracle PL/SQL or other database programming languages.Very good understanding of data modeling techniques.Strong knowledge of Data Warehousing and ETL design/tools.Good experience with relational databases like Sybase ASE, Oracle, MySQL.Good knowledge of SSAS.Good experience utilizing AI Agents for both code generation as well as code and data analysisProven experience diagnosing and remediating performance issuesStrong understanding of data storage, partitioning, and retention policies.Strong understanding of star schema data models Ability to perform code reviews and provide actionable feedback while reviewingPreferred knowledge, skills and abilities:Experience with python for data manipulation and analysis, IE. Pandas, PySpark Experience with data modeling using IDERA’s Embarcadero ER/Studio Data Architect.Experience with PowerBI or similar data reporting platforms is a plus.Experience with CI/CD for database deployments utilizing Liquibase or similar CI/CD tool a plus.The national average salary range for this role is $120-140k in base pay, exclusive of any bonuses and benefits. This base salary range represents the low and high end of the salary range for this position. Actual salary offered will vary and may be above or below the range based on various factors including but not limited to location, experience, performance, and internal pay alignment. We do not anticipate that candidates hired will begin at the top of the range however, from time to time, it may occur on a case-by-case basis.  Other rewards and benefits may include: 401(k) match, Medical, Dental, Vision, Paid-Time-Off, etc.  For more information, please visit careers.ascensus.com/#Benefits.Be aware of employment fraud. All email communications from Ascensus or its hiring managers originate from @ascensus.com or @futureplan.comemail addresses. We will never ask you for payment or require you to purchase any equipment. If you are suspicious or unsure about validity of a job posting, we strongly encourage you to apply directly through our website.SummaryLocation: Newton, MA; Remote, NationwideType: Full time