Associate Data Engineer

Ascensus•Newton, MA

17h•$75 - $85

About The Position

As an Associate Data Engineer at Ascensus, you will enable data-driven decision making by collecting, transforming and visualizing the data. You will build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault 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.

Requirements

1+ 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.
Working experience with SQL.
Understanding of data modeling techniques.
Understanding of Data Warehousing and ETL design/tools.
Working experience with C# Python or other data related programming languages.

Nice To Haves

Experience with relational databases: SQL Server, Sybase ASE, Oracle, MySQL.
Experience with NoSQL databases such as MongoDB, Redis.
Experience with Fabric.
Experience with data modeling tools like IDERA’s Embarcadero ER/Studio Data Architect.
Experience with SSIS.
Experience with SSAS.
Experience with PowerBI, Cognos Analytics and Cognos Framework Manager.

Responsibilities

Build Power BI dashboards and reports that translate data into clear, decision‑ready insights for stakeholders
Build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services).
Assist with EIM project definition and planning.
Implement and troubleshoot deployments.
Assist with conceptual, logical and physical data models.
Update the Entity Relationship diagrams and Dimensional models.
Build data ingestion tools, metrics, alerts and notifications, metadata management.
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.
Follow 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.
Follow technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management.
Build processes for loading data into and extracting data from the warehouse / marts.
Assist with other tasks and projects as assigned