Senior IT Consultant - Data Engineering, ETL, Azure, ITIL, Java, C#, Python, Shell Scripting

Job Summary:

In addition to the responsibilities listed below, this position is responsible for providing support for customers (users), and assigned applications and/or information systems, including software implementation, cross-functional integration, complex configuration, and testing.

Additional responsibilities also include leading solution design support efforts and research initiatives for translating requirements into workable technical solutions, and supporting the evaluation of third-party vendors as directed.

Essential Responsibilities:

• Conducts or oversees business-specific projects by applying deep expertise in subject area; promoting adherence to all procedures and policies; developing work plans to meet business priorities and deadlines; determining and carrying out processes and methodologies; coordinating and delegating resources to accomplish organizational goals; partnering internally and externally to make effective business decisions; solving complex problems; escalating issues or risks, as appropriate; monitoring progress and results; recognizing and capitalizing on improvement opportunities; evaluating recommendations made; and influencing the completion of project tasks by others.
• Practices self-leadership and promotes learning in others by building relationships with cross-functional stakeholders; communicating information and providing advice to drive projects forward; influencing team members within assigned unit; listening and responding to, seeking, and addressing performance feedback; adapting to competing demands and new responsibilities; providing feedback to others, including upward feedback to leadership and mentoring junior team members; creating and executing plans to capitalize on strengths and improve opportunity areas; and adapting to and learning from change, difficulties, and feedback.
• Develops requirements, or leads a team of IT consultants in the development of requirements for complex or specialized process or system solutions which may span multiple business domains by partnering with stakeholders and appropriate IT teams (for example, Solutions Delivery, Infrastructure, Enterprise Architecture).
• Leverages multiple business requirements gathering methodologies to identify business, functional, and non-functional requirements (for example, SMART) across the enterprise.
• Leads and oversees the development and documentation of comprehensive business cases to assess the costs, benefits, ROI, and Total Cost of Ownership (TCO) of complex solution proposals.
• Provides insight, guidance, and recommendations throughout the evolution of applications, systems, and/or processes to a desired future state by maintaining and leveraging a comprehensive understanding of how current processes impact business operations across the enterprise.
• Maps current state against future state processes.
• Defines the impact of requirements on upstream and downstream solution components.
• Provides insight and influence to senior management and business leaders on how to integrate requirements with current systems and business processes across the enterprise.
• Reviews, evaluates, and prioritizes value gaps and opportunities for process enhancements or efficiencies.
• Influences solution design by providing insight and consultation at design sessions with IT teams to help translate requirements into workable business solutions.
• Recommends and advocates for additional data and/or services needed to address key business issues related to process or solutions design.
• Participates in evaluating third-party vendors as directed.
• Drives continuous process improvement by leading the development, implementation, and maintenance of standardized tools, templates, and processes across the enterprise.
• Recommends and advocates for regional and national process improvements which align with sustainable best practices, and the strategic and tactical goals of the business.

Minimum Qualifications:

• Minimum two (2) years experience in software or system testing across multiple IT environments.
• Minimum one (1) year software or application development experience.
• Bachelors degree in Business Administration, Computer Science, CIS or related field and Minimum eight (8) years experience in IT consulting, business analysis, or a related field. Additional equivalent work experience may be substituted for the degree requirement.

Additional Requirements:

Preferred Qualifications:

• Certified Business Analyst Professional (CBAP) or other comparable business analyst or IT consulting certification
• Three (3) years experience in large scale software implementations
• Design and Development of Data Engineering Pipelines - ETL, ELT framework and Azure Data Platform
• Solution Architecture using Azure, Databricks and Informatica Platforms - Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Databricks ETL, Informatica Intelligent Cloud Services (IICS) and REST API Services Development
• Knowledge of Synapse, Databricks, Stored Procedures, PL/SQL
• Knowledge of Kimbell's methodology, ITIL Operating Model, and Data Quality Concepts
• Knowledge Python, DataFrames, Java, C# and Shell Scripting

Primary Location: California,Pleasanton,Pleasanton Tech Cntr Building A
Scheduled Weekly Hours: 40
Shift: Day
Workdays: Mon, Tue, Wed, Thu, Fri
Working Hours Start: 08:00 AM
Working Hours End: 05:00 PM
Job Schedule: Full-time
Job Type: Standard
Worker Location: Remote
Employee Status: Regular
Employee Group/Union Affiliation: NUE-IT-01|NUE|Non Union Employee
Job Level: Individual Contributor
Department: KPIT ADMIN - RISK ADJUST PROG DEL - 9601
Pay Range: $147200 - $190410 / year
Travel: No Kaiser Permanente is an equal opportunity employer committed to fair, respectful, and inclusive workplaces. Applicants will be considered for employment without regard to race, religion, sex, age, national origin, disability, veteran status, or any other protected characteristic or status.