Microsoft BI Developer Analyst – Anterra is expanding again!

Anterra is a high growth exciting software company with an Azure cloud based BI application for construction and real estate companies. Using SQL 2012, asp.net, MVC, HTML5/JavaScript, and .net technology we are delivering world class solutions to clients on 3 continents. With the rapid adoption of our cloud based solution we have experienced significant growth and are looking for a highly motivated developer to join our team. If you want to be part of a company that rewards innovative thinking, hard work along with the opportunity to work with transformative technology and highly motivated people then Anterra is the place for you.

Role and Responsibilities

  • Developing SSAS measure formulas and managing measure use across customers
  • Coordinating releases in conjunction with code in an “Always-On” environment
  • Developing and optimizing both SQL and MDX queries
  • Develop an understanding of the data transformation process that is in place to diagnose issues and recommend solutions with more efficient overall management

Experience Required

  • Highly proficient and comfortable designing and maintaining SSAS cubes and custom measures
  • Strong understanding of Microsoft SQL Server 2008 R2 or newer including Analysis Services
  • 3+ Years’ Experience writing complex MDX queries
  • 3+ Years’ Experience with T-SQL, stored procedures, functions, triggers, and indexes
  • Prior use of a version and/or task management tool such as TFS, Git, Subversion, Redmine, OnTime, @Task, Salesforce, etc.

Additional skills a plus

  • Analysis Services cube processing optimization and throttling and/or ROLAP
  • Proficiency with Data Quality Services and Integration Services (SSIS)
  • Familiarity with data transformation
  • Ability to learn application systems, understanding C# code, to ultimately understand the business rules and how the data resides in the system to effectively assist with scaling over time
  • Understanding of SQL Reporting Services (SSRS) is a plus, specifically the ability to understand the construction of a report, however we largely transitioning away from SSRS
  • Knowledge of SQL Server Always-On Availability clustering
  • Understanding CTE and use of assemblies in DBs is a plus
  • Familiarity with linked servers, including to Azure DBs, is also a plus

Benefits

  • We provide Healthcare Insurance, Dental, and Vision Benefits
  • Compensation is commensurate with experience
  • Position is located in greater Houston, TX

Please apply directly to moc.h1498547271cetar1498547271retna1498547271@sboj1498547271 with a copy of your resume.  We will respond to all qualified candidates.