Data Engineer - AKIRA/shopAKIRA.com : Job Details

AKIRA Data Engineer

In 2002, AKIRA opened the doors to its first women's clothing boutique in Chicago. Since then, the company has extended its reach to 35+ stores across the United States, as well as a thriving eCommerce business (shopAKIRA.com.) AKIRA is extremely well-poised for sustained growth as we continue to build a nationally recognized brand. AKIRA's culture has one very large, distinct difference from other high fashion competitors: Fanatical, Obsessive Attention to the consumer's needs and desires. The core principle for all employees at AKIRA is to Act and Think Like an Owner, and this belief can be reflected across all areas of the company.

The Position

Data Engineer and BI Specialist

Location

Chicago, IL (On-site)

Overview:

The Data Engineer and BI Specialist will be responsible for designing, developing, and maintaining data pipelines, managing our BI platforms, and ensuring the availability of accurate and actionable data insights. This role requires a hands-on expert who can work independently to handle the entire data lifecycle.

Essential Functions:

• Build and maintain ETL pipelines to ensure seamless integration of diverse data sources (ERP, CRM, e-commerce platforms)
• Optimize data storage, retrieval, and processing to support BI initiatives.
• Develop and manage DOMO/Power BI dashboards and reports to provide insights to stakeholders
• Partner with business leaders to identify reporting needs and define KPIs
• Implement data governance and quality best practices
• Write, optimize, and maintain complex SQL queries for data extraction and manipulation
• Implement and manage indexing strategies to enhance database performance
• Train business users on DOMO self-service capabilities
• Act as a bridge between technical teams and business stakeholders to ensure alignment of deliverables
• Utilize Python for data processing, automation, and advanced analytics tasks
• Maintain automation jobs on Linux VM machines
• Ensure data quality, consistency, and security across all data platforms
• Monitor and troubleshoot data systems to ensure high availability and performance
• Stay current with industry trends and best practices in data engineering and analytics

Qualifications:

• Bachelor's degree in Data Engineering or Data Science
• 3+ years of experience in data engineering, business intelligence, and analytics
• 3+ years of experience in DOMO, Azure Data Factory, Power BI (our legacy reports), and SQL
• Strong expertise in ETL processes and tools, including data transformation in DOMO
• Strong experience with Python for data processing and automation
• In-depth knowledge of database management, indexing strategies, and query optimization
• Experience with cloud platforms (preferably Azure) and big data technologies
• Proficient in working with Linux systems, including using command-line tools and performing system administration tasks

The Ideal Candidate Has/Is:

• DOMO certification(s) (e.g., DOMO Professional, DOMO Specialist) highly desirable
• Experience with enterprise systems such as NetSuite and Shopify preferred
• Microsoft Certified: Azure Data Engineer Associate
• Microsoft Certified: Data Analyst Associate
• Certified Business Intelligence Professional (CBIP)
• Exceptional work ethic and motivation to meet strict deadlines
• Excellent written and verbal communicator
• Outstanding organizational skills, with keen attention to detail and diligent task follow-through

Diversity & Inclusion:

At AKIRA we believe that treating everyone in a first-class manner is essential to fostering an inclusive environment that reflects our values and our community. This is deeply rooted in our company's principles, culture, and fashion. We continuously strive to cultivate a company where employees feel a sense of belonging and contribute to a culture that values differences, ideas, and experiences. Our unique workforce is directly linked to our success and makes us stronger collectively.

Benefits and Perks:

AKIRA offers competitive benefits for full time employees, including Medical, Dental, Vision, Pet, Life, LTD, FSA/HSA/Dependent Care FSA, Flex Transit (CTA), 401(k), and employee discount. We are committed to encouraging internal development and providing significant career enrichment opportunities. Most importantly, what has propelled AKIRA's growth and success over the years has been the dynamic culture within the company - if you're filled with passion, have a strong desire to get things done, and if you want to go to a place where you know your work matters and where you can implement your ideas and decisions, then AKIRA just might be the place for you.

Job Type: Full Time