Data Engineer

Job Title: Data Engineer Location: Irvine, CA (On-site) Department: Information Technology Reports To: Lead Software Architect Schedule: Full-Time | Minimum 4 Days In-Office FLSA Status: Exempt Who We Are At Tillys , we’re a leading specialty retailer offering casual apparel, footwear, and accessories for young men, women, boys, and girls. Our extensive collection features iconic global brands, emerging labels, and proprietary lines, all rooted in an active and social lifestyle. Based in sunny Southern California, our Retail Support Center (RSC) is the heart of our corporate operations, dedicated to supporting both our retail and online stores. The RSC is where strategy meets execution. From trend forecasting to tech innovation, our teams work together to bring the Tillys experience to life — both in-store and online. Position Summary We are seeking a Data Engineer to join our Information Technology team. Reporting to the Lead Software Architect, the Data Engineer will be responsible for designing, developing, and maintaining reliable and scalable data solutions that support business applications, reporting, analytics, and operational needs across the organization. This position will work closely with the Lead Software Architect, software developers, business stakeholders, and other technical teams to develop data pipelines, integrations, and data structures that enable accurate and efficient movement of data across systems. The Data Engineer will also help improve data quality, performance, reliability, and accessibility while supporting the organization’s evolving data and technology architecture. Key Responsibilities Design, develop, test, deploy, and maintain scalable data pipelines and data integration solutions. Build and maintain ETL/ELT processes to collect, transform, and integrate data from multiple internal and external sources. Partner with the Lead Software Architect to ensure data solutions align with established architecture, development standards, and the organization’s overall technology strategy. Collaborate with software developers, analysts, project managers, and business stakeholders to understand data requirements and translate business needs into effective technical solutions. Design and maintain data models and structures that support operational applications, reporting, analytics, and business intelligence. Develop and maintain integrations between enterprise applications, databases, APIs, third‑party platforms, and other data sources. Monitor data pipelines and integrations to identify and resolve performance, reliability, and data quality issues. Troubleshoot complex data and integration issues and implement sustainable solutions. Develop automated processes for data validation, reconciliation, monitoring, and error handling. Ensure the accuracy, consistency, completeness, and integrity of data throughout data pipelines and integrations. Optimize database queries, data transformations, and pipeline performance to improve scalability and efficiency. Assist with the modernization of existing data processes, integrations, and platforms. Participate in the design and implementation of cloud‑based and modern data architecture solutions. Support software development teams with database design, data access patterns, integrations, and application data requirements. Develop and maintain technical documentation, including data flows, data mappings, integration specifications, and system architecture documentation. Follow software development lifecycle (SDLC), source control, testing, deployment, and CI/CD best practices. Implement appropriate security and access controls to protect confidential and sensitive business data. Research and evaluate emerging data technologies, tools, and development practices and make recommendations to the Lead Software Architect. Develop proofs‑of‑concept and prototypes when evaluating new technologies or approaches. Identify opportunities to improve data processing, automation, scalability, reliability, and reusability across the technology environment. Participate in code reviews, technical design reviews, sprint planning, and other Agile development activities. Provide technical support and guidance related to data integrations, databases, and data engineering solutions. Maintain awareness of emerging technologies and industry best practices related to data engineering, cloud platforms, data architecture, and application integration. Qualifications Strong understanding of data engineering concepts, relational databases, data modeling, and data integration principles. Proficiency with SQL and experience developing complex queries, stored procedures, and database solutions. Cross database knowledge covering Microsoft SQL Server, Oracle, DB2, PostgreSQL Experience developing and maintaining ETL/ELT pipelines and data integration workflows. Understanding of cloud technologies and modern data architecture and experience working with relational and/or cloud‑based databases and data platforms, including but not limited to Oracle Cloud. Experience with other cloud technologies like Snowflake, AWS, GCP, Redshift is a plus. Experience working with Business Intelligence platforms like Tableau, Strategy (MicroStrategy), PowerBI Understanding of APIs, web services, and system integration concepts. Knowledge of data modeling techniques and database design principles. Experience with at least one programming or scripting language commonly used for data engineering, such as Python, Java, C#, SSIS, or similar. Knowledge of data quality, governance, security, and privacy best‑practices, including but not limited to handling customer and employee PII. Familiarity with Git source control, CI/CD, automated testing, and modern software development practices. Strong analytical, troubleshooting, and problem‑solving skills. Ability to analyze business requirements and translate them into effective technical solutions. Excellent verbal and written communication skills with the ability to communicate technical concepts to both technical and non‑technical audiences. Strong organizational skills and attention to detail. Ability to manage multiple priorities and work effectively in a fast‑paced environment. Ability to work independently while collaborating effectively across technical and business teams. Education & Experience Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, Software Engineering, Data Science, or a related technical field required. At least 3–5 years of related experience in data engineering, software development, database development, data integration, or a related technical discipline. Experience developing and maintaining production data pipelines and system integrations preferred. Experience with cloud‑based data platforms and technologies preferred. Experience supporting enterprise applications and complex system environments preferred. Retail, eCommerce, merchandising, inventory, supply chain, or other high‑volume transactional data experience is a plus. Work Environment & Physical Demands Professional office setting with low to moderate noise Ability to sit or stand for extended periods Occasionally lift/move up to 20 lbs and navigate stairs Frequent walking and movement between floors/departments Reasonable accommodation is available to support individuals with disabilities Leadership & Team Development While this is not a leadership role, we value team players who embody proactive collaboration, curiosity, accountability, and a growth mindset. Opportunities to grow and develop within the company are strongly supported. Compensation Annual Range: $100k - $120k/yr Final offer will be based on experience, skills, and qualifications. What To Expect Schedule: Full-time role with weekday office hours; occasional evening or weekend work may be required during peak retail seasons. Work Location: Irvine, CA — minimum of 4 days per week in‑office. Why Join Tillys? At Tillys, we thrive in a creative, collaborative, and high‑energy environment where individuality is not just accepted — it’s celebrated. Whether you're brainstorming bold new campaigns or fine‑tuning behind‐the‑scenes processes, your work makes a real impact. We foster a culture of inclusion, innovation, and recognition, where professional growth is supported, wins are celebrated, and having fun is part of the process. Join a team that values authenticity, teamwork, and always strives for excellence. Perks & Benefits 401(k) Retirement Plan – Save for your future with our company-sponsored plan Health Coverage – Medical, dental, vision, life, and additional voluntary benefits Employee Discount – In‑store and online Discount Programs – Save on travel, events, and more Employee Sample Sales – Major deals on favorite brands Wellness & Social Events – Fitness programs, parties, and team outings Weekly Office Snacks – Stay fueled with stocked treats Equal Opportunity Employer & Fair Chance Hiring Tillys is proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Fair Chance Hiring: In compliance with California law, Tillys will consider qualified applicants with criminal histories in a manner consistent with the California Fair Chance Act. Other Considerations This job description is not intended to be all-inclusive. Duties and responsibilities may change at any time, with or without notice. Reasonable accommodation may be provided to individuals with disabilities to enable them to perform essential job functions. #J-18808-Ljbffr