Sr. Data Warehousing Consultant

Job Locations US-WI-Madison
Requisition ID
Visa Sponsorship
Travel Requirements

As a SAS Data Warehousing Consultant you are responsible for data integration, software design and development.


You will relate technical concepts to SAS System applications and user needs and oversee the technical progress of ongoing services projects; focus on the underlying Data Architecture and SAS technology core to develop and implement Enterprise Data Warehouse strategies that support organization initiatives.


Location: Madison, Wisconsin




  • Working closely with customers, you will utilize your experience in a variety of projects, using the latest SAS solutions and technologies, to participate in the planning, design and implementation of data warehouses that improve business processes, supports critical business strategies and helps people make better decisions.
  • Manage all aspects of the data warehouses such as data sourcing, migration, quality, design, and implementation.
  • Support critical business strategies by managing the development, implementation, and maintenance of the solution.
  • Build a trusted relationship with client teams to provide practical guidance in the functional and technical aspects of proposed software and set proper expectations to ensure customer satisfaction.
  • Extract data from a variety of data sources, transform data, and load it into data warehouses and marts.




  • Bachelor's degree in Computer Science or a related quantitative field
  • 5 years of experience in data warehouse management.
  • 5 years of experience developing ETL processes. Some of this experience must be within the last 5 years.
  • Excellent verbal, written communication skills.


Additional Abilities and Skills:


  • Strong SQL or similar query language skills.
  • Data Modeling: Strong experience developing logical and physical models (Dimensional)
  • Develop mappings of source system data to target data model with business and transformation rules
  • Understanding of data warehousing concepts and best practices.
  • Knowledge of one or more database technologies and appliances (Oracle, DB2, Teradata, Greenplum, Hadoop).



  • Business knowledge and experience working with US Healthcare data (private and/or government).
  • Experience with at least one ETL/Data Management tool (SAS Data Integration, Informatica, Pentaho, etc.)
  • Experience with SAS Programming and SAS Development Tools.
  • Mapping or geospatial software development experience.


SAS looks not only for the right skills, but also a fit to our core values. We seek colleagues who will contribute to the unique values that makes SAS such a great place to work.


Additional Information:

SAS is an equal opportunity employer. All qualified applicants are considered for employment without regard to race, color, religion, gender, sexual orientation, gender identity, age, national origin, disability status, protected veteran status or any other characteristic protected by law. Read more: Equal Employment Opportunity is the Law. Also view the supplement EEO is the Law, and the Pay Transparency notice. 


Equivalent combination of education, training and experience may be considered in place of the above qualifications. The level of this position will be determined based on the applicant's education, skills and experience. Resumes may be considered in the order they are received. SAS employees performing certain job functions may require access to technology or software subject to export or import regulations. To comply with these regulations, SAS may obtain nationality or citizenship information from applicants for employment. SAS collects this information solely for trade law compliance purposes and does not use it to discriminate unfairly in the hiring process.


All valid SAS job openings are located on the Careers page at SAS only sends emails from verified “” email addresses and never asks for sensitive, personal information or money. Should you have any doubts about the authenticity of any type of communication from, for, or on behalf of SAS, please contact us at before taking any further action.



Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share with your networks