BUSINESS INTELLIGENCE ARCHITECT – Azure Analysis Services AAS

Contract to Hire

Work Location: Hybrid work in Jersey City, NJ

Hourly Rate: $75/hr. W2 for the contract period. Benefits available

Annual Salary Range : $130,000 to $150,000 annually plus benefits.

ALTA IT Services has a contract-to-hire opening 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 role will support an IT engineering and consulting company on a large transportation program in Jersey City, NJ. Work is expected to begin in mid-January 2025.

Sponsorship is not offered for this position.

Seeking candidates with more than 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 within 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 of experience in Microsoft SQL Server and relational SQL databases that include data modeling, development, and management.

• Experience in 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 in developing, optimizing, and administering Tabular Models in 'Azure Analysis services'.

• Experience in designing and creating AAS/OLAP/ Tabular cubes and automating processes for analytical needs. Expertise in developing OLAP cubes and developing complex calculations, Aggregations, 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.

• Experience using performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries, and troubleshoot cubes SQL and T-SQL.

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

• Experience in applying data visualization best practices and telling 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 on a regular basis.

  EDUCATION

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

  Work Location: Hybrid work in Jersey City, NJ

  Hourly Rate: $75/hr. W2 for the contract period. Benefits available

  Annual Salary Range : $130,000 to $150,000 annually plus benefits.

  For consideration, please send an updated resume to Melissa McNally via mmcnally@altaits.com

  #M2

System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.