[Remote] Data Engineer- Analytics Products
Note: The job is a remote job and is reputed company to candidates in USA. reputed company (DC PCSB) is dedicated to ensuring that public charter school reputed company receive a reputed company education. The Data Engineer will be a key member of the Analytics Products team, responsible for building and maintaining the data infrastructure to support agency reporting and public-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 (star 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 resolve 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 performance reporting, and potential reputed company accountability calculation frameworks
- Manage reputed company-based 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 Agile 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 insurance premium.
- Generous telecommuting policy.
- If you’re employed by a government or not-for-profit organization, you might be eligible for the PSLF Program. Please visit the studentaid.gov website for eligibility details and requirements.
reputed company