At over 50 years old and counting, B&H has built a reputation as the trusted resource for photography and videography enthusiasts via its NYC SuperStore and its award-winning website. Long known as "The Professional’s Source", B&H is recognized by savvy consumers worldwide for its honest, knowledgeable guidance, expert tips and articles… and always-great prices. B&H offers competitive salaries, medical benefits, a 401K plan, employee discounts and opportunities to grow within a high-energy, low-attitude environment. Make your move to B&H today! Business Intelligence (BI) Developer (Level 3) will be responsible for enhancing our reporting architecture, participating in UX design, dashboard/application creation and administration. Their responsibilities include but are not limited to translating business requirements to technical specifications, and making sure best practices are followed. They will determine suitable visualization techniques, verify data integrity and report accuracy. S/he will assist Junior developers with report performance optimization techniques. Essential Responsibilities: · MicroStrategy BI Project development lifecycle. o Data modeling: designing the semantic layer, schema layer, dimension modeling o End-to-end implementation of Business Intelligence (BI) projects (reports, cubes, interactive dashboards, documents) o Writing complex queries to extract data from multiple systems to satisfy reporting need o Trouble-shooting and tuning SQL queries o Participate in business user discussions for requirements gathering and architecting solutions for BI projects. o Train and mentor team members and business users. Additional Responsibilities: As assigned by the manager Specific Knowledge, Skills and Abilities: · Experience with BI data model architecture (tables, attributes, facts, hierarchies, etc.) · Experience with at least one BI tool · Experience with writing complex queries · Solid understanding of database schema design · Proficient in designing and developing reporting solutions · Experience with Data mining; advanced analytics and predictive analysis is a plus · Experience with advanced MicroStrategy features (distribution services, transaction services, mobile, etc.) is a plus. Preferred Education, Experience and Licenses: · Minimum of 5 to 7 years as a BI Developer · Bachelor Degree or Equivalent a plus · Good analytical, inter-personal & communication skills, and proactive attitude · Ability to use strong industry knowledge to relate to customer needs · High level of focus and attention to detail · Strong work ethic with good time management, and the ability with diverse teams and lead meetings. Physical Environment/Occupational Risks Onsite Monday - Thursday We are an Equal Opportunity Employer. All persons shall have the opportunity to be considered for employment without regard to their race, color, religion, national origin, ancestry, alienage or citizenship status, age, disability or handicap, sex or gender, marital status, veteran status, sexual orientation, arrest record, or any other characteristic protected by applicable federal, state or local laws. We will endeavor to make a reasonable accommodation to the known physical or mental limitations of a qualified applicant with a disability unless the accommodation would impose an undue hardship on the operation of our business. If you believe you require such assistance to complete this form or to participate in an interview, please let us know. Job Details Job Family Information Systems Pay Type Salary Hiring Min Rate 110,000 USD Hiring Max Rate 130,000 USD