Software Engineering Associate Advisor

Responsibilities

• Support, maintain and participate in the development of software utilizing technologies such as COBOL, DB2, CICS and JCL.
• Support, maintain and participate in the ETL development of software utilizing technologies such as Talend, Ab-Initio, Python, PySpark using Databricks.
• Work with Databricks to design and manage scalable data processing solutions.
• Implement and support data integration workflows across cloud (AWS) and on-premises environments.
• Support cloud infrastructure deployment and management using Terraform.
• Participate in the modernization of legacy systems, including mainframe migration.
• Perform complex SQL queries and performance tuning on large datasets.
• Contribute to CI/CD pipelines, version control, and infrastructure automation.
• Provide expertise, tools, and assistance to operations, development, and support teams for critical production issues and maintenance
• Troubleshoot production issues, diagnose the problem, and implement a solution - First line of defense in finding the root cause
• Work cross-functionally with the support team, development team and business team to efficiently address customer issues.
• Active member of high-performance software development and support team in an agile environment
• Engaged in fostering and improving organizational culture.

Qualifications

Required Skills:

• Strong analytical and technical skills.
• Proficiency in Databricks including notebook development, Delta Lake, and Spark-based process.
• Experience with mainframe modernization or migrating legacy systems to modern data platforms.
• Strong programming skills, particularly in PySpark for data processing.
• Familiarity with data warehousing concepts and cloud-native architecture.
• Solid understanding of Terraform for managing infrastructure as code on AWS.
• Familiarity with CI/CD practices and tools (e.g., Git, Jenkins).
• Strong SQL knowledge on OLAP DB platforms (Teradata, Snowflake) and OLTP DB platforms (Oracle, DB2, Postgres, SingleStore).
• Strong experience with Teradata SQL and Utilities
• Strong experience with Oracle, Postgres and DB2 SQL and Utilities
• Develop high quality database solutions
• Ability to do extensive analysis on complex SQL processes and design skills
• Ability to analyze existing SQL queries for performance improvements
• Experience in software development phases including design, configuration, testing, debugging, implementation, and support of large-scale, business centric and process-based applications
• Proven experience working with diverse teams of technical architects, business users and IT areas on all phases of the software development life cycle.
• Exceptional analytical and problem-solving skills
• Structured, methodical approach to systems development and troubleshooting
• Ability to ramp up fast on a system architecture
• Experience in designing and developing process-based solutions or BPM (business process management)
• Strong written and verbal communication skills with the ability to interact with all levels of the organization.
• Strong interpersonal/relationship management skills.
• Strong time and project management skills.
• Familiarity with agile methodology including SCRUM team leadership.
• Familiarity with modern delivery practices such as continuous integration, behavior/test driven development, and specification by example.
• Desire to work in application support space
• Passion for learning and desire to explore all areas of IT.