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. As a Senior Data Engineer, you will enable data-driven decision making by collecting, transforming and visualizing data, while designing and maintaining data processing systems. You will be part of the Enterprise Information Management team.

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
• 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
• Create conceptual, logical and physical data models
• Create Entity Relationship diagrams and Dimensional models
• Design 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
• Contribute 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
• Develop 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 staff
• Serve in an on-call rotation for production issues / outages
• Assist with other tasks and projects as assigned

Requirements:

• 5+ 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 analysis
• Proven experience diagnosing and remediating performance issues
• Strong 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 reviewing
• 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