Data Warehouse & BI Engineer/Architect

Boston, MA

Posted: 05/14/2019 Employment Type: Perm Industry: IT Job Number: 229393

Data BI Architect  

Salaried Position 

Boston, MA 

Roles and Responsibilities

Conceptualize, design and build enterprise data warehouses

Create and maintain optimal ETL pipelines to populate operational repositories and warehouses.

Author reports and visually smart dashboards using Tableau

Perform the role of a technical steward and assist Data Governance team maintain the glossary and lineage of the terms in the warehouse

Adhere to and enforce database development and data delivery standards

Identify poorly performing SQL queries and optimize for performance

Work closely with the business teams, business analysts to understand requirements and produce high quality deliverables

Support data issues with production applications.

Monitor and manage the health of the database servers

Requirements

5+ years of experience in dimensional data modeling, ETL development, and data warehousing

5+ years of PLSQL/T-SQL development experience on SQL Server (preferred) /Oracle/Sybase

Excellent knowledge of SQL

Experience with Tableau or comparable experience with other BI visualization tools such as Microsoft Power BI, Tibco SpotFire etc.

Experience with integration of data from multiple data sources.

Bachelor’ s degree or higher in Computer or Information Science

Ability to effectively communicate with both business and technical teams

Experience in asset management industry is preferred

Experience with master data management tools (Markit EDM, Informatica MDM) is a plus

Experience with big data tools: Hadoop, Spark, Kafka, etc. is a plus

Ability to work and thrive under pressure in a fast paced, mission critical environment

Detail oriented with excellent communication skills

 
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs: