Business Intelligence Developer
Los Angeles, CA - USA
Job Summary
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.
Position Overview:
- 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 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 $79600 - $132600
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.
Bachelors degree or relevant work experience required.
- 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-.
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.
Required Experience:
IC
About Company
The official Johnny Was website has the best selection of boho-chic clothing, from women's dresses to accessories made with quality materials — Shop now!