Senior Consultant, Technical

Company Description

insightsoftware is a global provider of comprehensive solutions for the Office of the CFO.

We believe an actionable business strategy begins and ends with accessible financial

data. With solutions across financial planning and analysis (FP&A), accounting, and

operations, we transform how teams operate, empowering leaders to make timely and

informed decisions. With data at the heart of everything we do, insightsoftware enables

automated processes, delivers trusted insights, boosts predictability, and increases

productivity. Learn more at insightsoftware.com

Job Description

Work Timings:  5:30PM - 2:30 AM (IST timezone)

Overview

The Business Intelligence Engineer will be responsible for analyzing business requirements in order to model, design, deploy, and maintain data warehouse implementations for different customers across different verticals.

This position reports to the Professional Services Manager and will work closely with a team to communicate with business stakeholders, customers, end users and team members to create, model, and deploy analytics and reporting applications that include dashboards, scorecards, and performance analytics.

Responsibilities

  • Translate business requirements into data models that lay the foundation for reporting and analytics.
  • Assist in estimation, impact assessment and implementation planning.
  • Model, design, and deploy data warehouses leveraging fact and dimension tables.
  • Design and deploy ETL processes using SQL Server Integration Services.
  • Design and deploy cubes for multi-dimensional or tabular analysis.
  • Interface with customers to gather requirements and scope projects.

Qualifications

Experience Level: 6 to 9 Years

  • Qualifications

  • 5+ years of experience with SQL/TSQL with good understanding of MDX and DAX.
  • 3+ years of designing and working with dimensional models.
  • Method facts and dimensions, star schemas, and data modeling techniques.
  • 3+ years of experience with Microsoft SQL Server Management Studio, including SSIS and SSAS.
  • 3+ years of experience designing and deploying ETL architectures and packages.
  • Experience working with Azure and reporting tools a plus.
  • Communicate effectively with customers and internal cross-functional partners.
  • Strong troubleshooting and problem-solving skills.

Additional Information

All your information will be kept confidential according to EEO guidelines.

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

Background checks are required for employment with insightsoftware, where permitted by country, state/province.

At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

Background checks are required for employment with insightsoftware, where permitted by country, state/province.

At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.