NashvilleTNRecruiter Since 2001
the smart solution for Nashville jobs

Senior Engineer/Data Warehouse Architect

Company: AllianceBernstein
Location: Nashville
Posted on: September 15, 2020

Job Description:

IT Group Description:

Client Group Technology creates and supports business innovating technology for the Client Group. The team is responsible for business innovation, project and relationship management, data and business intelligence, vendor management, and software development as it relates to the tools used by the over 500 Client Group staff globally.

The Client Group has a presence in the Americas, Europe, Asia and Australia, and is composed of five main areas:


  • Sales & Client Services works with financial intermediaries and institutions to offer diversified investment solutions that help clients build and preserve their wealth
  • Business Development is a conduit to the firm's investment teams and supports our clients and internal business partners through investment-platform and product content, messaging, competitive analysis and education
  • Product Strategy & Development designs, develops and manages the firm's global lineup of investment services and considers clients' evolving needs to identify new opportunities
  • Marketing promotes the firm and its services by creating, packaging and distributing content and messaging to engage diverse audiences through digital platforms and initiatives, strategic campaigns, and events
  • Business Transformation looks to evolve and scale our business, leveraging digital and data, to drive top-line growth and improve profitability

    IT Job Description:

    We are seeking a Nashville based Senior Engineer/Data Warehouse Architect to join our Data & Analytics team in Client Group technology.

    Describe the role:

    The candidate will work closely with the business teams to design, architect, and develop support tools for data analysis, data loads, data visualization, and reporting.

    Describe the applications and business or enterprise functions the role supports:

    HighLine Data warehouse a brand-new database being built by sourcing data from different systems/applications which will be the backbone of building new application that will sit on top of this Datawarehouse. Dealer Marketing System (DMS) is the database used by all retail mutual fund applications like Salesforce (CRM), one point (data integrity maintenance), Business Intelligence Reports in MicroStrategy and SIMON (Mobile sales force application). It is the system of Record for domestic retail mutual funds sales, asset and transaction data.

    Some of the key operations done by HighLine Datawarehouse are:

    • Receiving and processing financial transaction data feeds (purchases, redemptions, exchanges) from domestic and international transfer agencies (DST, Omnibus, CORFAX), Broker Dealer Omnibus and Recordkeeper files
    • Client specific Data are ingested like Demographic data; data packs; Market Share and Recordkeeper files
    • Generating aggregates used by downstream applications (Salesforce, SIMON etc.)
    • Distributing data to all linked sites and systems: Domestic and international advisor Web-sites, Wholesaler portal.
    • Allowing members of the Sales Data Management team to manage sales territory definitions, move trades from one region to another etc.


      The key job responsibilities include, but are not limited to:

      • Architect and develop a data ingestion framework to dramatically reduce the implementation timelines of new data sources for retail sales & marketing from external and internal data sources.
      • Develop and automate the creation of data access API's and Web Services to aid analysis with an emphasis on data visualization as well as build a robust metadata repository which captures technical and business metadata to facilitate data discovery, exploration and self-service.
      • Implement and extend data pipeline orchestration tools to capture complete data lineage.
      • Develop a data quality architecture which propagates quality metadata across the data lineage and implements in-process data health checks.
      • Simplification and automation of existing manual processes.
      • Create policies and processes for data governance.
      • Work directly with business users to ensure proper following of set policies and processes related to data governance.
      • Coach/Evangelize/Mentor team members on data lake technologies and DevOps methodology.
      • Develop and collaborate with AB's infrastructure management team to build an elastic "analytics sandbox" environment which supports DataOps (continuous integration, continuous deployment, and statistical process control) methodologies.

        What makes this role unique or interesting?

        This role is targeted to individuals who are passionate about data. Those who have good knowledge and/or interested in the ability to build out a new data warehouse while also being integral in building software solutions that are data focused with an emphasis on supporting the sales and marketing process.

        What is the professional development value of this role?

        This role provides the opportunity to learn the investment business as well as providing the opportunity to advance one's technical skills with a focus on data. Here are just a few of the technical areas this role will focus on: Relational Data (SQL), Unstructured Data, Data Analysis (Python), building visualizations (MicroStrategy).

        Qualifications, Experience, Education:

        • BS in Computer Science/Engineering, Finance, Mathematics/Statistics or a related major
        • 7+ years' experience developing SQL specifically Stored Procs and SQL queries.
        • 3+ years' experience architecting data warehouse solutions specifically within SQL Server
        • 2+ years' experience using Agile or DataOps methodologies (CI/CD)
        • Experience with building data warehouse within the cloud (Azure or AWS)
        • ETL experience is a strong plus (SSIS and/or Informatica)
        • Working with large datasets as well as unstructured data.
        • Building visualizations using SSRS, Tableau, Qlik, PowerBI or MicroStrategy is a strong plus.
        • Advanced Excel programming experience is a strong plus
        • Experience with OOP preferably C#.NET as well as SSAS

          Skills:

          • Must possess strong analytical skills
          • Must demonstrate good communication skills and be comfortable working closely with business users
          • Must be a self-starter as well as a good team player
          • Must be willing to take ownership of projects and show strong client commitment
          • Must document and share work done to aid in long term support


            Nashville, Tennessee

Keywords: AllianceBernstein, Nashville , Senior Engineer/Data Warehouse Architect, Engineering , Nashville, Tennessee

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Engineering Jobs


Professional Test Engineer
Description: SunIRef:Manu:title Job Description: Essential Job Functions Performs testing, troubleshooting and analysis tasks on various phase s of network systems development including integration, systems testing, (more...)
Company: DXC
Location: Nashville
Posted on: 09/21/2020

Auto Mechanics/Technicians - All Levels Of Experience Wanted!
Description: Automotive Technician of All Levels Compensation is based on level of experience with opportunity to grow your career Competitive Pay Rate No Flat Rate Monday Friday Work Schedule 100 company-paid (more...)
Company: Carvana
Location: Nashville
Posted on: 09/21/2020

Machine Repair Technician II
Description: Overview JBT Airport Services, a division of JBT Corporation, is a dedicated provider of maintenance and operations services to airlines and airports throughout North America. We provide 24/7/365 support (more...)
Company: JBT Corporation
Location: Nashville
Posted on: 09/21/2020


Auto Body Mechanic
Description: AUTO BODY AND PAINTPROFESSIONALS OF ALL LEVELSCompensation is based on level of experience with opportunity to
Company: Carvana
Location: Hendersonville
Posted on: 09/21/2020

Auto Mechanics/Technicians - All Levels Of Experience Wanted!
Description: Automotive Technician of All Levels Compensation is based on level of experience with opportunity to grow your career Competitive Pay Rate No Flat Rate Monday Friday Work Schedule 100 company-paid (more...)
Company: Carvana
Location: Murfreesboro
Posted on: 09/21/2020

Auto Technician - Entry Level
Description: Geared for the DrivenDuring these uncertain times of COVID-19, Valvoline Instant Oil Change SM VIOC is proud to serve those who need to be on the road, including first responders and medical workers (more...)
Company: Valvoline Instant Oil Change
Location: Hendersonville
Posted on: 09/21/2020

Auto Technician - Part Time/Full Time - Nolensville Rd
Description: Geared for the Driven br br During these uncertain times of COVID-19, Valvoline Instant Oil Change SM VIOC is proud to serve those who need to be on the road, including first responders and medical (more...)
Company: Valvoline Instant Oil Change
Location: Nashville
Posted on: 09/20/2020

AWS Network Engineer (Remote Eligible)
Description: Job Description Description Relatient is a leading provider of integrated messaging solutions for practices, hospitals and health care systems. We take a patient-centered approach to engagement, utilizing (more...)
Company: Relatient LLC
Location: Franklin
Posted on: 09/21/2020

Auto Technician - Entry Level
Description: Geared for the DrivenDuring these uncertain times of COVID-19, Valvoline Instant Oil Change SM VIOC is proud to serve those who need to be on the road, including first responders and medical workers (more...)
Company: Valvoline Instant Oil Change
Location: Franklin
Posted on: 09/21/2020

Project Engineer General Contractor
Description: Company Crowder Constructors Inc - Location Clarksville, TN 37040 Description Since 1947, Crowder has built
Company: Crowder Constructors Inc
Location: Clarksville
Posted on: 09/21/2020

Log In or Create An Account

Get the latest Tennessee jobs by following @recnetTN on Twitter!

Nashville RSS job feeds