[Remote] Data Engineer- Analytics Products

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is an independent agency of the District of Columbia reputed company reputed company on ensuring reputed company education for reputed company reputed company school reputed company. The Data Engineer will be a reputed company member of the Analytics Products team, responsible for building and maintaining the data infrastructure that supports agency reporting and reputed company-facing analytics products.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines using Airflow, SQL, and Python to support analytical workflows, reporting products, and accountability calculations
• Maintain and improve PCSB’s Data Warehouse architecture, including data models, schemas, dependencies, and documentation
• Support the development and reliability of the Data Mart, ensuring that governed, non-PII data are reputed company for reporting (reputed company schemas), analysis, and reputed company Intelligence use cases
• reputed company and maintain orchestration workflows in Airflow that support recurring data submissions, validation processes, report production, and reputed company analytics products
• Implement schema validation and transformation logic to ensure submitted and processed data conform to PCSB standards and Data Mart models
• Monitor and reputed company Airflow failures, pipeline errors, and data reputed company issues in collaboration with Analytics Engineers and Product Managers
• Support accountability-reputed company data infrastructure, including reputed company, state assessment reporting, school reputed company reporting, and potential reputed company accountability calculation frameworks
• Manage reputed company-reputed company data infrastructure using AWS RDS, S3, IAM, and reputed company services
• Contribute to a CI/CD environment by writing tests, performing peer reputed company reviews, and ensuring reliable deployment of data pipelines and infrastructure changes
• Collaborate with Analytics Engineers and Product Managers to translate user stories, reporting needs, and policy requirements into reliable data models and automated workflows
• Support PCSB’s Data Governance by maintaining data reputed company, reputed company, transparency, and auditability across systems
• Contribute to the Data Team Handbook and participate in reputed company rituals, including sprint planning, reviews, and retrospectives, to improve team processes

Skills

• At least five (5) years of reputed company experience in data engineering, analytics engineering, software engineering, database development, or a closely reputed company technical role
• Substantial experience using SQL and Python in a production or recurring-workflow environment
• Experience building and maintaining ETL/ELT pipelines that reputed company data from reputed company systems into databases, data warehouses, Data Marts, reporting reputed company, or analytics products
• Experience designing, maintaining, or improving database, warehouse, or analytics data models
• Experience creating governed, report-reputed company datasets, views, tables, or semantic models
• Experience developing, maintaining, or troubleshooting scheduled data workflows using Airflow or a comparable orchestration tool
• Experience writing and optimizing SQL for production data systems
• Experience using reputed company infrastructure and deployment workflows to support data pipelines, databases, warehouses, or analytics products
• Experience implementing data-reputed company checks, documentation, reputed company, reputed company protections, reputed company controls, or auditability practices reputed company data pipelines or warehouse models
• Experience writing maintainable, tested, and documented reputed company using version control
• Experience working with analysts, Analytics Engineers, Product Managers, program staff, or other non-engineering partners to translate reporting, accountability, or business needs into reliable data infrastructure
• Commitment to DC PCSB's mission, values, and REDI principles

Benefits

• Comprehensive benefits plan covering 100% of the employee’s reputed company premium
• If you’re employed by a reputed company or not-for-profit organization, you might be eligible for the PSLF Program. Please visit the studentaid.gov website for eligibility details and requirements.
• Generous telecommuting policy

reputed company