ITnova
Overview
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
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.
Responsibilities
Minimum 12 years of experience working with Data warehousing, data analysis, source-to-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.
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, deployment in Azure, and querying data from AAS to build reports.
Experience developing, optimizing, and administering Tabular Models in Azure Analysis Services.
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 in Azure Analysis Services.
Writing optimized SQL queries for integration with other applications, maintaining data quality, and overseeing database security, partitions, and indexes. Experience with performance monitoring tools 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.
Apply data visualization best practices and tell stories through data visuals and reports to inform stakeholders on key factors driving outcomes.
Excellent communication and presentation skills with the 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
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting
#J-18808-Ljbffr
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
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.
Responsibilities
Minimum 12 years of experience working with Data warehousing, data analysis, source-to-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.
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, deployment in Azure, and querying data from AAS to build reports.
Experience developing, optimizing, and administering Tabular Models in Azure Analysis Services.
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 in Azure Analysis Services.
Writing optimized SQL queries for integration with other applications, maintaining data quality, and overseeing database security, partitions, and indexes. Experience with performance monitoring tools 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.
Apply data visualization best practices and tell stories through data visuals and reports to inform stakeholders on key factors driving outcomes.
Excellent communication and presentation skills with the 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
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting
#J-18808-Ljbffr