Business Intelligence Architect

3 days ago


Hoboken, United States System One Full time
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
  1. 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.
  2. 10+ years of experience in Microsoft SQL Server and relational SQL databases that include data modeling, development, and management.
  3. Experience in designing database tables and structures, creating views functions, and stored procedures as required.
  4. 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.
  5. Experience in developing, optimizing, and administering Tabular Models in Azure Analysis Services.
  6. 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.
  7. Experience in writing optimized SQL queries for integration with other applications, maintaining data quality, and overseeing database security, Partitions, and Index.
  8. Experience using performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries, and troubleshoot cubes SQL and T-SQL.
  9. Experience or knowledge of reporting tools like Power BI, Cognos, or Tableau preferred.
  10. 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.
  11. 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.

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

#J-18808-Ljbffr

  • Hoboken, United States ALTA IT Services Full time

    BUSINESS INTELLIGENCE ARCHITECT – Azure Analysis Services AASContract to Hire Work Location: Hybrid work in Jersey City, NJHourly Rate: $75/hr. W2 for the contract period. Benefits availableAnnual Salary Rang...


  • Hoboken, United States Stevens Institute of Technology, The Innovation University Full time

    Job Description Business Intelligence Engineer The Office of Institutional Research and Effectiveness (IRE) at Stevens is inviting applications for the position of Business Intelligence Engineer to join a team of talented colleagues. Under the supervision of the Associate Director, the Business Intelligence Engineer will design, develop, and support Business...


  • Hoboken, United States ALTA IT Services Full time

    BUSINESS INTELLIGENCE DEVELOPER – COGNOS Contract to Hire Work Location: Hybrid work in Jersey City, NJHourly Rate: $60/hr. W2 for the contract period. Benefits availableAnnual Salary Range: $120,000...


  • Hoboken, New Jersey, United States NICE Systems Full time

    Role OverviewWe are seeking a skilled Business Intelligence Specialist to join our team. As a key member of the Actimize Watch Fraud Group, you will play a critical role in analyzing data, identifying fraud patterns, and developing strategies for prevention.Key ResponsibilitiesConsult with clients on fraud prevention strategies.Analyze financial data to...


  • Hoboken, United States System One Full time

    DATA/WAREHOUSE ARCHITECT – SQL SERVER, AZURE, COGNOSALTA is looking for a Data Warehouse Architect with at least 12 years of experience in designing and developing database and data warehouse systems, both on-premises and in the cloud. The role will support an IT engineering and consulting company on a large transportation program in Jersey City, NJ. Work...


  • Hoboken, New Jersey, United States Stevens Institute of Technology, The Innovation University Full time

    Job DescriptionCompany OverviewThe Stevens Institute of Technology is a world-class research university that seeks to foster innovation and collaboration among students, faculty, and industry partners. Our campus provides a unique environment for academic excellence and professional development.Key ResponsibilitiesAs a Business Intelligence Engineer at the...


  • Hoboken, New Jersey, United States Stevens Institute of Technology, The Innovation University Full time

    Job DescriptionKey ResponsibilitiesAs a Business Intelligence Engineer at the Stevens Institute of Technology, you will be responsible for designing, developing, and supporting Business Intelligence solutions to turn data into actionable insights supporting university decision making, analytics, and research. This role involves working closely with...

  • Solutions Architect

    2 days ago


    Hoboken, United States Marsh & McLennan Companies Full time

    Company: Marsh McLennan AgencyOur not-so-secret sauce.Award-winning, inclusive, Top Workplace culture doesn’t happen overnight. It’s a result of hard work by extraordinary people. More than 11,000 of the industry’s brightest talent drive our efforts to deliver purposeful work and meaningful impact every day. Learn more about what makes us different and...


  • Hoboken, New Jersey, United States Ernst and Young Full time

    At EY, we're committed to creating a culture where everyone feels empowered to use their voice to help others find theirs.We believe that diversity and inclusion are essential to building a better working world.As an EPM Solution Architect, you will be part of a team that is passionate about delivering exceptional client service and making a meaningful...


  • Hoboken, New Jersey, United States Walmart Full time

    Job DescriptionThe Director, Advanced Analytics - Governance & Strategy will play a pivotal role in ensuring seamless end-to-end execution of critical projects and initiatives that directly enable the growth of our Analytics function for Walmart eCommerce. You'll foster collaboration among stakeholders, leverage your expertise to drive results, and ensure...


  • Hoboken, United States Ernst and Young Full time

    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better. Join us and build an exceptional experience for yourself, and a better working world for all.The...

  • Solution Architect

    4 days ago


    Hoboken, United States NICE Full time

    At NICE, we don’t limit our challenges. We challenge our limits. Always. We’re ambitious. We’re game changers. And we play to win. We set the highest standards and execute beyond them. And if you’re like us, we can offer you the ultimate career opportunity that will light a fire within you.So, what’s the role all about?This is a rare opportunity to...

  • Data Warehouse

    4 days ago


    Hoboken, United States System One Full time

    ALTA is looking for a Data Warehouse / ETL Developer with 8+ years of experience in designing, developing, and supporting Data Warehouse and ETL processes. The ideal candidate should have strong skills in SSIS, SSAS, SSRS, and T-SQL, along with experience working with Azure data platforms and business intelligence tools like Power BI or Tableau. The role...

  • Oracle Services

    4 days ago


    Hoboken, United States Ernst and Young Full time

    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better. Join us and build an exceptional experience for yourself, and a better working world for all. The...


  • Hoboken, United States Ernst and Young Full time

    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better. Join us and build an exceptional experience for yourself, and a better working world for all.The...

  • Data Science

    1 week ago


    Hoboken, United States Ernst and Young Full time

    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better. Join us and build an exceptional experience for yourself, and a better working world for all.The...


  • Hoboken, United States NICE Full time

    At NICE, we don’t limit our challenges. We challenge our limits. Always. We’re ambitious. We’re game changers. And we play to win. We set the highest standards and execute beyond them. And if you’re like us, we can offer you the ultimate career opportunity that will light a fire within you.So, what’s the role all about?As a Software Integration...


  • Hoboken, United States MUFG Bank, Ltd. Full time $134,000 - $182,000

    Do you want your voice heard and your actions to count?Find out more about this role by reading the information below, then apply to be considered.Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), one of the world’s leading financial groups. Across the globe, we’re 120,000 colleagues, striving to make a difference for every client,...


  • Hoboken, United States Ernst and Young Full time

    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better. Join us and build an exceptional experience for yourself, and a better working world for all.The...

  • Product Manager

    3 hours ago


    Hoboken, New Jersey, United States Walmart Full time

    Job Description:As a Principal Product Manager at Walmart+, you will be responsible for driving the development of seamless, intuitive, and innovative experiences for our members across various channels.Key Responsibilities:- Develop core capabilities that power our organization and elevate the way we work.- Craft membership platform/capabilities strategies...