Database Engineer III

idexcel; City of Schenectady (NY); On-site; USD 77,696; Full time

Job summary

A global staffing and IT services organization is seeking a Database Engineer III in Schenectady, NY. The ideal candidate will be responsible for building dynamic BI dashboards, developing SQL queries, and ensuring quality in data visualization projects. This role requires a strong background in SQL and a minimum of 5 years of experience in data visualization and analytics. Strong communication and analytical skills are essential as this role involves working cross-functionally to improve processes and performance.

Qualifications

• Minimum of 5 years of experience in data visualization and analytics.
• Ability to work effectively in a matrix environment.
• Strong customer service focus and desire for continual improvement.

Responsibilities

• Build, publish, and maintain dynamic BI dashboards in Tableau.
• Develop SQL queries against a Greenplum data warehouse.
• Execute QA testing and resolve any defects.

Skills

Strong knowledge of SQL

Data visualization

Analytical skills

Team player

Education

Bachelor's Degree in Computer Engineering, Information Technology, Electrical Engineering, or Computer Science

Tools

Tableau

Greenplum

Job description

Idexcel is a global staffing and IT services organization, with a mission to bring great people and great organizations together. Our diverse client base represents a wide range of industries, including technology, telecom, insurance, healthcare, manufacturing, banking & financial services, food & commodities trading and federal organizations. Our teams of experienced recruiters directly work with client companies seeking exceptional people to help with their business initiatives.

Idexcel, Inc. is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.

Job Description

Database Engineer III – Schenectady, NY, USA, 12345

$56.40/hr on w2

12/19/2016 to 06/18/2017

Staff Data Visualization Engineer

Responsible for requirements, design and implementation of complex reporting solutions with strong experience in semantics/metadata design. Take an active role in joint solution design and be an advocate for long term quality in the process. Strong experience with multiple visualization platforms and selecting best technology to meet business needs. Ability to translate business requirements into technical solution is a critical skill for the position. Assess requirements for completeness and accuracy and work with requirement providers to close issues and gaps. Develops peer, cross-functional and cross-GE business relationships to maximize best practice sharing and team effectiveness. Assists in the evaluation and proof of concept of new visualization technologies. The Staff Data Visualization Engineer will be responsible for the requirements, development, testing, and implementation of reporting solutions. They demonstrate experience in multiple visualization platforms and work cross-functionally to maximize best practices and reuse. Responsible for designing and implementing Business Intelligence reporting with experience in semantic design. Responsible for semantics/metadata development with experience in metadata configuration and implementation. Assists in the evaluation and proof of concept of new visualization technologies. Strong experience with multiple visualization platforms and selecting best technology to meet business requirements. Help to integrate reporting solution deliverables on project plans. Assess requirements for completeness and accuracy and work with requirement providers to close issues and gaps. Deliver as per project plans to implement reporting solutions. Execute QA testing and resolve any defects. Coordinate with deployment and support teams to ensure the solutions get implemented into QA and production environments. Take an active role in joint solution design and be an advocate for long term quality in the process. Write SQL to explore source data, data issues, etc. Identify impact on existing model/ solution triggered by new/changed requirements. Ability to translate business requirements into technical solution is a critical skill for the position. Develops peer, cross-functional and cross-GE business relationships to maximize best practice sharing and team effectiveness. Applies standard development procedures and a detailed applications knowledge in area of responsibility to create technical designs driving towards simple, sustainable, and reusable solutions.

Essential Responsibilities In this role, you will build tooling to rapidly make important information visible and available to both internal and external customers.

In addition, you will:

• Build, publish, and maintain dynamic BI (Business Intelligence) dashboards in Tableau
• Develop SQL queries against a Greenplum (Postgresql) data warehouse
• Compute fleet metrics including availability, fault rate, and production ratio
• Build, publish, and maintain static reports
• Guide infrastructure and database improvement development

Qualifications/Requirements

• Bachelor's Degree in Computer Engineering, Information Technology, Electrical Engineering, Computer Science from an accredited college or university or equivalent experience
• Minimum of 5 years of experience working in an data visualization and analytics

Desired Characteristics

• Strong knowledge of SQL and retrieving data from relational database systems
• Previous experience working with large data sets using big data technologies including Greenplum or other MPP database systems
• Previous experience with advanced SQL programming including DML and DDL
• Familiarity with scripting / programming in Java, Python, Matlab, R, and / or VBA
• Ability to work effectively in a matrix environment
• Superior analytical skills, with strong desire to improve processes and performance
• Ability to work effectively within all levels of the organization and customers
• Strong presentation skills
• Distinctive ability to analyze technical processes
• Strong communication and project leadership skills with ability to clearly communicate issues and resolution to both a technical and non-technical audience
• Strong customer service focus and desire for continual improvement
• Ability to take decisions and to adopt responsibility
• Strong quality awareness and ability to identify future failures, defects and problems
• Experience to working with multicultural teams
• Strong team player with structured work methods and analytical skills
• High flexibility and motivation to succeed
• Previous experience leading cross functional projects

Sandra Taylor

571-267-4186