Job Description

Johnny Was, LLC

At Johnny Was, our mission is to inspire free-spirited optimism through beauty, authenticity, comfort and artistic expression. California Dreaming – the ultimate destination for those who love California and the relaxed modern bohemian lifestyle it embodies.

The Business Intelligence Developer plays a crucial role in translating complex data into actionable insights for our lifestyle apparel brands. This position is responsible for developing and maintaining robust BI solutions, ensuring the delivery of accurate and timely data for informed decision-making. They collaborate closely with the Product Owner to align their work with the overall data strategy, and actively participate in defining and refining user stories and tasks within JIRA. Their expertise in data modeling, visualization, and analytics is fundamental in supporting both operational and reporting needs, making them a key asset in driving the success of our data-driven initiatives.

• Skillfully integrate and model data from diverse sources into PowerBI, ensuring accurate and efficient data structures for reporting.
• Design and construct detailed reports and interactive dashboards in PowerBI and Excel, emphasizing usability and clarity.
• Utilize data transformation techniques to prepare datasets for optimal reporting and visualization.
• Actively collaborate with stakeholders to understand reporting needs, translating these into functional and visually appealing BI solutions.
• Continuously refine and enhance reports and dashboards, incorporating feedback and evolving business requirements.
• Implement rigorous data quality checks and validation processes to ensure the accuracy and reliability of reports and dashboards.
• Optimize the performance of reports and dashboards, ensuring fast load times and efficient data retrieval, even with large datasets.
• Develop custom visualizations in PowerBI to meet unique business requirements, ensuring that complex data is presented in an accessible and engaging manner.
• Work within an agile framework, prioritizing tasks and adapting quickly to changes in project scopes or business needs, with a focus on delivering value through BI tools.
• Support IT/Operations with IT issues and respond to questions as the need arises.
• Experienced professional who typically performs moderately complex to complex work
• Utilizes creative and/or technical skills, knowledge, etc. to complete the assigned work
• Receives a moderate level of guidance and direction from the manager
• Decisions are guided by policies, procedures, and the business plan
• Relies on experience and judgment to accomplish assigned tasks and goals.
• Business stakeholders
• Members of the Data & Analytics Department
• Oxford IT staff

Pay is based on multiple factors, such as qualifications/skills/experience, geography, and state and local wage laws. In addition, bonus and/or commission and benefits including healthcare, retirement savings, paid time off/vacation, and product discounts may be offered.

Range for the position is $79,600 - $132,600

All qualified applicants with criminal histories will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Change Act. This position requires customer interaction and access to funds, merchandise, and private information. The Company reserves the right to withdraw contingent offers of employment on the basis of criminal convictions that may have a direct, adverse, and negative bearing on the ability to perform these job duties.

POSITION SPECIFICATIONSEducation and Certifications, Experience and Skills, and CompetenciesEducation and Certifications

Bachelor’s degree or relevant work experience required.

Experience and Skills

• 4+ years’ experience in data management and data warehousing technologies related to data modeling, database design, ETL development, and BI reporting.
• Excellent SQL and data warehouse skills.
• Experience writing complex queries on large data sets.
• Experience with Business Intelligence Platforms: Power BI
• Understanding and experience with designing building data models that drive decisions
• Expertise with cloud database technologies like Snowflake
• Understanding of data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3rd normal form as well as dimensional modeling, such as star and snowflake)
• Advanced Excel skills

Competencies

• Advanced analytical and problem-solving skills
• Excellent SQL skills
• Experience which demonstrates an understanding of reporting tools and their technical requirements
• Ability to learn quickly
• Strong organizational skills
• Customer focus, service-oriented, and results driven
• Good understanding of IT policies and procedures
• Solid written and oral communication skills to effectively and comfortably communicate with end-users and stakeholders
• Comfortable working in a fast-paced environment

What happens next?
If you are interested in this opportunity, please apply! You will receive an email confirming we received your application. We will review your application as soon as possible. You can update your resume or information at any time by accessing your candidate profile.

This Company is an equal opportunity employer and does not discriminate against qualified applicants based on race, color, sex, gender, gender identity, gender expression, religious creed, sexual orientation, pregnancy, national origin, ancestry, age, military and veteran status, marital status, physical or mental disability, protected medical condition, genetic information, reproductive health decision-making, lawful off-duty use of marijuana, any other characteristic protected by law, or any combination of two or more of the characteristics listed here. If you need an accommodation to complete an online application, please contact the location you are applying to or contact us at 1-888-725-1899.

U.S. EEOC: Know Your Rights

Oxford Industries participates in E-Verify. Details in English and Spanish Right to Work Statement in English and Spanish

Please click here to review our Applicant Privacy Policy.