Senior Data Engineer

Job Description:

Job Title Senior Data Engineer

Locations: Remote/Hybrid

Get To Know The Team:

DomaniRx is a newly formed organization focused on shaping the future of Pharmacy Benefit Management by delivering an API-driven claims adjudication platform in a private cloud environment. Our DomaniRx Data Integration team consists of software and data engineers with varying backgrounds and levels of professional experience. Our chief responsibility is to integrate data from various source databases into our downstream Operational Data Store (ODS) and Data Warehouse environments.

We’re looking for an additional self-motivated individual who enjoys being challenged and has a strong desire to make our platform the best in the industry. Relevant industry experience is important, but less so than your demonstrated skills, passion, attitude, and taking ownership of assigned work. As a Senior Data Engineer on this team, you will use Informatica Intelligent Cloud Services (IICS) for ETL purposes and also IBM InfoSphere Data Replication (IIDR) for replication purposes.

Why You Will Love It Here!

• Flexibility: Hybrid Work Model & a Business Casual Dress Code, including jeans
• Your Future: 401k Matching Program, Professional Development Reimbursement
• Work/Life Balance: Flexible Personal/Vacation Time Off, Sick Leave, Paid Holidays
• Your Wellbeing: Medical, Dental, Vision, Employee Assistance Program, Parental Leave
• Diversity & Inclusion: Committed to Welcoming, Celebrating and Thriving on Diversity
• Training: Hands-On, Team-Customized, including SS&C University
• Extra Perks: Discounts on fitness clubs, travel and more!

What You Will Get To Do:

• Develop and automate large-scale, high-performance data solutions using Informatica Intelligent Cloud Services (IICS) that ensure reliability, meet critical business requirements, and satisfy SLAs
• Build a reliable and scalable Single Source Of Truth (SSOT) data environment for internal and external reporting and analytics
• Partner with data analysts and other data engineers to translate business requirements into designs for scalable data pipelines with measurable transformation quality
• Build, maintain, and monitor optimized and highly-available data pipelines for near-real-time data replication and transformation between databases
• Work within an Agile scrum methodology to design, develop, test, and implement a multi-layer OLAP data warehouse including raw, cleaned, and business-ready data
• Organize and maintain documentation for ETL pipelines and other data-related processes
• Work proactively as a self-starter with minimal supervision
• Build replication subscriptions in IBM InfoSphere Data Replication (IIDR) to replicate data from DB2 to Postgres
• Production Support of ETL and replication processes on a rotational basis

What You Will Bring:

• Bachelor’s degree in Computer Science/Engineering, Applied Mathematics, Data Analytics, or related technical field (or equivalent work experience)
• 5+ years of experience in a data engineering role in a fast-paced environment and complex business setting
• 5+ years of experience with relational databases like Postgres
• 3+ years of experience with advanced SQL concepts and performance tuning in OLAP databases such as Data Warehouse, Data Lake, and ODS environments
• 3+ years of experience building ETL data pipelines using Informatica Intelligent Cloud Services (IICS)
• Excellent written and verbal communication skills

Additional Qualifications

Experience with data replication (change data capture) using IBM InfoSphere Data Replication (IIDR) Familiarity with work management and version control solutions like JIRA and GitHub

.SS&C is an equal opportunity employer and values a diverse and inclusive workplace. All qualified candidates will receive consideration for employment without regard to age, race, color, religion, genetic information, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.