> Markdown version of [/jobs/ext/618784-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/618784-senior-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Engineer - **Company:** Ascensus, LLC - **Location:** Newton, MA, United States - **Experience:** Expert - **Salary:** $120,000.0 - $140,000.0 - **Contract:** Permanent contract - **Skills:** SAP Sybase Adaptive Server Enterprise, Artificial Intelligence, Data Analysis, Code Generation, Code Review, Databases, Continuous Integration, Data Architecture, Data Integration, Extract Transform Load (ETL), Data Mart, Data Warehousing, Relational Databases, Dimensional Modeling, Entity Relationship Models, Liquibase, Metadata, Meta-Data Management, MySQL, Oracle (Applications), Oracle SQL Developer, Power BI, Software Engineering, SQL Server Analysis Services, Data Processing, Data Storage Technologies, Data Ingestion, Change Data Capture, Pandas, Build Management, Pyspark, Star Schema, Database Replication - **Published:** June 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=b08b09c902350587 ## About the Role Do you have experience in Writing skills?, Do you have a Bachelor's degree?, * 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 Preferred 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. ## Description * 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. * Data Modeling + Create conceptual, logical and physical data models. + Create Entity Relationship diagrams and Dimensional models. * Data Integration + Services o Design and build data ingestion tools, metrics, alerts and notifications, metadata management. o 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 development o Contribute to standards and best practices for implementing ETL tools in support of the EIM vision and reference architecture. o Build and maintain ETL solutions and platform. o Participate in creating long term ETL application support model. * Data Warehouse and Data Marts + 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 ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)