What are the responsibilities and job description for the Lead Data Warehouse Developer position at GlobeX Workforce Solutions?
๐๐ฒ๐ฎ๐ฑ ๐๐ฎ๐๐ฎ ๐ช๐ฎ๐ฟ๐ฒ๐ต๐ผ๐๐๐ฒ ๐๐ฒ๐๐ฒ๐น๐ผ๐ฝ๐ฒ๐ฟ
Location: Albany, NY (Hybrid)
๐๐ฏ๐ผ๐๐ ๐๐ต๐ฒ ๐ฅ๐ผ๐น๐ฒ
We are seeking an experienced Lead Data Warehouse Developer to provide technical leadership and hands-on expertise across our enterprise data environment. The ideal candidate is highly skilled in Oracle SQL/PLSQL development, data modeling, and performance optimization, with a proven ability to troubleshoot complex technical issues and guide development teams.
๐๐ฒ๐ ๐ฅ๐ฒ๐๐ฝ๐ผ๐ป๐๐ถ๐ฏ๐ถ๐น๐ถ๐๐ถ๐ฒ๐
- Lead the design, development, and optimization of enterprise data warehouse solutions.
- Provide technical guidance and mentoring to software development and data engineering teams.
- Perform advanced SQL performance tuning to support high-volume, mission-critical systems.
- Develop and maintain complex Oracle SQL and PL/SQL code for ETL, data processing, and reporting.
- Troubleshoot and resolve complex technical issues across network, database, application, and server layers.
- Oversee and guide performance tuning efforts for large-scale data warehouse architectures.
- Collaborate with stakeholders to refine data models supporting reporting, analytics, and business intelligence.
- Ensure best practices, code quality, and high standards in data architecture and system performance.
๐ ๐ถ๐ป๐ถ๐บ๐๐บ ๐ค๐๐ฎ๐น๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป๐
- 5 years troubleshooting complex technical issues (network, database, application, servers).
- 3 years data modeling for reporting and analytics environments.
- 5 years SQL performance tuning experience.
- 3 years providing technical guidance to development teams.
- 3 years leading or guiding performance tuning of enterprise data warehouse systems.
- 5 years hands-on Oracle SQL & PL/SQL development.
๐ฃ๐ฟ๐ฒ๐ณ๐ฒ๐ฟ๐ฟ๐ฒ๐ฑ ๐ค๐๐ฎ๐น๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป๐
- Additional experience beyond the minimum in: complex technical troubleshooting, data modeling, performance tuning leadership
- Experience with enterprise data warehouse modernization or cloud migrations (optionalโadd if relevant).
- Strong communication and stakeholder management skills.