Find Jobs Find Talent
Data Engineer
Horsham, PA  |  Remote, Onsite
Contract to Hire Position
It appears that you have already applied to this job.
Applied on January 28, 2023
Job Id #61389 Posted January 19, 2023

Projects the candidate will be working on:                                                                 
  • Data profiling and analysis, test data governance
  • Conduct ETL / DW, Test Repository Gold Copy optimization, troubleshooting , debugging, Maintenance of Data Masking mapping & workflows.
  • Develops complex data extracts, applications and ad-hoc queries using DB/ & ETL Tools: Informatica Power Center and/or Informatica Cloud.
  • Work with the project team (both technical and business) to establish data requirements from all upstream data sources, ensures requirements are accurate and clearly understood by those participating in the project
  • Designs, develops, and implements solutions that exemplify modern data & software engineering practices
  • Reuses and/or develops for reuse complex components or capabilities to solve complex problems and needs, enhances system design/architecture to simplify and improve resiliency in system interactions and dependencies
  • Anticipate emerging customer needs and develops cost friendly innovative solutions to meet them - Incorporates business objectives when evaluating processes to remove redundancies and waste, considers the customer experience, business impact and solution objective when managing risks and development and design of solution, Work on Proof of Concepts for Big Data and Data Science
  • Maintains current perspective on technology trends, applying that to personal and team capability growth. Implement strategies directed at acquiring data and promoting the development of new insights across the business
  • Sorts through large amounts of data to assess for relevancy, seeks out multiple sources to gather information
  • Identifies cause and effect relationships between known and unknown variables
  • Develop tools, techniques, and metrics, and dashboards for insights and data visualization
  • Support practices, policies and operating procedures and ensures alignment to departmental objectives and strategy
  • Identifies applicable security/data standards when reviewing requirements and recommends controls to ensure compliance, Pro-actively monitors adherence of assigned systems to recommended security settings
  • Help define acceptance test objectives, test cases, and assist in system and integration testing
  • Build solid relationship with IT operational leaders to ensure connectivity to the business
  • Define best practices and standards for analyzing and processing data. Contribute to technical documentation of specifications and processes
  • Collaborate with teammates, stakeholders, and other teams to identify and address systems problems, provide input on current and new designs and resolve issues
  • Implements and continuously improves agile software delivery, code management, and operations practices
Ideal Background:
  • Computer Science bachelor’s degree or equivalent.
  • 3+ years of Data Engineering experience
  • 3+ years of experience working with relational databases (ORACLE, DB2), Writing Complex SQL Queries
  • 3+ years of experience with data warehouses/marts, relational database architecture, design, and development
  • 2+ years of experience Building ETL/data pipelines using Informatica
  • 2+ years of Python experience, BOT Development
  • 2+ years of Unix scripting experience
  • Experience working in projects with agile/scrum methodologies
  • Research, writing, and communication skills
  • Ability to work in a team-oriented, fast-paced Agile environment managing multiple priorities
Team and Team size:
  • 1 Sr.Manager, Product Development, 1 project manager/scrum master, 10 developers
Top Responsibilities:
  • Data profiling and analysis – using Tableau or MicroStrategy , DB Tools rnance
  • Conduct ETL / DW, Test Repository Gold Copy optimization, troubleshooting , debugging, Maintenance of Data Masking mapping & workflows.
  • Develops complex data extracts, applications and ad-hoc queries using DB/ & ETL Tools: Informatica Power Center and/or Informatica Cloud.
  • Work with the project team (both technical and business) to establish data requirements from all upstream data sources, ensures requirements are accurate and clearly understood by those participating in the project
  • Reuses and/or develops for reuse complex components or capabilities to solve complex problems and needs, enhances system design/architecture to simplify and improve resiliency in system interactions and dependencies
Skills/attributes:
  • 3+ years of Data Engineering experience
  • 3+ years of experience working with relational databases (ORACLE, DB2), Writing Complex SQL Queries
  • 3+ years of experience with data warehouses/marts, relational database architecture, design, and development
  • 2+ years of experience Building ETL/data pipelines using Informatica
  • 2+ years of Python experience, BOT Development
  • 1+ years of Unix scripting experience
Nice to have:
  •  Healthcare Industry experience
  • Developing & implementing scalable cloud solutions to match the business’s changing needs
  • Experience with Business intelligence Tools e.g. MicroStrategy & Tableau for data mining, data profiling
  • Experience in complex projects with division or company-wide scope
  • Experience in Java application deployments, CI/CD pipeline , development experience in Java and knowledge of micro service architecture
  • Knowledge of Apache Kafka, and micro-service is a plus
  • Exposure & some experience in the following technologies
  • DevOps
  • Kafka

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact hr@horizontal.com.

All applicants applying must be legally authorized to work in the country of employment.

EQUAL OPPORTUNITY EMPLOYMENT SURVEY

What is your gender?

What is your ethnicity?

What is your Veteran / U.S. Military Status?

Do you identify with one or more of the classifications of protected veterans below?

If yes, please indicate by checking the appropriate box below

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.

Success!

You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search
Close

We’re sorry!

There are currently no open positions in your location or accepting applications from out of the country

Return to Home
Close
X
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.
Confirm