WHO WE ARE:
We are a leading specialty retailer of casual apparel, footwear and accessories for young men, young women, boys and girls with an extensive assortment of iconic global, emerging, and proprietary brands rooted in an active and social lifestyle. We are based out of sunny Southern California at the Tilly's RSC. You'll hear the term RSC a lot, it stands for Retail Support Center since our corporate offices are here to support our retail and online stores.
Working at Tillys allows you to experience a new style of work life. Our work culture is fun and relaxed. We encourage you to be you and that means you should be comfortable. Our employees enjoy a casual dress code and a fun, fast-paced work environment where creative minds work together to achieve common goals. As a part of the team, you'll contribute towards and share in our success. A career at Tillys is all about working together to make things happen so what are you waiting for?
SUMMARY:
The following is a brief description of the responsibilities to be performed by the Database Developer.
Job responsibilities include, but are not limited to the following:
ESSENTIAL DUTIES AND RESPONSIBILITIES:
• ETL Development: Design, develop, and maintain SSIS packages for data extraction, transformation, and loading from various sources to target databases.
• SQL Development: Develop and maintain T-SQL scripts, stored procedures, views, and functions to support ETL processes, data warehousing, and reporting needs.
• Reporting Development: Design, develop, and maintain SSRS reports to visualize data for business users, including parameterized reports, drill-down reports, and sub reports.
• Database Administration: Perform database monitoring, backups, and recoveries, ensuring data integrity and availability.
• Collaboration: Work with business stakeholders to understand reporting requirements and collaborate with data engineers to source and prepare data.
• Be part of on-call rotations.
QUALIFICATION REQUIREMENTS:
• Proficiency in T-SQL for database development, stored procedures, and data manipulation.
• Experience with SSIS for ETL process development, including data flow tasks, control flow tasks, and package management.
• Skills in SSRS for report design, development, and deployment, including report parameters, data regions, and data source configurations.
• Knowledge of data warehousing principles and concepts.
• Experience with database design, SQL Server Management Studio, and SQL Server Profiler.
• Strong analytical and problem-solving skills.
• Good communication and collaboration skills to work with business stakeholders.
• Perform database monitoring, backups, and recoveries, ensuring data integrity and availability.
• Warehouse management system knowledge is a plus.
• Experience with High Availability (clusters) and SSIS Scale Out a plus.
• Query IBM AS/400 DB2 database is a plus.
• C and MVC knowledge are a plus.
EDUCATION and/or EXPERIENCE:
• Minimum 8 years of experience in a Microsoft SQL server environment.
• Bachelor of Science Degree or equivalent technical experience required.
WORK ENVIRONMENT:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.
• Typical office environment with low level noise exposure.
WHY US?
• Bonus eligible
• 401k
• Comprehensive medical and dental benefits vision is fully paid by us.
• Employee Discount online and in-store
• Discount on numerous attractions, travel and events
• Employee Sample Sale
• Relaxed work environment wear what we sell in our stores
• 40 hours paid sick time granted on day 1.
• Fitness and wellness events virtually or at the office
"Tillys will consider applicants with criminal histories in a manner consistent with the requirements of the Los Angeles Municipal Code, Chapter XVIII, Article 9 (Los Angeles Fair Chance Initiative for Hiring (Ban the Box)."
WHO WE ARE:
We are a leading specialty retailer of casual apparel, footwear and accessories for young men, young women, boys and girls with an extensive assortment of iconic global, emerging, and proprietary brands rooted in an active and social lifestyle. We are based out of sunny Southern California at the Tilly's RSC. You'll hear the term RSC a lot, it stands for Retail Support Center since our corporate offices are here to support our retail and online stores.
Working at Tillys allows you to experience a new style of work life. Our work culture is fun and relaxed. We encourage you to be you and that means you should be comfortable. Our employees enjoy a casual dress code and a fun, fast-paced work environment where creative minds work together to achieve common goals. As a part of the team, you'll contribute towards and share in our success. A career at Tillys is all about working together to make things happen so what are you waiting for?
SUMMARY:
The following is a brief description of the responsibilities to be performed by the Database Developer.
Job responsibilities include, but are not limited to the following:
ESSENTIAL DUTIES AND RESPONSIBILITIES:
• ETL Development: Design, develop, and maintain SSIS packages for data extraction, transformation, and loading from various sources to target databases.
• SQL Development: Develop and maintain T-SQL scripts, stored procedures, views, and functions to support ETL processes, data warehousing, and reporting needs.
• Reporting Development: Design, develop, and maintain SSRS reports to visualize data for business users, including parameterized reports, drill-down reports, and sub reports.
• Database Administration: Perform database monitoring, backups, and recoveries, ensuring data integrity and availability.
• Collaboration: Work with business stakeholders to understand reporting requirements and collaborate with data engineers to source and prepare data.
• Be part of on-call rotations.
QUALIFICATION REQUIREMENTS:
• Proficiency in T-SQL for database development, stored procedures, and data manipulation.
• Experience with SSIS for ETL process development, including data flow tasks, control flow tasks, and package management.
• Skills in SSRS for report design, development, and deployment, including report parameters, data regions, and data source configurations.
• Knowledge of data warehousing principles and concepts.
• Experience with database design, SQL Server Management Studio, and SQL Server Profiler.
• Strong analytical and problem-solving skills.
• Good communication and collaboration skills to work with business stakeholders.
• Perform database monitoring, backups, and recoveries, ensuring data integrity and availability.
• Warehouse management system knowledge is a plus.
• Experience with High Availability (clusters) and SSIS Scale Out a plus.
• Query IBM AS/400 DB2 database is a plus.
• C and MVC knowledge are a plus.
EDUCATION and/or EXPERIENCE:
• Minimum 8 years of experience in a Microsoft SQL server environment.
• Bachelor of Science Degree or equivalent technical experience required.
WORK ENVIRONMENT:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.
• Typical office environment with low level noise exposure.
WHY US?
• Bonus eligible
• 401k
• Comprehensive medical and dental benefits vision is fully paid by us.
• Employee Discount online and in-store
• Discount on numerous attractions, travel and events
• Employee Sample Sale
• Relaxed work environment wear what we sell in our stores
• 40 hours paid sick time granted on day 1.
• Fitness and wellness events virtually or at the office
Why Tillys?
Working at Tillys allows you to experience a new style of work life. Our work culture is fun and relaxed. We encourage you to be you and that means you should be comfortable. Our employees enjoy a casual dress code and a fun, fast paced work environment where creative minds work together to achieve common goals. As a part of the team, you'll contribute towards and share in our success. A career at Tillys is all about working together to make things happen so what are you waiting for?
401k: We offer a 401k plan as your financial security is our priority.
Comprehensive Health Benefits: We've got your well-being covered. Enjoy comprehensive medical and dental benefits, and the best part? We fully cover your vision needs.
Employee Discounts: Shop to your heart's content with exclusive discounts, both online and in-store. Enjoy the latest fashion and gear without breaking the bank.
Discounts Galore: Have fun without breaking the bank. Our discount programs offer discounts on various attractions, travel . click apply for full job details
Date Posted: 23 April 2025
Apply for this Job