Senior Engineer, Microsoft SQL Server BI (SSIS/SSAS)

Are you passionate about data? The best candidate has a “can-do” attitude and is dedicated to resolving issues quickly and troubleshooting creatively. This is a great opportunity to join a fun and rapidly growing team. Please consider the position criteria below to determine if this opportunity is right for you!

Position Expectations

  • As an engineer, the incumbent would be responsible for evaluating, developing, maintaining and testing BI solutions for various analytics projects
  • Be responsible for building data warehouses, data marts & OLAP solutions
  • Plan, create, coordinate, and deploy data warehouse and business intelligence solutions
  • Create best practices for data loading and extraction (ETL framework)
  • Develop data architecture, data modeling, and ETL mapping solutions and data warehouse consistency
  • Would have a strong focus on collecting, parsing, managing, analyzing and visualizing large sets of data to turn information into insights using multiple platforms


  • 5+ years of experience as a Data Warehouse Architect / Developer
  • 5+ years of experience with data analysis using SQL and other tools
  • 4+ years of data modeling experience, and knowledge of 3NF, Star-Schema and other data
  • 3 + years of experience working in SQL Server, SSIS and SSAS or SSRS
  • Ability to work with multiple data sources
  • Ability to develop, execute and analyze Multidimensional expressions (MDX)
  • Ability to quickly create Analysis Service objects like data source views, dimensions and cubes and do enhancements to existing objects
  • Experience writing MDX and DMX queries and statements
  • Experience creating Tabular models will be an advantage.

Must have:

  • Proven ability with SQL Server database design best practices and performance tuning
  • Demonstrated solid understanding of Data Warehouse design theory, including dimensional data modeling
  • Significant experience developing logical / physical dimensional models, OLAP processes
  • Proven ability using SQL Server 2012 (or 2014), SSIS Packages, Procedures, Functions, SQL, and other SQL Server Database Objects
  • Proven individual contributor and team player with effective communication skills
  • Experience working collaboratively with Stakeholders, Business Analysts, Project Managers, Designers and DBAs with the common goal of delivering value to the business

Education B.E/B.Tech in Computer Science or related technical degree

Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file