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

QUALIFICATIONS & EXPERIENCE

  • 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

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

Paste your resume here or Attach resume file