Data Engineer

SSIS, Informatica, ETL , dimensional data modeling and OLAP, SSMS, application design, software development, and automated testing,SQL, Data Warehouse methodologies
Full Time
Depends On Experience
Work from home not available Travel not required

Job Description

Tabula Rasa Health Care– TRHC is a family of companies that leverages technology to improve healthcare. TRHC works with providers and insurers to identify multi-drug interactions and to reduce risk of medication-related problems. We have developed the first multi-drug interaction tool that identifies risk across a variety of safety factors and presents meaningful opportunities to mitigate that risk. This technology can be used to assess safety at the individual patient-level or to stratify medication risk at the population-level, and can be embedded within any EMR or other healthcare IT system.

Tabula Rasa Health Care is looking for a Big Data Engineer to work with IT, business analysts and application developers to define and program ETL solutions. The Big Data Engineer will be responsible for creating, developing, investigating, mapping and testing the various data needs. This position requires that the Developer be an expert on data availability and quality, have a strong understanding of the business requirements, and the creativity to develop workable solutions for a wide range of customers.


  • Build and maintain SQL Server Integration Services (SSIS) jobs
  • Migrate SSIS jobs over to new Informatica environment
  • Document ETL processes, programs and solutions
  • Develop and test new ETL processes
  • Design and build data structures and processes to populate data warehouse tables
  • Manage post-production data quality monitoring
  • Quickly identify and resolve data- and migration-related production issues
  • Acquire data from primary or secondary data sources and maintain data systems and integrity
  • Develop procedures to enhance reporting and query capabilities to improve efficiency and accuracy
  • Develop innovative approaches to manipulate data sets in a way that enables clients to see patterns and trends
  • Work with key stakeholders to ensure integrity and proper integration for all sources of enterprise data
  • Provide technical leadership in the area of big data systems development including data ingestion, data curation, data storage, high-throughput data processing, user access, and security.
  • Stay current on big data trends and research various technologies as they become relevant.
  • Provide software coding leadership, guidance, and quality adherence in languages such as Python, Java, JavaScript, React, Node.js, SQL, NOSQL, etc.


Education, Experience & Training:

  • A BS degree in computer science, computer engineering, other technical discipline, or equivalent work experience
  • Exceptional skills in relational database systems (MS SQL Server, MySQL, Oracle)
  • Strong ability with dimensional data modeling and OLAP principles
  • 3+ years’ experience working with ETL Tools (MS SSIS Packages, SSMS, Informatica)
  • Experience with NoSQL (Mongo, Couch) and columnar databases a plus
  • Knowledge of Python will be a plus
  • Hands-on expertise with application design, software development, and automated testing
  • Prior experience with compliant (e.g. HIPAA, 21 CRF Part 11) systems, processes and operations development is preferred
  • Ability to identify and diagnose ETL and database related issues, perform root cause analysis, and recommend corrective actions

Specific Skills:

  • Solid understanding of Data Warehouse methodologies
  • High proficiency with SQL (MySQL, SQL Server, Oracle, DB2)
  • Excellent communication skills
  • Working knowledge in Software Development Life Cycle
  • 3 years of experience with Big Data Components/Frameworks (Hadoop, HBase, MapReduce, HDFS, Pig, Hive, Sqoop, Flume, Ozie, etc.)


  • Overall competency in business and technology
  • Excited & motivated to learn new technologies
  • Sense of urgency to attend to IT leadership demands
  • Responsive and prompt communication
  • Customer-service oriented
  • Excellent time management
  • Excellent verbal and written communication skills
  • Self-motivated, team player, highly organized
  • Attention to detail and accuracy of facts and documentation
  • Ability to manage multiple priorities and work independently
  • Ability to problem-solve and ability to follow through on tasks
Dice Id : 90940972
Position Id : 634582
Have a Job? Post it

Similar Positions

Big Data Engineer
  • Strivector
  • Philadelphia, PA
Big Data Developer
  • NextGen Global Resources LLC
  • Philadelphia, PA
Senior Hadoop, Spark, Scala Developer -- Fulltime
  • Nityo Infotech Corporation
  • New York, NY
Hadoop Engineer
  • Beacon Hill Technologies
  • Plymouth Meeting, PA
Big Data Engineer/Analyst
  • Avenues International, Inc.
  • Camden, NJ
Big Data Engineer
  • PeopleCaddie
  • Philadelphia, PA
Big Data with Kafka and Spark
  • SightSpectrum LLC
  • Philadelphia, PA
Hadoop Kafka Engineer
  • Collaborative Systems Inc
  • King Of Prussia, PA
Big Data/Hadoop Developer
  • Lawrence Harvey
  • Plymouth Meeting, PA
Sr Developer (Hadoop)
  • SwitchLane Inc.
  • Philadelphia, PA
Senior Data Engineer
  • InSource, Inc.
  • Philadelphia, PA
Application Data Engineer
  • Signature Consultants
  • Pennington, NJ
Senior Hadoop Developer- Only Locals
  • Dotcom Team, LLC
  • Philadelphia, PA