Software Architect – Development

CSS; Pittsburgh (Allegheny County); Hybrid; USD 130,000 - 190,000; Full time

Job summary

Wesco Distribution, Inc. in Pittsburgh, PA is seeking a Software Architect - Development to research, design, implement, and manage software and data programs. Hybrid work is available within the United States, with the employee living within commuting distance of Pittsburgh.

The role emphasizes SDLC leadership, data modeling, ETL/ELT processes, and collaboration with business and technical teams to deliver robust data-centric solutions.

Qualifications

• Requires a Bachelor's degree in Computer Science, Computer Engineering, Information Technology or related field.
• 5+ years in a lead development and architect role supporting data engineering processes.
• 5+ years of experience with ETL/ELT tools (Informatica, DataStage, Oracle PL/SQL, or SQL Server stored procedures) and SQL.
• 5+ years of data modeling experience for analytical models.
• Experience with BI tools (OBIEE, Oracle BI Publisher, Incorta, or QuickSight).
• Experience with large-scale data structures for BI analytics using ETL/ELT, SQL, and RDBMS (Oracle, SQL Server, Teradata).
• Proven problem solving and analytical skills to translate business requirements into technical specs.

Responsibilities

• Identify and develop areas for modification in existing programs and test new ones.
• Collaborate with business partners and other technical teams to deliver solutions.
• Manage evaluation, identification, development, and implementation of software solutions.
• Define, document, and record designs and modifications of applications or software.
• Identify and resolve failures in existing and new software systems.
• Design data models to support analytical and transactional use cases.
• Design real-time and batch interfaces and data pipelines in a cloud-native ecosystem.
• Guide development teams through SDLC phases and provide solution analysis and design.
• Troubleshoot production issues and ensure best practices are followed.
• Work with IT leadership to design features for the cloud platform.

Skills

Lead development

Data engineering

SDLC leadership

Cloud data pipelines

ETL/ELT experience

Education

Bachelor’s degree in Computer Science/Engineering or related field

Tools

Informatica PowerCenter

DataStage

Oracle PL/SQL

SQL Server

Teradata

Apache Airflow

Job description

Wesco Distribution, Inc. seeks a Software Architect - Development in Pittsburgh, PA responsible for researching, designing, implementing, and managing software and data programs. This is a hybrid office/work-from-home position within the United States, but the employee must live within commuting distance of the office in Pittsburgh, PA.

Responsibilities

• Identifying and developing areas for modification in existing programs, as well as testing and evaluating new programs.
• Collaborating with business partners and other technical teams across the organization to deliver proposed solutions.
• Managing the evaluation, identification, development, and implementation of software solutions.
• Defining, documenting and recording designs and modifications of application or software.
• Identifying and resolving failures within existing and newly developed software systems and programs.
• Designing data models for the enterprise to support analytical and transactional use cases.
• Designing real-time and batch system interfaces and data enrichment pipelines in a cloud-native data ecosystem.
• Guiding development teams through all phases of the software development life cycle (SDLC) and providing customer technical support solution analysis and design, and balancing technical and business aspects.
• Troubleshooting production issues of all levels and severities, tracking progress from identification through resolution and ensuring best practices are followed.
• Working with IT leadership and business partners to design features for the cloud platform.

Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering, Information Technology or related field.
• 5 years of experience in a lead development and architect role supporting data engineering processes.
• 5 years of experience with ETL/ELT tools (Informatica, DataStage, Oracle PL/SQL, or SQL Server stored procedures), SQL, and Data Bases.
• 5 years of data modeling experience for analytical models.
• Experience with business intelligence tools (OBIEE, Oracle BI Publisher, Incorta or QuickSight).
• Experience with developing and operating large-scale data structures for business intelligence analytics using each of the following: ETL/ELT processes using Informatica PowerCenter, SQL, and RDBMS (including Oracle, SQL Server and Teradata).
• Experience with using problem solving and analytical skills to translate business requirements into technical specs in order to deliver robust data engineering solutions.
• Experience with orchestration tools – Apache Airflow.