Data Engineer - New York, United States - GrahamStak

Description

POSITION SUMMARY:

We are looking for a Full Stack Data Developer to maintain and support various databases used by the Office of

Enforcement and Neighborhood Services (ENS).

RESPONSIBILITIES:

• Maintain and support various databases used by the Office of Enforcement and Neighborhood Services

(ENS).

• Create and maintain logical and physical data models.
• Create and maintain ETL packages in SQL Server Integration Services and Oracle Data Integrator to extract,

transform, load and transfer between Oracle and SQL Server database.

• Create ETL mapping documentation.
• Perform data profiling data analysis, conversion, and migration of data between different databases. Create
• dimensional logical and physical data models.
• Create BI models in OBIEE.
• Performance tune and optimize queries.
• Assist development teams in the build out of schema and database technologies
• Assist in installing, configuring and setup of Business Intelligence Tool and other data tools as needed.
• Development of complex reports/dashboards for ENS business users.

MANDATORY SKILLS/EXPERIENCE:

Note: Candidates who do not have the mandatory skills will not be considered

• Minimum of 8 years of OBIEE Design, Deployment and developing relational and dimensional data models.
• Minimum of 8 years of Oracle Business Intelligence Dashboards, Reporting Design and Development.
• Minimum of 5 years of ETL Development via Oracle Data Integrator (ODI)/ SQL Server Integration service (SSIS).
• Minimum of 5 years of experience with Oracle/SQL Server Database, writing SQL queries to perform complex data analysis, developing stored procedures, functions, triggers.
• Minimum of 5 years of experience in performance tuning and Query optimization techniques.
• Solid understanding of dimensional model (Star Schema & Snowflake schema)