Senior Technical Lead

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

This position is eligible for our employee referral program.

SEI's competitive advantage:

To help you stay energized, engaged and inspired, we offer a wide range of benefits including comprehensive care for your physical and mental well-being, a strong retirement plan, tuition reimbursement, support for working parents and flexible Paid Time Off (PTO) so you can relax, recharge and be there for the people you care about.


Benefits include healthcare (medical, dental, vision, prescription, wellness, EAP, FSA), life and disability insurance (premiums paid for base coverage), 401(k) match, education assistance, commuter benefits, up to 11 paid holidays/year, 21 days PTO/year pro-rated for new hires which increases over time, paid parental leave, back-up childcare arrangements, paid volunteer days, a discounted stock purchase plan, investment options, access to thriving employee networks and more.

We are a technology and asset management company delivering on our promise of building brave futures (SM)-for our clients, our communities, and ourselves. Come build your brave future at SEI.


The position title reflected in this job description is aligned with SEI's current internal job architecture. As part of SEI's role and career framework, internal job titles may not directly correspond to external market titles and may differ from titles previously assigned during an employee's tenure or at the time of hire.

SEI is an Equal Opportunity Employer and so much more...

After over 50 years in business, SEI remains a leading global provider of investment processing, investment management, and investment operations solutions. Reflecting our experience within financial services and financial technology our offices encompass an open floor plan and numerous art installations designed to encourage innovation and creativity in our workforce. We recognize that our people are our most valuable asset and that a healthy, happy, and motivated workforce is key to our continued growth. At SEI, we're (literally) invested in your success. We offer our employees paid parental leave, back-up childcare arrangements, paid volunteer days, education assistance and access to thriving employee networks.


SEI is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability status, protected veteran status, or any other characteristic protected by law.

AI Acceptable Use in the application and interview process:

SEI acknowledges the growing integration of artificial intelligence (AI) tools into individuals' personal and professional lives. If you intend to incorporate the use of any AI tools at any stage of the application and/or interview process, please ensure you have reviewed and adhere to our AI use guidelines.