**Experienced Full Stack Information Designer – Web & Cloud Application Development**

**Join arenaflex, one of the world's best companies to work for, and take your career to the next level!** At arenaflex, we're committed to providing a family-oriented work environment where our employees thrive and succeed. As a testament to our dedication, arenaflex ranks seventh in Forbes' "World's Best Companies" list. We're a global retailer with discount stores in 14 countries, and we're looking for talented individuals to join our team. **About the Role:** We're seeking an experienced Full Stack Information Designer to join our Web & Cloud Application Development team. As a key member of our team, you'll be responsible for designing and implementing end-to-end data pipelines to drive analysis and data services. Your primary focus will be on data engineering to build and deliver automated data pipelines from various internal and external data sources. You'll work closely with product owners, BI architects, and data stage teams to design, build, test, and automate data pipelines that are relied upon across the organization as the single source of truth. **Key Responsibilities:** * Design, develop, implement, and operationalize ETL/ELT processes using IICS (Informatica Cloud) * Collaborate with Information Designers and data/BI architects to design data pipelines and suggest continuous improvement of data storage, data ingestion, data quality, and organization * Develop and maintain optimal data pipeline architecture * Identify, design, and execute internal cycle improvements: automating manual processes, improving data delivery * Execute large data and NoSQL solutions by creating flexible data handling stages to drive high-value insights to the organization * Support the development of Information Dictionaries and Information Scientific categorization for product solutions * Demonstrate a strong understanding of coding and programming concepts to build data pipelines (e.g., data transformation, data quality, data integration, etc.) * Assemble data models with Information Designers and create data pipelines to store data in defined data models and structures * Show a strong understanding of data integration strategies and tools (e.g., Extract, Transform, Load (ETL)/Extract, Load, Transform (ELT)) tools and database design * Show a strong understanding of database storage concepts (data lake, social databases, NoSQL, Chart, data warehousing) * Identify ways to improve data reliability, efficiency, and quality of data management * Direct impromptu data recovery for business reports and dashboards * Evaluate the integrity of data from various sources * Oversee database arrangement including installing and upgrading software and maintaining essential documentation * Monitor database activity and resource usage * Perform peer review for another Information Designer's work * Design, develop, implement, and operationalize ETL/ELT processes using IICS (Informatica Cloud) * Collaborate with data planners and data/BI specialists to design data pipelines and suggest continuous streamlining of data storage, data ingestion, data quality, and organization * Utilize Azure services like Azure SQL DW (Neural connection), ADLS, Azure Event Hub, Azure Data Factory to improve and accelerate delivery of our data products and services **Requirements:** * 2+ years' experience designing and operationalizing data pipelines with large and complex datasets * 2+ years' hands-on experience with Informatica IICS or PowerCenter * 2+ years' experience in Data Visualization, ETL, and Data Warehousing * 2+ years' experience working with Cloud technologies like ADLS, Azure Databricks, Azure Data Factory, Azure Neural connection, Universe DB, and other big data technologies * Experience with advanced e-commerce and clickstream data * Broad experience working with various data sources (SQL, Prophet database, flat files (csv, delimited), Web API, XML) * High-level SQL skills. Strong understanding of social databases and business intelligence; ability to write complex SQL queries against multiple data sources * Strong understanding of database storage concepts (data lake, social databases, NoSQL, Chart, data warehousing) * Ability to work in a fast-paced agile development environment * Flexibility to address business needs including weekends, holidays, and on-call responsibilities on a rotational basis **Preferred Qualifications:** * BA/BS in Computer Science, Engineering, or comparable programming/services experience * Azure Certifications * Experience implementing data integration methods like event/message-based integration (Kafka, Azure Event Hub), ETL * Experience with Git/Azure DevOps * Experience delivering data solutions through agile software development approaches * Openness to the retail industry * Excellent verbal and written communication skills * Experience with UC4 Job Scheduler * Experience with Power BI **Benefits:** * Medical Benefits: arenaflex offers comprehensive medical benefits to qualified employees, including clinical, dental, and vision coverage. These benefits may extend to the employee's dependents as well. * 401(k) Retirement Savings Plan: arenaflex provides a 401(k) retirement savings plan to help employees save for their future. The organization may offer a matching contribution to qualified employees' retirement savings. * Employee Stock Purchase Plan (ESPP): arenaflex offers an Employee Stock Purchase Plan (ESPP) that allows qualified employees to purchase company stock at a discounted price, commonly through payroll deductions. * Life Insurance and Disability Inclusion: arenaflex provides life insurance coverage and disability protection to qualified employees, offering financial security in case of death or disability. * Paid Time Off (PTO): arenaflex offers paid time benefits, including vacation days, holidays, and sick leave, to qualified employees. The amount of PTO may vary based on residency and position within the organization. * Tuition Repayment: arenaflex offers tuition repayment benefits to qualified employees who wish to further their education or pursue work-related courses or degrees. The organization may repay a portion of tuition costs upon successful completion of approved courses. * Employee Discounts: arenaflex employees are eligible for discounts on products and services offered by the organization. This includes discounts on arenaflex warehouse items as well as discounts on arenaflex travel services, optical services, and other benefits. * Employee Assistance Program (EAP): arenaflex provides an Employee Assistance Program (EAP) to help employees and their families with various personal and business-related challenges. This may include counseling services, legal assistance, financial advising, and other support services. * Career Advancement Opportunities: arenaflex offers opportunities for career advancement and progression to its employees. This may include training programs, mentorship opportunities, and internal advancement opportunities for qualified employees. * Balance between fun and serious activities Drives: arenaflex recognizes the importance of balance between work and personal life and may offer flexible scheduling options, remote work opportunities, and other benefits to help employees achieve a better work-life balance. **Join arenaflex today and take your career to new heights!** Apply for this job