This site uses cookies. To find out more, see our Cookies Policy

SQL Server Data Warehouse Developer - Contract - North Houston in Houston, TX at Vaco

Date Posted: 6/29/2018

Job Snapshot

Job Description

Vaco has a contract opportunity in North Houston for a SQL Server Data Warehouse Developer. Our client is building a new data warehouse platform and is looking for developers to help optimize the datawarehouse design and performance in support of the reporting functions.

Responsibilities

  • Develop scripts, perform database support activities, and conduct performance tuning and database design, dimensional analysis, and modeling.
  • Analyze data requirements, application and processing architectures, data dictionaries and database schemas while designing, developing, amending, optimizing and certifying database designs to satisfy reporting needs
  • Create custom SQL to query complex data models for the database and application servers
  • Assist in monitoring system performance, reliability, availability, and recoverability of the DW environment
  • Provide functional and technical subject matter expertise in various data management, warehousing, business intelligence and Big Data solutions.
  • Provides expertise and data warehouse design knowledge in the areas of Data Governance, Master Data Management, Analytics, Data Warehousing, Scorecards, Dashboards, Business Performance Monitoring and Data Mining
  • Maintain and add to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) data manipulation.
  • Standardize cross-departmental data definitions, KPIs, and calculations
  • Act as the liaison between business stakeholders, developers, infrastructure teams and project management groups
  • Maintain, enhance, and create enterprise and application level reports using SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools.
Experience:
  • Hands on experience implementing a Data Warehouse (SQL Server).
  • Strong experience with Data Mapping, Data Modeling, Data Mining, and Data Warehousing/Mart.
  • Strong experience with Multidimensional Expressions (MDX) and SQL queries performance tuning.
  • Extensive experience in data warehouse, ETL experience and experience working with various front-end reporting tools including SSRS and Power BI
  • Microsoft SQL Server Database, SSIS, SSRS, SSAS required - 5+ years
  • Microsoft BI Stack including Power Query, Power Pivot and Power View.

***PLEASE NOTE, we are only considering candidates local to Houston at this time. Onsite interviews are required for this project.