Associate Data Engineer

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

• 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.
• 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.
• 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.
• 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

• N/A

Required skills and experience

• 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.

• Experience with relational databases: SQL Server, Sybase ASE,Oracle, MySQL.
• 
  
  Experience with No
  
  SQL databases such as Mongo
  
  DB, 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 Power
  
  BI,Cognos Analytics and Cognos Framework Manager.