Senior Technical Lead at SEI U.S. in Oaks, PA

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 transform