Fresher & Experienced IT Jobs: {SAP JOBS USA:161327} Sr. Data Engineer @ Philadelphia, PA (Onsite Interview)

Tuesday, March 8, 2016

{SAP JOBS USA:161327} Sr. Data Engineer @ Philadelphia, PA (Onsite Interview)

Hi,

I am writing to see if you or anyone you may know of is interested in the below position, please email me resume at your earliest convenience along with the details requested below the job description.

Sr. Data Engineer

Philadelphia, PA (Onsite Interview)

10 Months

The specifics of the role are listed here:

Provides technical direction to the implementation, development, and support for all data, metadata and database development related activities for Enterprise Systems. Plans and designs the services and systems required to support the various data initiatives with the enterprise. Responsible for establishing, implementing and enforcing policies, procedures and priorities supporting the use and management of data within these systems.

Primary Duties and Responsibilities:

Provides the technical direction for most significant and most complex technical matters regarding the Information Technology systems. Works closely with the Project Manager to identify tasks, timing estimates and scheduling of resources. For assigned projects, the Sr. Data Engineer is the lead data resource on the project and is expected to effectively perform the following project tasks:
- Development and support of Logical and Physical data models, both 3rd normal form and dimensional, in Erwin or current tool.
- DB implementation and DDL management
- Perform Data conversion, Profiling, Quality and Verification activities.
- Support production and development troubleshooting of data defects with transactional systems, reports, data integration (ETL) platform and Information Management repositories (data warehouse, operational data stores).
Work closely with the Information Architect to tactically design, implement and maintain the data, metadata and database development activities in IT solutions and data related systems used extensively within the corporation.
Assesses the efficiency and effectiveness of data usage within the enterprise systems to ensure user requirements are met in a timely and cost effective manner. Assists in tool selection, establishing process/procedures and implementation of data profiling and data quality analysis. Develops enterprise data standards to provide the flexibility to meet future needs. Identifies and recommends solutions which have enterprise wide application. Ensures that the data requirements in the IT Development Life Cycle are met by formalizing deliverables, creating standards, implementing tools, processes and procedures and conducting peer reviews.
Reviews and maintains the compliance of systems to standards to assure future flexibility and maintainability. Ensures compliance of enterprise systems to both internal and external audits.
Provide leadership in the evaluation and modification of the existing technology to take into account changes in business requirements, equipment configurations, or software compliance.
Provides mentoring and guidance to other technical staff. Train and develop staff to support IT systems.

Knowledge:

8+ years of data analysis, data integration, data migration and modeling for transactional systems, operational data stores and data warehouses. Experience with modeling tools like Erwin and model management.
5+ years of PL/SQL experience, Oracle DBA, SQL Server Transact or SQL Server DBA in DBA or database developer role.
Experience and skilled in data performance optimizations, archiving and recovery strategy, load strategy design and implementation.
Experience with one or more AWS data platforms: RDS, Redshift and/or EMR.
Experience with one or more continuous integration, development and version control tools using GIT, Jenkins and AWS Tools.
Scripting: Perl, Python, Java, JavaScript, Ruby
Hadoop related: Hive, MapReduce (in Python, Java or any other tool) and/or Pig, Spark

Skills and Abilities:

High level of energy and enthusiasm, strong interpersonal, organizational and advanced problem solving skills.
Needs to be resilient; resolving conflicts quickly to achieve desired business results.
Demonstrated ability to build and deliver technology strategy and solutions. Experience in developing complex, scalable systems. Excellent analytical ability, strong judgement and problem analysis techniques.
Excellent verbal written communication both written and verbal required. Must be able to write both technical and non-technical documentations to be understood and read by all levels within the organization.
Proven past experience with metadata management, knowledge management, content management, document management and taxonomy development.
Familiarity with packaged application (Peoplesoft, Documentum, GuideWire, WebLogic Portal, etc.)
Practical technical and application knowledge in multiple BI/DW technologies (Tableau, SSIS, SSAS, SSRS, BRIO, Informatica, SAS, etc).
Prior experience in other database technologies, i.e. SQL Server, Access, etc.

Prior Work Experience: