Senior Technical Lead
SEI · Oaks, PA · 3 wk ago
EngineeringFull-time
We need to output HTML fragment with sections: About the role? The posting includes job duties and responsibilities. We need headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We must include only sections with real content. No Pay or Schedule given. Benefits are described: "SEI’s Competitive Advantage ..." includes benefits. So we can have Benefits section. About the role maybe we can include a brief description from duties? The posting includes "Job Duties:" and then description. We can treat that as Responsibilities. Also there is a list of duties under "The Senior Technical Lead will:" which is responsibilities. So we can have Responsibilities section with
- . Also maybe "About the role" could be a short paragraph summarizing role? But we must not invent content. Could we use the first paragraph after Job Duties as About the role? The text: "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:" That's more like qualifications. Might be better to put that under Requirements? Actually Requirements section lists years of experience. The earlier paragraph is more like a summary of required experience. Could treat as About the role: a brief description. But we must not invent. The posting does not have a separate "About the role" heading. However we can create a section if we have real content: we could use the first sentence as a summary. But that might be considered inventing? It's directly from the posting, so it's okay to use it as content. The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." So we can copy text verbatim into appropriate sections. We need to decide sections.
We have:
- Job Duties: list of technologies and responsibilities.
- The Senior Technical Lead will: list of responsibilities.
- Requirements: detailed years.
- Alternative Requirements: alternative path.
- Benefits: described.
- No Pay or Schedule.
Thus we can have sections: Responsibilities (combining Job Duties and the will list), Requirements (including both primary and alternative?), maybe Qualifications (education). Skills maybe not separate; we could put skills under Requirements. But we need to follow headings list: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule.
We need to include only those with real content. We have Responsibilities, Requirements, Benefits. Possibly Qualifications (education) from Alternative Requirements: Bachelors degree... That's qualification. So we can have Qualifications section with that. Skills maybe not separate; we could omit Skills if no specific skill list beyond what's in Requirements. But we could treat the technology list as Skills. However that would duplicate. Better to omit Skills if not distinct.
About the role: we could use a short paragraph summarizing role: maybe the first sentence: "The Senior Technical Lead relies on experience with an application development organization, specifically delivering systems and projects from inception through implementation." That's substantive. We'll put that in About the role.
Thus sections: About the role, Responsibilities, Requirements, Qualifications, Benefits.
Now format:
About the role
The Senior Technical Lead relies on experience with an application development organization, specifically delivering systems and projects from inception through implementation.
Responsibilities: combine the bullet list from Job Duties and the will list. Need to avoid duplication. Let's extract unique responsibilities. From Job Duties: list of technologies (Snowflake, Python, DBT, Airflow, Power BI, DAX, relational DBs, UI Web dev framework, Unstructured data, DevOps, Event streaming, multi-tiered cloud apps). Those are more like required skills/experience, not duties. But they are listed under Job Duties. We could treat them as responsibilities: "Work with Snowflake including query tuning, cluster keys, pruning, secure views, and data-sharing concepts; Work with Python, DBT and Airflow for building and maintaining data transformation logic and incremental views for reporting tool on cloud; Build transformation logic code based on mapping to migrate data from one system to another system or build reports; Develop Power BI dashboards, reports, and data visualizations; Write DAX expressions and optimize Power BI performance; Work with relational databases such as Oracle, MySQL, SQL Server; Use UI Web development framework; Work with unstructured data and persistence model such as MongoDB, Snowflake; Use DevOps toolsets for versioning, containers such as Git, Docker, Kubernetes, Jenkins & GitLab; Work with event/data streaming platform such as Kafka; Design and develop Cloud Native applications; Create microservices applications using technologies such as REST, JSON, Spring Boot and Java; Deploy and configure well performing Cloud Native application; Use ORM tools (Hibernate, JPA)." That's a lot. Then the "The Senior Technical Lead will:" list: 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; Provide technical problem resolution and application support, as required. We need to combine and avoid duplication. Many items overlap (Snowflake pipelines etc). We'll produce a unified list, maybe merging similar points. We'll create- items. We'll need to ensure we preserve all substantive information; we can combine but must not lose detail. If we combine, we risk losing some nuance but still preserving info. The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." Combining could be considered summarizing but not losing detail if we keep all points. We'll try to keep each distinct point. Let's list all distinct responsibilities from both sections: From Job Duties (technology-focused): - Work with Snowflake, including query tuning, cluster keys, pruning, secure views, and data-sharing concepts. - Work with Python, DBT and Airflow for building and maintaining data transformation logic and incremental views for reporting tool on cloud. - Build transformation logic code based on mapping to migrate data from one system to another system or build reports. - Develop Power BI dashboards, reports, and data visualizations. - Write DAX expressions and optimize Power BI performance. - Work with relational databases such as Oracle, MySQL, SQL Server. - Use UI Web development framework. - Work with unstructured data and persistence model such as MongoDB, Snowflake. - Use DevOps toolsets for versioning, containers such as Git, Docker, Kubernetes, Jenkins & GitLab. - Work with event/data streaming platform such as Kafka. - Design and develop Cloud Native applications. - Create microservices applications using technologies such as REST, JSON, Spring Boot and Java. - Deploy and configure well performing Cloud Native application. - Use ORM tools (Hibernate, JPA). From 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. - Provide technical problem resolution and application support, as required. Now we need to merge duplicates: For example, Snowflake pipelines appears both; we can keep one that includes details. We'll keep the more detailed from will list: "Build, optimize, and maintain data pipelines and workflows using Snowflake, including secure views, cluster key optimization, pruning techniques, and data-sharing capabilities." That covers query tuning etc. Also the job duties list includes "Work with Snowflake, including query tuning, cluster keys, pruning, secure views, and data-sharing concepts." Similar. We'll keep the will list version. Similarly, Power BI: will list includes design/develop/maintain Power BI reports and dashboards, integrate Power BI with Snowflake and develop data models and DAX calculations. Job duties list includes develop Power BI dashboards, reports, data visualizations; write DAX expressions and optimize Power BI performance. We'll keep will list items plus maybe mention optimizing performance? The will list includes develop data models and DAX calculations; not explicitly optimizing performance. Could add "optimize Power BI performance" from job duties. We'll include both. Similarly, DBT: will list includes implement DBT to build and maintain incremental views; job duties includes building and maintaining data transformation logic and incremental views for reporting tool on cloud using Python, DBT and Airflow. We'll keep will list plus maybe mention building transformation logic with Python, DBT, Airflow. Similarly, Airflow: will list includes create, schedule, manage workflows with Airflow; job duties includes building and maintaining data transformation logic and incremental views for reporting tool on cloud using Python, DBT and Airflow. We'll keep will list plus maybe mention building transformation logic. Similarly, dimensional modeling: will list includes implement dimensional modeling techniques. Similarly, data governance: will list includes apply data governance best practices. Similarly, technical leadership: will list includes provide technical leadership, collaborate, suggest improvements, ensure team alignment, provide support. Similarly, develop technical solutions based on requirements (Agile): will list includes that. Similarly, produce high-quality code: will list includes. Similarly, analyze/resolve issues: will list includes. Similarly, design/develop Cloud Native apps: will list includes design/develop Cloud Native applications, create microservices using REST, JSON, Spring Boot, Java, deploy/configure Cloud Native app, use ORM tools. Job duties list includes similar. We'll keep will list items. Similarly, DevOps toolsets: will list not mention but job duties includes. We'll add "Use DevOps toolsets for versioning, containers such as Git, Docker, Kubernetes, Jenkins & GitLab." Similarly, unstructured data: job duties includes work with unstructured data and persistence model such as MongoDB, Snowflake. We'll add. Similarly, event