About this opportunity
SEI lists this Senior Technical Lead opportunity in oaks, Pennsylvania. Review the employer’s description below for duties, qualifications and application requirements.
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; 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).
Benefits
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
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.
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
#J-18808-Ljbffr
Worksite address
oaks, PA, 19456, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.