Software Architect Development

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