Sr. Database Analyst

Yamaha has an excellent opportunity for a Sr. Database Analyst to join our Finance team in Cypress, CA. The position requires a highly motivated and analytical Senior DB Analyst to join our team and play a key role in managing and extracting insights from our data infrastructure. You will be responsible for building and maintaining ETL processes, administering and monitoring automated systems, performing user administration tasks, and writing complex SQL queries to fulfill data requests. You will be a crucial part of our efforts to leverage data as a strategic asset and drive informed decision-making across the organization. This role requires a strong technical background, strategic vision, and leadership capabilities. What you'll be doing: Design and develop ETL processes to extract, transform, and load data from diverse sources including files, Oracle database tables, and APIs into AWS and Snowflake. Administer and monitor automated data loading/ETL scripts (SAS/Informatica Cloud ( IICS)) used for data analysis and reporting. Includes debugging/troubleshooting and validation/detail monitoring to make sure data is accurate and up to date. Write complex SQL queries to extract and analyze data from Snowflake for ad-hoc requests and reporting needs. Translate business requirements into relevant and actionable data insights. Design, maintain and secure the cloud environment on AWS using services such as EC2, VPC, Lambda Functions, IAM policies and roles and other services as needed. Utilize terraform and terragrunt to automate infrastructure provisioning and management on AWS, ensuring consistency and scalability. Manage and maintain version control for data engineering projects using GitHub, including repository setup, branch management, and pull request reviews. Work cohesively with all internal stakeholders to provide robust and accurate data in a timely manner to enable data driven analyst and insights. Stay up-to-date with the latest trends and technologies in data analytics, database management, and cloud platforms. Document data infrastructure and processes for maintainability and knowledge sharing. Participate in data governance initiatives and ensure compliance with data quality and security standards. Collaborate effectively with cross-functional teams to support data-driven decision-making throughout the organization. What you need to be successful: Bachelor's degree in Computer Science, Information Systems, or a related field. Minimum 5 years of experience as a Database Analyst or similar role. Proficiency in programming languages like c#, python, .net, javascript. Strong understanding of data warehouse concepts, data modeling, and ETL processes. Proficient in writing SQL queries (e.g., SnowSQL, Oracle SQL). Experience with cloud platforms like AWS (S3, EC2, RDS, Lambda) and Snowflake. Experience with Informatica cloud Data integration and mass ingestion. Experience with Github for version control. Experience in consumer lending and financial analysis is a plus. Ability to lead and take initiative for improving the existing processes. Advanced Microsoft Excel skill is required Excellent analytical skills with high attention to detail Ability to learn quickly and manage multiple priorities in a rapidly changing environment Experience with migrations from On prem databases to Cloud databases is a plus Don't meet every single requirement? Studies have shown that women and underrepresented minorities are less likely to apply to jobs unless they meet every single qualification. At Yamaha, we understand that talent comes in various forms, and as such we are dedicated to building a diverse, inclusive, and authentic workplace. If you're excited about this role but your experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles Pay Range: 85,400 to 150,310 What's in it for you: • 401(k) and Profit Sharing • Fertility Benefits • 37.5-hour workweek • Medical, Dental, Vision • Life and AD&D Insurance • Wellness Program • Short-Term Disability Coverage (for hourly roles) • Long-Term Disability • Student Debt Repayment Benefits • Ability to borrow Yamaha products Reports to: Group Manager Yamaha Motor Corporation, USA is proud to be an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identify, national origin, veteran or disability or any other status protected by federal, state, or local law. We celebrate diversity and are committed to creating an inclusive environment for all employees