Senior Data Warehouse Engineer
Company: Geode Capital Management LLC
Location: Boston, MA
Posted on: June 10, 2021
Job Description:
Duties: Conceptualizes, designs, and builds enterprise data
warehouses. Creates and maintains optimal ETL pipelines to populate
operational repositories, warehouses, and data marts. Works with
teams to understand their data analysis and reporting needs.
Supports the entire data warehouse lifecycle including, gathering
business requirements, data profiling, design, development,
testing, and support. Understands business imperatives and
translates them into business intelligence insights to enable the
business to make crucial decisions. Primary Responsibilities: Identifies various sources to encapsulate into a scalable and
robust enterprise data warehouse. Designs and models data warehouse architecture based on
enterprise reporting needs. Authors and reports visually smart dashboards using Tableau. Enforces database development and data delivery. Identifies poorly performed SQL queries and optimizes for
performance. Collaborates closely with business teams and analysts to
understand requirements to produce high quality deliverables. Supports data issues with production applications. Monitors and manages the health of database servers. Analyzes information to determine, recommend, and plan computer
software specifications on major projects and proposes
modifications and improvements based on user need. Develops software system testing and validation procedures, and
programming and documentation. Collaborates with testers to analyze defects, verify behavior,
and resolve issues. Assists the Data Governance team in maintaining glossary and
lineage of the terms and attributes in the warehouse. Requirements: Bachelors degree (or foreign education equivalent)
in Computer Science, Engineering, Information Technology,
Information Systems, Information Assurance, Mathematics, Physics,
or a closely related field and five (5) years of experience in the
job offered or five (5) years of experience performing data
warehouse modeling, analytics, visualization, reporting,
governance, and ETL (Extract, Transform, and Load) in a financial
services domain; Or, alternatively, Masters degree (or foreign
education equivalent) in Computer Science, Engineering, Information
Technology, Information Systems, Information Assurance,
Mathematics, Physics, or a closely related field and three (3)
years of experience in the job offered or three (3) years of
experience performing data warehouse modeling, analytics,
visualization, reporting, governance, and ETL (Extract, Transform,
and Load) in a financial services domain. Candidate must also
possess: Demonstrated Expertise (DE) performing data warehouse
modeling, analytics, visualization, reporting, governance, and ETL
in a financial services domain, using SQL server or Oracle, and
Tableau, MicroStrategy, Microsoft, and Power BI; designing and
implementing enterprise data warehouse solutions to provide
historical insights, point in-time reporting, optimal storage,
access of data, management dashboards, exposure and risk analytics,
historical fund performance, returns, and attribution, using
Microsoft SQL Server, and Oracle or Teradata; DE gathering business
requirements and implementing ETL pipelines to stage, transform,
and load data into data warehouses and marts, using Informatica
ETL, Data Stage ETL, and SQL Server Integration Services (SSIS); DE
building reports, dashboards, and visualization, using
MicroStrategy, Tableau, and SQL Server Reporting Services (SSRS);
creating reporting data layers for self-service business
intelligence platforms to enable end users to unlock business
insights, client reporting, and portfolio management tasks, using
MicroStrategy, Tableau, SQL Server Reporting Services (SSRS), and
Power BI; DE assisting data governance and product management teams
in building the technical lineage of attributes in data warehouses
and reports using Infogix Data360; identifying various stages in
the full data lifecycle to understand the transformation and
consumption of data and to ensure the correct versions of data is
used for client reports and regulatory requirements using tools --
Infogix Data360; and implementing data quality rules on attributes
based on business defined rules using Informatica Analyst. To apply for this position, please send an email containing
cover letter and resume to careers@geodecapital.com. Please
reference SENIOR DATA WAREHOUSE ENGINEER in subject line.
Keywords: Geode Capital Management LLC, Salem , Senior Data Warehouse Engineer, Finance , Boston, MA, Massachusetts