Associate Data Engineer
Share
Job Location:
Newton, MA - USA
Monthly Salary:
$ 75 - 85
Posted on:
19 hours ago
Vacancies:
1 Vacancy
Job Summary
Section 1: Position Summary
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
Section 2: Job Functions Essential Duties and 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.
- BuildPower BI dashboards and reports that translate data into clear decisionready 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.
- Data Modeling
- Assist with conceptual logical and physical data models.
- Update the Entity Relationship diagrams and Dimensional models.
- Data Integration
- Services
- 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.
- Services
- ETL development
- 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.
- Data Warehouse and Data Marts
- 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
Supervision
- N/A
Section 3: Experience Skills Knowledge Requirements
Required skills and experience
- 1 years of relevant experience in data/software development including data warehousing and ETL tools techniques and technology.
- Bachelors 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.
Preferredknowledge skills and abilities:
- Experience with relational databases: SQL Server Sybase ASEOracle MySQL.
- Experience with NoSQL databases such as MongoDB Redis.
- Experience with Fabric.
- Experience with data modeling tools like IDERAs Embarcadero ER/Studio Data Architect.
- Experience with SSIS.
- Experience with SSAS.
- Experience with PowerBICognos Analytics and Cognos Framework Manager. <-- Maybe put PowerBI under Required
We are proud to be an Equal Opportunity Employer
The national average salary range for this role is$75-85k in base pay exclusive of any bonuses and 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 aware of employment fraud. All email communications from Ascensus or its hiring managers originate from @ or @ email 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.
Required Experience:
IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Everyone deserves to feel financially secure. We help more people save through partnerships with leading financial institutions and state governments.
