Senior Data Engineer & BI Developer, SEO - 27149

We need to output HTML fragment with sections: h3 headings for sections present. Must not repeat job title. Must not include Job ID etc. Must include only sections with real content. Must preserve all substantive info. Remove boilerplate like EEO, accommodation, etc. Must not include application instructions (like "Please include a resume and cover letter...") but we need to preserve substantive info; however instructions are considered boilerplate? The instruction says remove application instructions. So we should omit that line. Also remove salary? Salary is substantive, we need to include Pay section if posting states it. Yes salary given: $123,208 - $138,997 (Internal candidates...). So we need a Pay section with that info. Also schedule? Not mentioned. Benefits? Not mentioned. So we omit Benefits and Schedule sections. We need sections: About the role (maybe Position Summary), Responsibilities, Requirements (Qualifications), Skills (Preferred?), Benefits (none), Pay, Schedule (none). Also maybe "Key Relationships" could be part of Responsibilities? But we can include as part of Responsibilities or separate? The instruction: use h3 for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It suggests we can use those headings; we can also add others? Probably stick to those. We have Position Summary -> About the role. Responsibilities -> Responsibilities. Qualification Requirements -> Requirements (or Qualifications). Preferred -> Skills. Salary -> Pay. Also maybe "Key Relationships" could be part of About the role or Responsibilities; but we need to preserve all substantive info. Could include under About the role or Responsibilities. Since we must not invent sections, we can add a subsection under Responsibilities as a paragraph. Or we could add a separate heading like "Key Relationships" but not in list; but instruction says use h3 for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It doesn't forbid other headings, but says use those for section headings. Safer to stick to those. So we can incorporate Key Relationships into About the role or Responsibilities. We need to preserve all substantive info: that includes details about responsibilities bullet points, qualifications details, preferred skills, salary note, etc. We must not include boilerplate: EEO, accommodation, public service loan forgiveness, etc. Also remove "NOTE: The filling of all positions is subject to budget availability..." etc. Also remove "Please include a resume and cover letter...". Also remove "New York City Residency is NOT Required * We encourage all applicants..." etc. Also remove the accommodation request paragraph, the loan forgiveness paragraph, the EEO statement, etc. We must keep the salary note about internal candidates not earning less than current salary. We must keep the qualification requirements text exactly? We can preserve but maybe format as

or

• . The qualification requirements are a block of text with multiple options. We'll keep as

  preserving the content. Preferred skills: list of bullet points; we can make

  • . Responsibilities: there are headings like "Data Procurement & ETL Pipelines", "Compliance & Legal Reporting", etc. We can treat each as a subsection maybe using

    ? But instruction only mentions h3 for section headings. Could use

    with bold? But we need to preserve structure. Could use

    • for each duty. The responsibilities block includes paragraphs with colon headings. We could turn each heading into a inside
    • . Simpler: make a
      where each
      • contains the heading bolded then the description. We must not invent or summarize away detail. So we need to keep all details. Let's extract responsibilities sections: - Data Procurement & ETL Pipelines - Engage with business stakeholders to gather and document requirements. - Create conceptual, logical and physical data models, data dictionaries and capture data lineage - Design, implement, test, deploy, debug, and document large scale Microsoft based on premise and cloud data warehouses and data marts. Own the end to end design, extraction, transformation, and loading (ETL) process, testing and deployment for complex large scale datasets ensuring accuracy and security. - Ensure seamless integration of disperse enterprise NYCPSE systems, including school age and pre-school special education applications (SESIS, ATLAS, Encounter Attendance, Provider Assignment), enrollment, attendance, course scheduling, teacher certification, ensuring seamless integration of special education, enrollment, and personnel metrics. - Compliance & Legal Reporting - Design and create complex data models and queries from scratch. - Improve the performance and speed of existing data structures and queries. - Construct reliable data pipelines and reporting frameworks. - Keep data systems updated, accurate, and functional over time. - Run data jobs and deliver reports for federal, state, and city regulations, FOIL requests, audits, and legal stipulations. - Specialized Automation - Architect automation engines, designing scalable Python and T-SQL systems from the ground up to generate and distribute reports. - Maintain automation engines, ensuring ongoing performance and reliability for critical data workflows. - Distribute data insights, delivering information efficiently to key decision makers. - Drive algorithmic assignment, programmatically managing the placement of preschool students with disabilities for reevaluation. - Enterprise BI and Analytics Delivery - Design and deploy robust and reliable systems for data analysis. - Design, build and deploy fast, high-performance PowerBI dashboards. - Tailor all tools and reports for different internal and external groups. - Cloud Modernization - Lead technical readiness for moving legacy on-premise data systems. - Plan data migration from local SQL Server data marts to the cloud. - Implement modern cloud environments using Microsoft Fabric. - Define future state data schemas to support new cloud setups. - Strategic Planning and Project management - Assist in defining roadmaps, align data systems with business goals, and data governance standards. - Test and choose new tools, software, and AI features to keep the data stack modern and efficient. - Coordinate and direct data management activities. - Assist in performing project planning, feasibility studies, cost benefit analyses, impact analyses, and task prioritization. Also there is a line: "Performs related work." and "Reports to: Senior Director of MIS/Analytics, SEO Direct Reports: There are no immediate direct reports assigned to this position. However, the candidate must be capable of adapting to future needs, including supervising developers, directing project teams, or overseeing external consultants. Key Relationships: The candidate will work closely with other offices within the division, several external constituencies, and partner with other New York City Public Schools (NYCPS) divisions/offices, including the Division of Instructional and Information Technology (DIIT), the Office of the General Counsel (OGC), Research and Policy Support Group (RPSG), and the Office of Student Enrollment (OSE)." We need to preserve that info. Could include under About the role or Responsibilities as a paragraph. Now Qualification Requirements block: It's long. We'll keep as

        preserving the text. Preferred: list: - High proficiency in T-SQL and relational database management systems (Microsoft SQL Server on-premises). - Strong programming experience in Python for data manipulation, scripting, and automated PDF reporting pipelines. - Demonstrated hands on experience on both sides of the pipeline: data procurement/ingestion and reporting delivery. - Ability to troubleshoot, problem solve and anticipate issues needing resolution. - Strong analytical skills combined with the ability to develop thoughtful and creative approaches for addressing a wide range of analytic questions. - Excellent written and spoken communication skills and interpersonal skills. Salary: $123,208 - $138,997 (Internal candidates who are selected for this position and who currently hold comparable or less senior positions within the DOE will not earn less than their current salary.) We need to output only HTML fragment, no markdown fences. Let's craft:

        About the role

        Position Summary: The Reporting and Analytics team within the Special Education Office (SEO) of the Division of Inclusive and Accessible Learning (DIAL) is seeking a highly skilled, multi-talented, experienced individual to manage end to end data integration, warehousing, and reporting workflows in tracking referrals, evaluations, Individualized Education Programs (IEPs, IESPs), mandated student services, and complex compliance metrics for all preschool and school age students referred for special education services in public, charter, and private school settings. Under general supervision, with broad scope for the exercise of independent initiative and judgement, the selected candidate is responsible for the analysis, design, development, implementation, enhancement, maintenance, security and data governance of data warehouses, data marts, business intelligence systems and operational, management, regulatory reporting systems. Performs related work. Reports to: Senior Director of MIS/Analytics, SEO. Direct Reports: There are no immediate direct reports assigned to this position. However, the candidate must be capable of adapting to future needs, including supervising developers, directing project teams, or overseeing external consultants. Key Relationships: The candidate will work closely with other offices within the division, several external constituencies, and partner with other New York City Public Schools (NYCPS) divisions/offices, including the Division of Instructional and Information Technology (DIIT), the Office of the General Counsel (OGC), Research and Policy Support Group (RPSG), and the Office of Student Enrollment (OSE).

        Then Responsibilities as

        Responsibilities

        with
        • each. We need to include the subheadings inside li maybe as . Let's construct. Then Requirements

          Requirements

          with

          containing the qualification requirements text. Then Skills

          Skills

          with
          • for preferred. Then Pay

            Pay

            with

            containing salary note. We must not include Benefits or Schedule. Check that we didn't include any boilerplate: we omitted EEO, accommodation, loan forgiveness, note about budget, resume cover letter, NYC residency, etc. Now ensure we preserved all substantive info: Did we miss anything? The "Position Summary" we included. The "Reports to:" etc included. The "Direct Reports:" included. The "Key Relationships:" included. The responsibilities sections we covered all bullet points. Did we miss the line "Performs related work." we included in About the role paragraph. Good. Qualification Requirements: we need to include the entire block exactly as given. Let's copy it: "Minimum A baccalaureate degree from an accredited college, including or supplemented by 24 semester credits in computer science or a related computer field and two (2) years of satisfactory full-time computer software experience in computer systems development and analysis, applications programming, database administration, systems programming, data communications, including one (1) year in a project leader capacity or as a major contributor on a complex project; or A four-year high school diploma or its educational equivalent and six (6) years of satisfactory full-time computer software experience as described in "1" above, including one (1) year in a project leader capacity or as a major contributor on a complex project; orEducation and/or experience equivalent to "1" or "2" above. College education may be substituted for up to two (2) years of the required experience in "2" above on the basis that 60 semester credits from an accredited college is equated to one (1) year of experience. A masters degree in computer science or a related computer field may be substituted for one (1) year of the required experience in "1" or "2" above. However, all candidates must have at least a four-year high school diploma or its educational equivalent and at least one (1) year of satisfactory full-time experience in a project leader capacity or as a major contributor on a complex project." Note there is a missing space between "orEducation". We'll keep as is. Then after that: "Plus Familiarity with Microsoft Fabric, Azure Data Factory, or cloud data ware