Senior Data Warehouse/BI Solution Architect

  • location: Austin, TX
  • type: Permanent
  • salary: $120,000 - $130,000 per year
easy apply

job description

Senior Data Warehouse/BI Solution Architect

job summary:
The Senior Data Warehouse Solution Architect is the senior member of the IT Analytics team and the evolution of our Data Warehouse and infrastructure. This position will be responsible for managing and developing our analytics infrastructure. This includes data warehouse design, development, administration and maintenance and oversight, implementation and maintenance of optimal data warehouse inputs (data integration, ingestion) and outputs (business intelligence applications, reports).

location: Austin, Texas
job type: Permanent
salary: $120,000 - 130,000 per year
work hours: 9 to 6
education: Bachelors
-Design, develop, administer and maintain our enterprise data warehouse

-Oversee, implement and maintain optimal data warehouse inputs (data integration, ingestion) and outputs (business intelligence applications, dashboards, reports)

-Develop and enhance the analytics strategy including the development and enhancement of business intelligence solutions that assist Bank personnel in identifying, monitoring and evaluation and KPIs

-Internal subject matter expert on developing, designing and maintaining enterprise data warehouse; can understand business/system/data challenges and translate them into solutions

-Support the data and analytics needs of information consumers

-Monitor and optimize analytics infrastructure and operations

-Participate in data strategy and road mapping exercises, making recommendations and giving guidance as appropriate

-Collaborate with the technology team to maintain and enhance analytics infrastructure and technology strategy including backup & recovery, data storage, security and governance

-Integrate disparate data sources into the enterprise data warehouse

-Provides superior internal service with an emphasis on partnership and collaboration while promoting communication and coordination at all organization levels

-Maintenance and enhancement of database dictionaries and documentation

-4+ years of working with enterprise architecture or solution architecture frameworks, methodologies, templates, and tools

-Bachelors or Master's degree in MIS, Analytics or related field (or equivalent work experience)

-Expert experience with the Microsoft data warehousing stack

-Expert, hands-on development and management experience with financial services-related Data Warehouses on the Microsoft stack-including experience with relational and dimensional database modeling and the Kimball methodology

-Expert, hands-on development and management experience with data visualization and dashboard development-including experience with Excel PowerPivot, DMX/MDX, SQL and Tableau

-Outstanding initiative, attention to detail and organizational skills required

-Experience with database administration and optimization (preferably MS and AWS)

-Other beneficial experience: Python, web services, web application development, Cognos, SAS, Box, SFTP, Salesforce, SNL

-Self-motivated, innovative person with analytical, problem solving, organizational, and interpersonal skills with the ability to adapt to changes and new ideas

-A growth mindset: track record of leveraging past learnings, encouraging new ideas and smart risk taking in self and others

-Strong communication skills with a proven ability to build cross functional partnerships to make effective decisions collaboratively

-High commitment to employee growth and development: empowers team and defines success as having a significant impact on other's careers


-7+ years of evangelizing technologies or working with technology development/delivery teams

-5+ years of technology design, implementation, or consulting in one or more of the following areas:

oEnterprise Data Warehouse

oData Lake and Big Data

oBusiness Intelligence & Analytics

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up

related jobs

    Sr. Java Developer

  • location: Austin, TX
  • job type: Temp to Perm
  • salary: $45 - $55 per hour
  • date posted: 1/3/2019

    Sr. Automation Engineer

  • location: Austin, TX
  • job type: Permanent
  • salary: $110,000 - $120,000 per year
  • date posted: 1/16/2019