Senior Technical Lead

SEI Corporation; Northern (KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

SEI Investments Company is seeking a Senior Technical Lead to drive cloud-native data solutions. You will design and implement data pipelines with Snowflake, build BI dashboards in Power BI, and lead multi-tier applications in Java/Spring Boot.

The role requires deep experience across Python, DBT, Airflow, and modern DevOps, with a focus on scalable analytics platforms and data governance.

Qualifications

• Nine (9) years of experience delivering systems and projects from inception through implementation.
• Nine (9) years in Snowflake-related capabilities (query tuning, cluster keys, pruning, secure views, data-sharing).
• Nine (9) years with Python, DBT, and Airflow for cloud data transformations.
• Nine (9) years with Power BI for dashboards and data visualizations.
• Eight (8) years with relational databases (Oracle, MySQL, SQL Server) and UI Web development.
• Eight (8) years with unstructured data/persistence models (MongoDB, Snowflake) and DevOps tools (Git, Docker, Kubernetes, Jenkins, GitLab).
• Four (4) years in cloud-based multi-tier applications (Cloud Native, microservices, REST, Spring Boot, Java; ORM tools).

Responsibilities

• Develop and design technical solutions from business requirements using Agile methodology.
• Build and optimize data pipelines and ELT workflows in Snowflake; apply clustering, pruning, and data sharing.
• Implement dimensional modeling for analytics and BI readiness.
• Create and manage Airflow workflows for reliable ETL/ELT processes.
• Develop and maintain Power BI reports and dashboards; integrate with Snowflake and optimize DAX.
• Collaborate with data architects and stakeholders to address scheduling and technical issues.
• Provide technical leadership and mentorship to project teams; ensure alignment with SEI standards.

Skills

Snowflake

Python

DBT

Airflow

Power BI

SQL

Java/Spring Boot

REST/JSON

Kafka

Git/Docker/Kubernetes

Jenkins/GitLab

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle

MySQL

SQL Server

MongoDB

Snowflake

Job description

## Senior Technical LeadApply: USA - PA - Oaks: Full time: Posted Today: End Date: October 14, 2026 (20 days left to apply): R0038036Employer: SEI Investments CompanyPosition: Senior Technical LeadLocation: 1 Freedom Valley Drive, Oaks, PA 19456Job Duties: The Senior Technical Lead relies on experience with an application development organization, specifically delivering systems and projects from inception through implementation, as well as the following: with Snowflake, including query tuning, cluster keys, pruning, secure views, and data-sharing concepts; with Python, DBT and Airflow for building and maintaining data transformation logic and incremental views for reporting tool on cloud; on building transformation logic code based on mapping to migrate data from one system to another system or build reports; with Power BI development, creating dashboards, reports, and data visualizations; with Writing DAX expressions and optimizing Power BI performance; with Relational databases such as Oracle, MySQL, SQL Server; with UI Web development framework experience; Unstructured data and persistence model such as MongoDB, Snowflake; DevOps toolsets for versioning, containers, such as Git, Docker, Kubernetes, Jenkins & GitLab; Event/data streaming platform, such as Kafka; and working on multi-tiered applications that are designed, developed and delivered as cloud- based solutions, including the following: Designing and developing Cloud Native applications; Creating microservices applications using technologies such as REST, JSON, Spring Boot and Java; Deploying and configuring well performing Cloud Native application; and ORM tools (Hibernate, JPA).The Senior Technical Lead will: Develop and design technical solutions based on reading and understanding business and functional requirements following the Agile process; Build, optimize, and maintain data pipelines and workflows using Snowflake, including secure views, cluster key optimization, pruning techniques, and data-sharing capabilities; Implement dimensional modeling techniques to optimize data organization for analytics and business intelligence reporting; Create, schedule, and manage workflows with Airflow for seamless job orchestration and automation of reliable and efficient ELT pipelines; Implement DBT to build and maintain incremental views for reporting and analytics; Design, develop, and maintain Power BI reports and dashboards to provide insights and business intelligence based on various data sources; Integrate Power BI with Snowflake and develop data models and DAX calculations to provide business users with actionable insights; Apply data governance best practices, ensuring data quality, consistency, and compliance with enterprise standards; Produce high-quality code to meet all project deadlines and ensuring the functionality matches the requirements; Analyze and resolve issues found during the testing or pre-production phases of the software delivery lifecycle, coordinating changes with project team leaders and cross-work team members; Provide technical leadership to project team members and responding to inquiries regarding errors or questions about programs; Collaborate with data architects, technical leads, project managers, and other stakeholders to address scheduling and technical issues; Suggest and implement process improvements for estimating development and testing processes; Responsible for ensuring team designs and delivers code in alignment with published SEI & industry standards; and Provide technical problem resolution and application support, as requiredRequirements: Nine (9) years of prior work experience with an application development organization; must demonstrate experience delivering systems and projects from inception through implementation. Nine (9) years in each of the following: Experience with Snowflake, including query tuning, cluster keys, pruning, secure views, and data-sharing concepts; Experience with Python, DBT and Airflow for building and maintaining data transformation logic and incremental views for reporting tool on cloud; Experience on building transformation logic code based on mapping to migrate data from one system to another system or build reports; Experience with Power BI development, creating dashboards, reports, and data visualizations; Experience with Writing DAX expressions and optimizing Power BI performance; Experience with Relational databases such as Oracle, MySQL, SQL Server; and Experience with UI Web development framework experience. Eight (8) years in each of the following: Unstructured data and persistence model such as MongoDB, Snowflake; DevOps toolsets for versioning, containers, such as Git, Docker, Kubernetes, Jenkins & GitLab; and Event/data streaming platform, such as Kafka. Four (4) years of experience working on multi-tiered applications that are designed, developed and delivered as cloud- based solutions, including each of the following: Designing and developing Cloud Native applications; Creating microservices applications using technologies such as REST, JSON, Spring Boot and Java; Deploying and configuring well performing Cloud Native application; and ORM tools (Hibernate, JPA).Alternative Requirements: Bachelors degree, or equivalent, in Computer Science, Information Technology, Electrical/Electronic Engineering, or another related field. Seven (7) years of prior work experience with an application development organization; must demonstrate experience delivering systems and projects from inception through implementation. Seven (7) years in each of the following: Experience with Snowflake, including query tuning, cluster keys, pruning, secure views, and data-sharing concepts; Experience with Python, DBT and Airflow for building and maintaining data transformation logic and incremental views for reporting tool on cloud; Experience on building transformation logic code based on mapping to migrate data from one system to another system or build reports; Experience with Power BI development, creating dashboards, reports, and data visualizations; Experience with Writing DAX expressions and optimizing Power BI performance; Experience with Relational databases such as Oracle, MySQL, SQL Server; and Experience with UI Web development framework experience. Six (6) years in each of the following: Unstructured data and persistence model such as MongoDB, Snowflake; DevOps toolsets for versioning, containers, such as Git, Docker, Kubernetes, Jenkins & GitLab; and Event/data streaming platform, such as Kafka. Two (2) years of experience working on multi-tiered applications that are designed, developed and delivered as cloud- based solutions, including 2 years in each of the following: Designing and developing Cloud Native applications; Creating microservices applications using technologies such as REST, JSON, Spring Boot and Java; Deploying and configuring well performing Cloud Native application; and ORM tools (Hibernate, JPA).Please Mail Resumes to: Denise Mapes, Workforce Development, SEI Investments Company at 1 Freedom Valley Drive Oaks, PA 19456. Reference #STL0926SK.