SQL Server Data Architect

1 week ago


Pittsburgh, United States CareerBuilder Full time

This is a full time role with pnc bank. 100% remote. USC/GC. Salary is 130-150K depending upon the location.

Summary
member of the Lending Applications (ACH, Cash, Payments, Insurance....) Data Architect team supporting 8 Agile Kanban Crews (mostly .NET, C# and SQL Server 2019, very little Oracle)
must be comfortable working with Microsoft Developers managing large amounts of data
must be comfortable with SQL, T SQL, DDL, DML, Dynamic SQL a plus, ETL process, stored procedures/triggers (the Microsoft Developers do most of the development)
responsible for Designing, Reporting, Architecting, Table and View Development, Modeling and Data Stores and managing ETL process

Must have:
DDL and DML scripts - writing and understanding
Create or enhance entity relation diagram
T - SQL
PL - SQL

Nice to have:
Dynamic SQL

Degrees or Certifications
No degree or certifications
Focused more on experience
#J-18808-Ljbffr



  • Pittsburgh, United States Diverse Lynx Full time

    Technical/Functional Skills SQL Server Integration Services (SSIS) Hands On Experience of minimum 4-6 years. Should have hands-on experience in Build, Test and Deploying SSIS packages and solutions. Experience of using different source systems for building SSIS ETL. Using Oracle as a source system is mandatory. Good knowledge in SQL Server Database and...


  • Pittsburgh, United States Techstra Solutions Full time

    Job DescriptionJob DescriptionAs an Azure Data Architect at Techstra Solutions, you will play a pivotal role in designing, implementing, and managing data architecture on the Azure cloud platform. You will collaborate with cross-functional teams to ensure that the data infrastructure meets business needs and adheres to industry best practices. If you are a...


  • Pittsburgh, United States Techstra Solutions Full time

    Job DescriptionJob DescriptionAs an Azure Data Architect at Techstra Solutions, you will play a pivotal role in designing, implementing, and managing data architecture on the Azure cloud platform. You will collaborate with cross-functional teams to ensure that the data infrastructure meets business needs and adheres to industry best practices. If you are a...

  • SQL SSIS Developer

    1 week ago


    Pittsburgh, United States Diverse Lynx Full time

    Title: SQL SSIS Developer Location: Pittsburgh, PA (Day1 onsite) Duration: 12+ Months contract Job Description- Job Title SQL SSIS Developer Relevant Experience (in Yrs) 4-6 Years Technical/Functional Skills •SQL Server Integration Services (SSIS) Hands On Experience of minimum 4-6 years. •Should have hands-on experience in Build, Test and Deploying SSIS...


  • Pittsburgh, United States All Lines Technology Full time

    Job DescriptionJob DescriptionAll Lines Technology has an immediate opening for a Data Integration Architect in Pittsburgh. The Data Integration Architect role is responsible for the planning, coordination, designing, and supervision of all architectural solutions related to the integration of data across disparate applications, and third-party solutions....


  • Pittsburgh, United States All Lines Technology Full time

    All Lines Technology has an immediate opening for a Data Integration Architect in Pittsburgh. The Data Integration Architect role is responsible for the planning, coordination, designing, and supervision of all architectural solutions related to the integration of data across disparate applications, and third-party solutions. The integration solutions are...

  • Senior Data Engineer

    Found in: Appcast US C2 - 2 weeks ago


    Pittsburgh, United States YinzCam, Inc. Full time

    NOTE: This in an in-office role in Pittsburgh, PA, USA. ABOUT YINZCAM Our digital products are used by 200+ professional sports teams and leagues around the world, including clubs in the NFL, NBA, MLS, NHL, LigaMX, AFL (Australia), and more.THE ROLEAs a Senior Data Engineer, you will be responsible for collecting, organizing and analyzing terabytes of...

  • Senior Data Engineer

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago


    Pittsburgh, United States YinzCam, Inc. Full time

    NOTE: This in an in-office role in Pittsburgh, PA, USA. ABOUT YINZCAM Our digital products are used by 200+ professional sports teams and leagues around the world, including clubs in the NFL, NBA, MLS, NHL, LigaMX, AFL (Australia), and more.THE ROLEAs a Senior Data Engineer, you will be responsible for collecting, organizing and analyzing terabytes of...

  • Senior Data Engineer

    2 weeks ago


    Pittsburgh, United States YinzCam, Inc. Full time

    NOTE: This in an in-office role in Pittsburgh, PA, USA. ABOUT YINZCAM Our digital products are used by 200+ professional sports teams and leagues around the world, including clubs in the NFL, NBA, MLS, NHL, LigaMX, AFL (Australia), and more.THE ROLEAs a Senior Data Engineer, you will be responsible for collecting, organizing and analyzing terabytes of...


  • Pittsburgh, United States Prequel Solutions Full time

    Job DescriptionJob DescriptionPrimary Success FactorsDesign and execute strategies to move data solutions/technologies from on-premise systems to cloud environments (public, private, or hybrid)Create scalable and efficient data architectures optimized for cloud services, considering factors like storage, compute, and data processing while adhering to...


  • Pittsburgh, United States Prequel Solutions Full time

    Job DescriptionJob DescriptionPrimary Success FactorsDesign and execute strategies to move data solutions/technologies from on-premise systems to cloud environments (public, private, or hybrid)Create scalable and efficient data architectures optimized for cloud services, considering factors like storage, compute, and data processing while adhering to...

  • SQL Developer

    1 week ago


    Pittsburgh, United States Saxon Global Full time

    This is a full time role with PNC Bank. USC/GC. Salary 110-130 MAX. Only EST/CST candidates. Client is looking for a SQL Deveoper that has strong exp with Hadoop. Any banking exp is plus. SQL 4 Years HADOOP 4 Years Day to Day Responsibilities: -MS SQL decent knowledge. Majority of the work is SQL related pulling data from external sources into MS SQL....

  • Cloud Data Architect I

    Found in: Talent US C2 - 2 weeks ago


    Pittsburgh, United States Duquesne Light Company Full time

    Duquesne Light Company, headquartered in downtown Pittsburgh, is a leader in providing electric energy and has been in the forefront of the electric energy market, with a history rooted in technological innovation and superior customer service. Today, the company continues its role as a leader in the transmission and distribution of electric energy,...

  • Data Integration Architect – Pittsburgh, PA – Hybrid

    Found in: Talent US C2 - 1 week ago


    Pittsburgh, United States Synergy Staffing Full time

    The Data Integration Architect role is responsible for the planning, coordination, designing, and supervision of all architectural solutions related to the integration of data across disparate applications, and third-party solutions. The integration solutions are primarily focused on connecting data on-premises and multiple cloud-based solutions. This...

  • Technical Architect

    2 days ago


    Pittsburgh, United States Diverse Lynx Full time

    Job Title: Technical CLoud Architect Location: Pittsburgh PA Type: Fulltime Job Description - Skills Cloud Architecture - •ll aspects, including full stack and cloud native architectures •Experience +Certification in one or more public cloud systems: Azure or Google •Knowledge of Pivotal is nice but not required. It is used in Client Ground so future...


  • Pittsburgh, United States Oloop Technology Solutions Full time

    Job Title: Full Stack Developer IV Location : Pittsburgh, PA Duration : 6 Months Job Description : We seek a strong Java/Angular Full Stack Developer to join our ETF Technology Team. Must have thorough and demonstrative knowledge of designing/architecting micro-service-based application platforms. The ideal candidate would have – 5 - 7 years of experience...

  • POS (Point of Sale )Architect/Lead

    Found in: Appcast US C2 - 7 days ago


    Pittsburgh, United States VLink Inc Full time

    Job Description : 15+ years of experience designing, building, deploying, operating, scaling, and evolving distributed systems and high-volume transaction applications in a 24/7 environment.Strong architecture and design skills with a track record of architecting and delivering distributed, cloud-based microservices, event-driven architectures and RESTful...

  • POS (Point of Sale )Architect/Lead

    Found in: Appcast Linkedin GBL C2 - 1 week ago


    Pittsburgh, United States VLink Inc Full time

    Job Description : 15+ years of experience designing, building, deploying, operating, scaling, and evolving distributed systems and high-volume transaction applications in a 24/7 environment.Strong architecture and design skills with a track record of architecting and delivering distributed, cloud-based microservices, event-driven architectures and RESTful...


  • Pittsburgh, United States VLink Inc Full time

    Job Description : 15+ years of experience designing, building, deploying, operating, scaling, and evolving distributed systems and high-volume transaction applications in a 24/7 environment.Strong architecture and design skills with a track record of architecting and delivering distributed, cloud-based microservices, event-driven architectures and RESTful...

  • Sr BI Analyst

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago


    Pittsburgh, United States Planet Technology Full time

    Perm rolePittsburghW2 hires only - client cannot transfer or sponsor a visa Sr BI AnalystNew role due to company growth ! Client is looking for someone who can provide expertise in data delivery and administration. Looking for tools such as IBM Cognos and Power BI Reports. You will provide expertise in data warehousing using relational database (e.g....