Careers

Search Jobs Connect With Us

Data Engineer (informatica)

Job Attributes

Job Id:

21522

Job Category:

Data Analytics & Business Intelligence

Job Location:

Owings Mills, MD  21117

Security Clearance:

No Clearance

Business Unit:

Piper Companies

JOB DESCRIPTION

Data Engineer  (Informatica)

Job Description:

Piper Companies is seeking a candidate to become a part of a diverse team that provides support to the End Stage Renal Disease (ESRD) value-based purchasing programs administered by the Centers for Medicare & Medicaid Services (CMS). The team provides the full lifecycle development and support necessary to consolidate the following three existing legacy applications into a single redesigned application called ESRD Quality Reporting System.

• The Consolidated Renal Operations in a Web-Enabled Network (CROWNWeb)

• The Renal Management Information System (REMIS)

• The ESRD Quality Incentive Payment (QIP) System

 

The Data Engineer is an accomplished technical leader, proactive customer-focused advocate, a team player with substantial software engineering experience, preferably with some experience within the healthcare industry. The Data Engineer must have hands-on experience with enterprise level software development, integration and implementation. Big data experience is a plus. The ideal candidate will have an advanced understanding of ETL & ELT, data ingestion, data discovery & analysis, data cleansing, data transformation, data visualization, and SQL/data modeling. The candidate must demonstrate the ability to evaluate cutting edge technologies and overcome technical challenges in a fast paced environment. The Data Engineer will play a key role of migrating three enterprise applications into a consolidated application which leverages DevOps, cloud computing, and data lake / big data technologies.

 

General Responsibilities:

Architect, design, develop, implement, and maintain code, information architecture, and conceptual models to support data processing,  and flows thru data lake

  • Landing Zone  - data ingestion of raw data or capture of streaming data
  • Discovery Zone – evaluate data quality, transform raw data, and cleanse data
  • Enterprise Zone – transform into data model for external consumption by reporting & self-service BI

Develop data & metadata policies and procedures

Review and evaluate database performance, risk and financial analysis feasibility studies 

Investigate and repair application defects regardless of component including platform, business logic, data process logic, or database (SQL and data modeling).

All other duties as assigned or directed

Qualifications:

Bachelors of Science (or higher) in computer science or related field

8+ years of systems/application analysis & design experience

5+ years of combined experience ETL (e.g. Informatica, Talend, or other ETL tool)

  • At least 3 years of experience with Informatica

Technical Skills

Excellent knowledge of relational databases (PostgreSQL, Oracle, RDS) including SQL, stored procedures, data modeling

Excellent knowledge of SQL, complex SQL tuning, and data warehouse best practices

Basic knowledge of Unix/Linux commands especially in processing data files

Preferred experience with ATTD and associated technologies (Fitnesse, DBSlim, Junit)

Preferred experience with delivering code using Continuous Integration and Continuous Delivery (CI/CD) best practices and DevOps

Preferred experience with AWS or other cloud platforms.

Preferred experience with Big Data (Cloudera) & Java integration

Other

U.S. citizen or legal right to work in the United States without sponsorship

Location: Owings Mills. MD

Apply Now

CONTACT INFORMATION (Required)
RESUME (Required)
No file selected
x
Formats accepted: .doc / .docx / .pdf / .txt
Don't have a resume? Click here to fill out a short form.

Copy/paste your resume inside the text editor below:

ADDITIONAL INFORMATION (Required)
WORK HISTORY (Required)
Add another experience (optional)
EDUCATION (Required)
Add another degree (optional)
SKILLS (Required)
Add another skill (optional)

The following error(s) occurred:

Please wait while your job application is being processed. This may take a few moments.
New Search

Job Id:

21522

Job Category:

Data Analytics & Business Intelligence

Job Location:

Owings Mills, MD  21117

Security Clearance:

No Clearance

Business Unit:

Piper Companies