Data/Warehouse Architect

4 days ago


Hoboken, United States System One Full time
DATA/WAREHOUSE ARCHITECT – SQL SERVER, AZURE, COGNOS

ALTA 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 is expected to begin in mid-January 2025.

Sponsorship is not offered for this position.


The ideal candidate should have strong skills in SQL Server and Azure, along with expertise in ETL processes and data governance. Excellent communication skills are essential for collaboration across the organization.


EXPERIENCE / QUALIFICATIONS
  • Minimum 12 years of relevant experience in architecting, designing, and developing databases or Data Warehouse systems on-prem as well as in the cloud using industry best practices.
  • Experience in building end-to-end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
  • Maintain complex Data Warehouse models to ensure data integrity, including the development, enhancement, and administration of appropriate ETL functions in support of Cognos TM1 and Cognos BI frameworks and reports.
  • Experience in Data platform development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, and Azure IaaS/PaaS related to databases.
  • Experience in data governance, data management, data modeling, data cleansing, data extraction and transformation, data analysis, data migration, data integration and data mapping.
  • Strong experience using SQL Server Integration Services (SSIS), SSAS, and SSRS for analysis and report generation.
  • Proficient in writing complex T-SQL Queries, Stored Procedures, Views, and ETL in redesigning Databases/Data warehouses using SQL Server, SSIS, and any custom scripts.
  • Knowledge or working experience with Cognos BI environment or other business Intelligence toolsets such as Power BI or Tableau preferred.
  • Must be hands-on, deeply technical, and exposed to the latest features within data platform development, able to do both coding and guide junior database engineers.
  • Excellent communication and presentation skills with the ability to interact at all levels of the organization regularly.
  • Ability to act independently to resolve issues, excellent communication and interpersonal skills, strong critical & analytic thinking.

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

Work Location: Hybrid work in Jersey City, NJ
Hourly Rate: $60/hr. W2 for the contract period. Benefits available
Annual Salary Range: $120,000 to $130,000 annually plus benefits.

For consideration, please send an updated resume to Melissa McNally via mmcnally@altaits.com. #J-18808-Ljbffr
  • 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...

  • Cloud Data Engineer

    1 week ago


    Hoboken, NJ, United States ALTA IT Services Full time

    CLOUD DATA ENGINEER - AZURE, SQL SERVER Do not pass up this chance, apply quickly if your experience and skills match what is in the following description. Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $60/hr. W2 for the contract period. Benefits available Annual Salary Range: $120,000 range annually plus benefits. ALTA IT...


  • Hoboken, New Jersey, United States Marsh LLC Full time

    Unlock Your Potential as a Senior Solutions ArchitectAt Marsh McLennan Agency, we're on a mission to deliver purposeful work and meaningful impact every day. As a Senior Solutions Architect, you'll play a pivotal role in driving technology solutions that align with and advance business objectives.Key Responsibilities:Lead collaboration with Technology and...


  • Hoboken, United States Alta It Services Full time

    COGNOS TM1 ARCHITECT Please double check you have the right level of experience and qualifications by reading the full overview of this opportunity below. Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $70/hr. W2 for the contract period. Benefits available Annual Salary Range: $130,000 range annually plus benefits. ALTA IT...


  • Hoboken, United States System One Full time

    BUSINESS INTELLIGENCE ARCHITECT – Azure Analysis Services AASContract to HireWork Location: Hybrid work in Jersey City, NJHourly Rate: $75/hr. W2 for the contract period. Benefits availableAnnual 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...


  • Hoboken, United States ALTA IT Services 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...


  • Hoboken, United States ALTA IT Services Full time

    ALTA is looking for a Microsoft Power Platform Architect with a minimum of 12 years of IT experience, including architecture, development, and delivering end-to-end solutions. The ideal candidate should be proficient in modern programming languages such as C#, SQL, and JavaScript, and have at least 5 years of hands-on experience with Microsoft Dynamics,...


  • Hoboken, New Jersey, United States Walmart Full time

    About the Role: As a Senior Technical Solutions Architect at Walmart Global Tech, you will play a key role in driving the solution scoping, resource requirements, and effort estimation during the sales process.Your Responsibilities:Define the solution functional and technical design for the WCT SaaS solutions, including integration and business process...

  • Python Pyspark

    5 days ago


    Hoboken, United States ZAPCOM GROUP INC Full time

    Job DescriptionJob DescriptionPython/Pyspark (Data Engineer)Duties and responsibilities● Collaborate with the team to build out features for the data platform and consolidate data assets● Build, maintain and optimize data pipelines built using Spark● Advise, consult, and coach other data professionals on standards and practices● Work with the team to...

  • Staff Data Scientist

    1 month ago


    Hoboken, New Jersey, United States Walmart Full time

    Job SummaryWe are seeking a highly skilled Staff Data Scientist to join our team in Hoboken, NJ. As a key member of our data science team, you will be responsible for architecting and developing new Machine Learning models to enhance the eCommerce user search experience.This is an exciting opportunity for a creative and innovative professional who thrives in...


  • 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, NJ, United States ALTA IT Services Full time

    COGNOS TM1 ARCHITECT Please double check you have the right level of experience and qualifications by reading the full overview of this opportunity below. Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $70/hr. W2 for the contract period. Benefits available Annual Salary Range: $130,000 range annually plus benefits. ALTA IT...


  • Hoboken, NJ, United States ALTA IT Services Full time

    BUSINESS INTELLIGENCE ARCHITECT - Azure Analysis Services AAS Scroll down to find an indepth overview of this job, and what is expected of candidates Make an application by clicking on the Apply button. 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:...


  • Hoboken, NJ, United States ALTA IT Services Full time

    ALTA is looking for a Microsoft Power Platform Architect with a minimum of 12 years of IT experience, including architecture, development, and delivering end-to-end solutions. The ideal candidate should be proficient in modern programming languages such as C#, SQL, and JavaScript, and have at least 5 years of hands-on experience with Microsoft Dynamics,...


  • Hoboken, United States ALTA IT Services Full time

    ALTA is looking for a Microsoft Power Platform/Power BI Developer with 8+ years of IT experience in designing, developing, and testing applications. The candidate should have at least 5 years of experience working with Microsoft Power Platform or Dynamics 365, as well as strong proficiency in Power BI development, including data modeling, report creation,...


  • Hoboken, New Jersey, United States Walmart Full time

    Job SummaryWe are seeking a skilled Senior Software Engineer to lead the design and implementation of high-performance edge systems.About the RoleProvide technical leadership and use engineering best practices to initiate, plan, and execute large-scale, cross-functional, and company-wide projects.Demonstrate craftsmanship and produce high-quality software...

  • Solution Architect

    2 weeks 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...

  • Oracle Services

    2 weeks 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 Alta It Services Full time

    BUSINESS INTELLIGENCE DEVELOPER – COGNOS Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $60/hr. W2 for the contract period. Benefits available Annual Salary Range: $120,000 to $130,000 annually plus benefits. ALTA IT Services has a contract-to-hire opening for a Business Intelligence Developer with a minimum of 10 years of...


  • Hoboken, United States ALTA IT Services Full time

    BUSINESS INTELLIGENCE DEVELOPER – COGNOS Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $60/hr. W2 for the contract period. Benefits available Annual Salary Range: $120,000 to $130,000 annually plus benefits. ALTA IT Services has a contract-to-hire opening for a Business Intelligence Developer with a minimum of 10...