Database Architect/Developer - Data Warehouse
Jasint•Monterey, CA
•$120,000 - $138,000
About The Position
The person in this position is responsible for performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system. Responsibilities include supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support. The duties will include planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications.
Requirements
- Experience: 5+ years of experience designing and developing data warehouses.
- Proven track record of successfully implementing complex data warehouse projects
- Experience with relational database design/modeling using tools.
- Expert-level SQL coding/querying skills in SQL Server and/or MySQL
- Proficient in SQL and advanced SQL query optimization techniques
- Expertise in data warehouse technologies like Snowflake, Redshift, or Teradata
- Knowledge of ETL tools and methodologies
- Familiarity with data modeling concepts (dimensional, star schema, snowflake schema)
- Programming skills (Python, Java) may be beneficial depending on the environment
- Education : BS from an accredited college or university with a minimum of 5+ years experience or substitute with AS with 7+ years experience
- Require anyone of the following IAT Level II (CySA+, Security+, CND, or SSCP) Certification and CE/OS Certification.
Nice To Haves
- Programming skills (Python, Java) may be beneficial depending on the environment
Responsibilities
- performing analysis
- modification
- documentation
- support of daily operations for the data warehousing and reporting system
- supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support
- planning
- installation
- maintenance during or after-work hours
- troubleshooting
- managing all Database Developer servers and applications
Benefits
- Retirement/401k with an employer match
- employer-paid health, dental, vision for employees
- flexible spending accounts (HSA/FSA)
- company partially funded HSA
- STD/LTD
- professional development
- tuition and certification reimbursement
- spot award recognition
- PTO
- Floating Holidays
- internal and external referral bonuses
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
11-50 employees
