Lead Data Warehouse Technical Analyst
Core
Lead the design, development, modernization, and support of enterprise data warehousing solutions and cloud-based data platforms for Finance, Enterprise Reporting, and Business Intelligence initiatives.
Role type
Senior IC data engineering lead (data warehouse)
Builds
Scalable ETL/ELT pipelines, data integrations, transformation frameworks, and cloud-native data solutions on Snowflake and AWS.
Domain
Financial Services / Data Engineering / Cloud Data Platforms
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Enterprise data warehousing, Snowflake, AWS data engineering, SQL development and optimization, ETL/ELT pipeline design, data modeling, technical leadership, mentorship
Preferred skills
Financial services domain knowledge, PostgreSQL/Oracle/SQL Server, Informatica PowerCenter, Apache Airflow, Terraform, CI/CD pipelines, AWS/Snowflake certifications, cloud migration experience
Technologies
Snowflake, AWS (S3, Glue, Lambda, MWAA, Redshift), DBT, Python, SQL, Informatica PowerCenter, Apache Airflow, Terraform, GitHub
Responsibilities
Lead technical design and implementation of cloud data solutions; Build and maintain scalable ETL/ELT pipelines; Develop and optimize complex SQL queries and data models; Partner with stakeholders to translate requirements into data solutions; Establish best practices for data quality, governance, and security; Mentor data engineers and technical analysts; Oversee solution deployment and production support.
Seniority
Senior, hands-on IC with leadership responsibilities
