Business Intelligence Architect

Job Description

ITnova is looking for a Business Intelligence Architect with at least 12 years of experience in data warehousing, data analysis, and modeling, including star and snowflake schemas, fact and dimension tables, and ETL processes. The candidate should have over 10 years of experience with Microsoft SQL Server, along with expertise in Azure Analysis Services and developing OLAP/Tabular cubes. Familiarity with reporting tools like Power BI or Tableau is a plus. Strong communication and presentation skills are essential.Experience / Qualifications

Minimum 12 years of experience working with in Data warehousing, Data Analysis, Source Target Mapping, Multi-dimensional modeling and Relational modeling, Star schema, Snowflake schema, Fact and dimension tables, and ETL Processes

10 + years experience in Microsoft SQL Server and relational SQL databases, including data modeling, development, and management.

Experience designing database tables and structures, creating views functions, and stored procedures as required.

5+ years of experience with Azure Analysis Services in AAS Data Model Development, AAS Data model Deployment in Azure, and Querying data from AAS to build Reports.

Experience developing, optimizing, and administering Tabular Models in Azure Analysis services.

Experience designing and Creating AAS/OLAP/ Tabular cubes and automating processes for analytical needs. Expertise in developing OLAP cubes, complex calculations, and aggregates and implementing a dynamic security model using DAX functions in Azure Analysis Services.

Experience in writing optimized SQL queries for integration with other applications, maintaining data quality, and overseeing database security, Partitions, and Index. Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, monitor long-running queries, and troubleshoot cubes SQL and T-SQL.

Experience or knowledge of reporting tools like Power BI, Cognos, or Tableau is preferred.

Experience in applying data visualization best practices and tell stories through data visuals and reports to inform the who, what, when, where, and how to be able to understand the key factors driving positive outcomes.

Excellent communication skills, presentation skills with ability to interact at all levels of the organization regularly. Education

Bachelor's degree in computer science/engineering or related fields. Work Location

Hybrid work at 2 Montgomery Street, Jersey City, NJ 07302

Full-time

Hybrid remote