Business Intelligence Analyst

Business Intelligence AnalystWe are the country's fastest-growing destination for precious gemstone jewelry, unique luxury items and vintage-inspired timepieces. We have over 15 years of success in direct marketing and continue to experience incredible growth. Based in the Minneapolis area, they also have offices in Virginia, and are expanding into Italy and Hong Kong. Following a record breaking year, no other company better combines the history, mystery and romance of the past with modern craftsmanship and 21st century technology. Think vintage collectibles from brands like Cartier, Tiffany, Van Cleef, and Rolex, and then picture precious gems such as diamonds, rubies, and emeralds and…..you'll get the idea! We are treasure seekers. We are storytellers. We are our customer's inside connection to affording the extraordinary. We shop the world for the rare, the beautiful, and the innovative and secure them at a price that makes them amazingly affordable. As one of the nation's largest gem buyers, we purchase on average over 10 million carats of gemstones a year. Then, we introduce these remarkable finds through compelling stories found in nearly one billion pages of print advertising each year.Job SummaryA Business Intelligence Analyst, or Business Intelligence Specialist, is responsible for managing data retrieval and analysis within an organization. Their duties include organizing data points, communicating between upper management and the IT department and analyzing data to determine a corporation's needs. This position will report directly to the Director of IT.Essential Job Duties/ResponsibilitiesA Business Intelligence Analyst has a diverse scope of duties and responsibilities depending on the nature of the organization. The primary duty of the Business Intelligence Analyst is to transform data into insight that can help to improve the value of the business. Other duties and responsibilities of a Business Intelligence Analyst within a company include:Developing and managing business intelligence solutions for the organizationProviding reports through office applications to improve business processesCreating KPIs and reporting package for teams to provide insight into organization to make strategic decisions.Collaborating with team members for the purpose of collecting data and executing the company's missionAnalyzing business requirements and processes and recommending them to the management and executives for implementation.Creating and mainting documentation that includes the design, requirements and user manuals for the organizationIdentifying the development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability Work with a variety of data sources - extracting knowledge and actionable informationAnalyze and build data models for use in regular and/or automated reporting and analysisBe a passionate problem solver - breaking down problems and developing analytical insightsConvey results to a wide variety of internal and external stakeholdersEvaluate operations for inefficiencies and identify areas where you can create, automate, and develop toolsSupport the business with ad hoc reportingParticipate in all scheduled and non-scheduled maintenance windowsContinuously strive for a deeper understanding of our business driversOffer insight to all aspects of the organization – product, marketing, sales, ops etc.…Effectively communicating your insights and plans to cross-functional team members and management.Willingness and ability to train and teach others.Requirements5+ years' experience using Power BI creating reports and the underlying data structures7+ years supporting business operations in an analytics capacityProficiency with SQLGreat communication/presentation skillsNice to HaveExperience with Snowflake and 5Tran preferred.Experience in report writing within Hyperion is preferredFluency writing DAX Measures and Calculated ColumnsData Preparation: Fluency using Power Query and writing SQL queries for data preparationData Modeling: Relationships and DAX formulae across 15+ tables data modelsData Visualization Skills: being able to quickly provide meaningful insights from data, and apply best practices at reportingExperience with M Language for Power QueryExperience with Power BI Paginated Report BuilderSolid Experience in Analysis, Design, Development and Deployment of Hyperion ReportsA love for insights, innate curiosity, and a deep desire to find ways to create valueSolid communication skillsPassion for automationComfort in a complex data environment and understanding of data structuresAbility to organize and lead meetings with business and operational data ownersAbility to tell a story to the end user using dataStrong ability to troubleshoot and resolve data issuesWork independently and with team members to understand database structure and business processesDocumenting all Power BI new and already existing assets, processes and proceduresBA or BS in statistics, math, computer science, physics or other technical related field; Master's degree is preferredExcellent presentation, writing, and Excel skills are a must