Ascensus

Senior Data Engineer

Newton, Massachusetts, USA · Senior · full-time

Sponsorship not specified$120k-$140kDetected 46 days ago

PythonData StructuresCode ReviewSQLCI/CDPandasData AnalysisData EngineeringAgentic AICommunication

About the role

As a Senior Data Engineer at Ascensus, you will enable data-driven decision making by collecting, transforming and visualizing the data.
You will be part of the Enterprise Information Management (EIM) team.
Use Artificial Intelligence to accellerate development of ETL components and Data Analysis.

You will design, build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault-tolerance, scalability, fidelity, and efficiency.
Our I-Client service philosophy and our Core Values of People Matter, Quality First and Integrity Always&REG; should be visible in your actions on a day to day basis showing your support of our organizational culture.
Implement and troubleshoot deployments.
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.
Build and maintain ETL solutions and platform.
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.
Design, build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services).
Create Entity Relationship diagrams and Dimensional models.
Data Integration Services Design and build data ingestion tools, metrics, alerts and notifications, metadata management.

Experience, Skills, Knowledge Requirements Required skills and experience 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.
Strong knowledge of Oracle PL/SQL or other database programming languages.
Good experience with relational databases like Sybase ASE, Oracle, MySQL.
Good knowledge of SSAS.
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.
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.com email addresses.

ETL development Contribute to standards and best practices for implementing ETL tools in support of the EIM vision and reference architecture.

This listing is sourced directly from Ascensus's careers page and normalized into a canonical job model.