Senior Data Engineer

Ascensus
Remote, PA
15 Oct 2024

Vacancy expired!

At Ascensus,

technology is more than just a solution. It powers the business that helps millions of people save for what matters—retirement, education, and healthcare. Our technology experts tackle exciting challenges in collaborative teams, but work in an environment where individual and career development is always valued. Technology associates leverage their talents and passion, building new and innovative platforms, creating programs founded in automation in agile frameworks, and driving existing and new markets—all of which supports the rapid growth of a dynamic industry leader.

Section 1: Position SummaryAs a Senior Data Engineer at Ascensus, you will enable data-driven decision making by collecting, transforming and visualizing the data. You will design, build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault-tolerance, scalability, fidelity, and efficiency. You will be part of the Enterprise Information Management (EIM) team.

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.
  • Design, 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.
    • Create conceptual, logical and physical data models.
    • Create Entity Relationship diagrams and Dimensional models.
  • Data Integration
    • Services
    • Design and build data ingestion tools, metrics, alerts and notifications, metadata management.
    • 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.
  • ETL development
    • Contribute to 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
    • Develop technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management.
    • Organize metadata and define 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
  • 3+ 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.
  • Strong knowledge of SQL.
  • Good understanding of data modeling techniques.
  • Good knowledge of Data Warehousing and ETL design/tools.
  • Working experience with C# or other data related programming languages.
  • Very good SSIS skills.
  • Working experience with SQL Server.
Preferred knowledge, skills and abilities:
  • Experience with relational databases: Sybase ASE, Oracle, MySQL.
  • Experience with data modeling using IDERA?s Embarcadero ER/Studio Data Architect.
  • Experience with SSAS.
  • Experience with PowerBI a plus
  • Experience with cloud and advancing warehouse technologies a plus

We are proud to be an Equal Opportunity Employer At Ascensus, we aspire to make a difference for others. We are a technology-enabled services company that helps people save for retirement, education, and healthcare through our network of institutional, financial advisor, and state partners. Our culture is guided by sound principles, is committed to high standards, operates with transparency, and welcomes diversity—housed within our Core Values: People Matter. Quality First. Integrity Always.®As a leading independent recordkeeping services partner, retirement plan third-party administrator, and government savings facilitator, we aim to hire associates who find pride in going to work every day knowing that they help more than 12 million people save for what matters.
  • ID: #46479986
  • State: Pennsylvania Remote 00000 Remote USA
  • City: Remote
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2022-10-15
  • Deadline: 2022-12-12
  • Category: Et cetera