We are seeking a highly skilled and motivated Senior Developer II to join our Business Intelligence and Data Warehousing team. The ideal candidate will possess extensive hands-on experience with Snowflake, AWS Lambda, REST API development, and Node.js, and will have a strong background in financial or accounting data environments.
Requirements
- Design, develop, and optimize scalable data pipelines and ETL processes using Snowflake, AWS Lambda, and Node.js to support financial and accounting reporting needs.
- Build, enhance, and maintain RESTful APIs for seamless data integration and delivery across various financial systems.
- Monitor and troubleshoot existing business intelligence (BI) applications, frameworks, and reports to ensure data availability and reliability for end users.
- Collaborate with stakeholders to gather requirements, design solutions, and implement dashboards, reports, and solutions that address business needs.
- Analyze and cleanse large datasets to ensure data accuracy, quality, and reconciliation to the original sources; perform quality assurance testing prior to data/report release.
- Develop, maintain, and deliver comprehensive technical documentation related to data pipelines, ETL processes, scheduled jobs, dataset creation, and reporting solutions.
- Provide technical mentorship to junior developers and analysts, fostering a collaborative and innovative team environment.
- Identify and troubleshoot data anomalies, performance bottlenecks, and system issues in a timely manner.
Benefits
- Comprehensive benefits package including health, life, and disability insurance
- Unbounded paid time off including parental leave
- 401(k)