Associate Data Engineer

Ascensus is a company focused on enabling data-driven decision making. As an Associate Data Engineer, you will collect, transform, and visualize data, while building and maintaining data processing systems with a strong emphasis on security and reliability.

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

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
• Build Power BI dashboards and reports that translate data into clear, decision‑ready insights for stakeholders
• 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