Data Warehouse Analyst (3450)

Morton Consulting is in the process of supporting a need for a Data Warehouse Analyst in Richmond, Virginia.  The selected candidate will be responsible for the design, development, and delivery of the database platforms, and BI solutions. Create and maintain the logical and physical Data Models for the Business Intelligence Data Warehouse and Data Mart environments.

Responsibilities:

 

  • Design and develop data warehousing solutions utilizing Microsoft technologies
  • Document, maintain and support data warehousing jobs
  • Serve as technical consultant to application support staff and project teams.
  • Coordinate development tasks on a daily 
  • Research, evaluate and recommend database support tools.
  • Update, develop and maintain operational support procedures for infrastructure components.
  • Stay up-to-date on technical support tools for databases.
  • Interface with Hosting facilities
  • May perform other duties as assigned

Qualifications:

  • Five (5) to ten (10) years of Microsoft SQL Database Development / Business Intelligence experience in ETL, DATA ENGINEERING
  • Expert level SQL Server experience including heavy background with the Microsoft BI tools SSIS and SSRS; SSAS is a plus. 
  • Strong experience in designing and implementing ETL processes
  • Strong dimensional modeling experience
  • Expert T-SQL skills, SQL Server 2012 or higher preferred
  • Report development experience using enterprise reporting tools like SSRS/Cognos/SAS VA
  • Strong analytical and quantitative analysis skills
  • Strong multi-tasking capability and the ability to work and learn in a fast-paced environment
  • A ‘roll-up-your-sleeves’ passionate team-player
  • Experience in writing APIs to extract data and with modeling tools like Erwin is a plus
  • Exposure to data visualization tools such as SAS and SAS VA is a plus
  • E-commerce or retail experience is a plus
  • Bachelor’s degree in Computer Science or related field. Master’s degree is a plus
  • Three (3) to Five (5) years of data warehousing design and  development experience 
  • Advanced computer literacy. 
  • PC Skills: Microsoft Windows, Word, Outlook, PowerPoint, and Excel.  Database Tools: SSH Client Tools (Putty, Xwin, SSH Secure), SAS, SAS VA, ERWIN, TOAD
  • Excellent Knowledge of MS SQL Server 2012, 2014, SSRS, SSIS, SSAS, , COGNOS, 
  • Microsoft Certification is a plus
  • Knowledge of Storage Area Network Device such as EMC VNX or NetApp is a big plus

Apply Now

If you are interested in this position, we welcome you to begin the application process online. Please complete this short form, paste in your cover letter, and attach your resume.
  • Upload your resume.
  • This field is for validation purposes and should be left unchanged.