Full Stack Data Developer - New York, United States - Ariel Partners

Description

Job Description

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.

REQUIRED SKILLS

• 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)

If you are interested in getting more information about this opportunity, please contact Irina Rozenberg at your earliest convenience.

At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges, we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.