Sr Data Engineer - AWS and Oracle cloud - Parsippany, NJ

Job Description

Database Management / Architecture (competent)

• Maintains awareness of modelling techniques covering full range of analysis situations in the context of business analysis.
• Selects appropriate modelling techniques for meeting assigned objectives, and models current and desired future scenarios as directed.
• Works with clients/users and development groups to identify most appropriate and effective use of DB facilities and set strategy and standards for whole application areas.

Data Management (competent)

• Leads the quality assurance of corporate data structures, and project developed data structures and associated components (e.g. Entity descriptions, Relationship descriptions, Attribute definitions).
• Works with data management colleagues to ensure that modelling is carried out consistently, and that corporate standards for repository administration and data dictionaries are observed.
• Contributes to the setting of standards for database objects (e.g. naming conventions) and ensures conformance to these standards.

Application Maintenance & Delivery (competent)

• Within a project environment, assists in the investigation of application data and process requirements, documenting them according to the required standards utilising the prescribed methods and tools.

Programming & Application Development (competent)

• Interprets design architecture to meet specification e.g. assistive technology, parallel processing.
• Takes responsibility for the design, coding, testing and documentation of particularly large, complex or mission critical programs.

Analysis (competent)

• Analyses requirements for fitness for purpose as well as adherence to business objectives and consistency, challenging positively as appropriate.

Communication lines

• Scrum Team, Business Owner, Scrum Master
• Architecture Team
• IT Experts and Teams
• Support Teams (Platform, Operations)
• Business SMEs, Stakeholders

Qualifications

Minimum University / College degree in preferably IT domain, or Business/Economics

4-5+ years of relevant work experience in data engineering and/or business intelligence

Experience/Requirements

• Solid expertise in many areas of data engineering, including: data modelling, ETL design and development, data and metadata managements., query design/development/tuning, database optimization, data governance, data quality, best practices
• Understanding of databases and data technologies including: traditional RDMBS, noSQL, data stream solutions
• Strong understanding of cloud (AWS) platforms and design patterns
• Regularly makes commitments and consistently meeting targets
• The role requires to have eagerness and ability to learn and adapt technologies, industry practices, tools, and trends
• Solid experience with Python/SQL and Redshift or Postgres
• Experience processing JSON, Avro JSON and other file formats
• Nice to have: Experience with BI tools: Tableau, PowerBI, Airflow or other ETL tool

Compensation, Benefits and Duration

Minimum Compensation: USD 48,000
Maximum Compensation: USD 168,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is also available for independent contractors
No applications will be considered if received more than 120 days after the date of this post