Senior Technical Lead

seic; Pennsylvania; On-site; USD 120,000 - 180,000; Full time

Job summary

SEI Investments Company is seeking a Senior Technical Lead to guide data-centric software delivery. The role emphasizes building and maintaining Snowflake data pipelines, DBT and Airflow workflows, and Power BI dashboards, while applying governance and cloud-native principles.

You will lead multi-disciplinary teams, design scalable architectures, and ensure delivery from inception to implementation. Strong SQL, Java/Spring Boot, REST, and DevOps experience are essential.

Qualifications

• Nine years of experience in an application development organization.
• Experience delivering systems from inception through implementation.
• Experience with Snowflake: query tuning, cluster keys, pruning, secure views, data sharing.
• Experience with Python, DBT and Airflow for data transformation and cloud reporting.
• Experience building transformation logic to migrate data or build reports.
• Experience with Power BI: dashboards, reports, data visualizations, DAX expressions.
• Experience with relational databases (Oracle, MySQL, SQL Server).
• Experience with UI Web development frameworks.
• Experience with unstructured data and persistence models (MongoDB, Snowflake).
• DevOps toolsets for versioning and containers (Git, Docker, Kubernetes, Jenkins & GitLab).
• Experience with Kafka for event/data streaming.
• Four years of experience with multi-tier cloud-based applications; cloud-native design, microservices with REST/JSON, Spring Boot and Java.
• Experience with deploying and configuring high-performing Cloud Native applications.
• Familiarity with ORM tools (Hibernate, JPA).

Responsibilities

• Develop technical solutions from requirements using Agile processes.
• Build and maintain Snowflake data pipelines and secure views; optimize clustering and pruning; enable data sharing.
• Implement dimensional modeling for analytics readiness.
• Create and manage Airflow workflows for ELT pipelines.
• Use DBT to maintain incremental views for reporting and analytics.
• Design and maintain Power BI reports and dashboards; develop Data Models and DAX calculations.
• Integrate Power BI with Snowflake for actionable BI insights.
• Apply data governance and ensure data quality and compliance.
• Provide technical leadership and resolve issues during development and testing phases.
• Collaborate with data architects, project managers, and stakeholders to address scheduling and technical issues.
• Suggest process improvements for estimates and testing; ensure alignment with SEI standards.

Skills

Snowflake

Python

Power BI

DAX

SQL

MongoDB

Kafka

Git

Docker

Kubernetes

Jenkins

GitLab

Airflow

DBT

Java

Spring Boot

REST/JSON

Cloud Native

Hibernate/JPA

Tools

Git

Docker

Kubernetes

Jenkins

GitLab

Airflow

DBT

Job description

Employer: SEI Investments Company
Position: Senior Technical Lead
Location: 1 Freedom Valley Drive, Oaks, PA 19456

Job 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 required

Requirements

• 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
• 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
• 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 confi