<p>Location: Remote - USA</p><br/><p>Employment Type: Salaried</p><br/><p>Team: Customer Org</p><br/><div>Fanatics is a leading global digital sports platform, complete with offerings that excite fans and maximize the reach and presence for partners across the entire sports ecosystem. Come help us build a company the world has never seen before!&nbsp;We are first and foremost a technology company.&nbsp;We build innovative fan experiences through highly analytical, forward thinking, and open-minded collaboration. We are passionate about evaluating and finding the right tech for the jobs at hand, and we get excited about building solutions for modern challenges. </div><div><br></div><div>Roles and Responsibilities:</div><div><br></div><div>&gt;Develop Report Services Documents, Dossiers, Complex Grid and Graph Reports in Microstrategy and Tableau</div><div>&gt; Create Microstrategy objects like Metrics (Compound and Derived), Filters (Metric Qualifications, Nested Prompts, Relationship Filters)&nbsp;</div><div>&gt;Gather BI reporting requirements and work with BI Product Managers , Business users and Data Engineering Teams&nbsp;</div><div>&gt;Design Aggregate tables, reporting views used in BI Reports of Microstrategy and Tableau</div><div>&gt;Performance tuning of Queries generated by Microstrategy and Tableau by reading explain plan and also working with DBAs&nbsp;</div><div>&gt;Build Data pipelines using SSIS packages</div><div>&gt;Write new Stored Procedures and Maintain existing stored procedures in MS SQL Server&nbsp;</div><div><br></div><div><br></div><div>Key Qualifications;</div><div>&gt;10+ years of experience developing Reports, Schema Objects and Dashboards using Microstrategy</div><div>&gt;4+ years of experience with Tableau</div><div>&gt;10+ years of SQL Skills with MS SQL Server, AWS Redshift, Teradata</div><div>&gt;8+ years of Experience with MicroStrategy version 9 and above</div><div>&gt;Experience in Financial Reporting and Finance Reporting KPIs in either Retail, &gt;Direct to Consumer business or eCommerce Domain&nbsp;</div><div>&gt;4+ years of experience using Microsoft Excel and ability to read Excel Dashboards, Pivot Table logic and Excel Macros</div><div>&gt; Microstrategy Administration Knowledge will be a plus</div><div><b>Things We Care About</b></div><div><br></div><div>·<span style="font-size: 7pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Your career growth, your ideas, your work-life balance, and your well-being.</div><div>·<span style="font-size: 7pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Diversity and Inclusion</div><div>·<span style="font-size: 7pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Our Company <a href="https://www.fanaticsinc.com/culture" class="postings-link">Culture and Values</a></div><div>·<span style="font-size: 7pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Providing outstanding <a href="https://www.fanaticsinc.com/perks-and-benefits" class="postings-link">Company Perks and Benefits</a></div><div><br></div><div><b>Company Overview</b></div><div>&nbsp;</div><div>Fanatics is building a leading global digital sports platform to ignite and harness the passions of fans and maximize the presence and reach for hundreds of partners globally. Optimizing these long-standing partnerships, a database of more than 80 million global consumers and a trusted, recognizable brand name, Fanatics is expanding beyond its position as a global leader for licensed sports merchandise to now becoming a next-gen digital sports platform, featuring an array of offerings for fans across the sports ecosystem.</div><div>&nbsp;</div><div>The Fanatics family of companies currently includes Fanatics Commerce, a vertically-integrated licensed merchandise business that has changed the way fans purchase their favorite team apparel, jerseys, headwear and hardgoods through a tech-infused approach to making and quickly distributing fan gear in today’s 24/7 mobile-first economy; Candy Digital, a digital collectibles company that is partnering with prominent sports properties, including MLB and MLBPA, to build an official NFT ecosystem; Fanatics Collectibles, through Topps as a cornerstone of the business, building a new model for the collectibles and trading cards hobby with top leagues and players association partners; and Fanatics Betting &amp; Gaming, a mobile betting, gaming and retail sportsbook platform. Fanatics’ partners include all major professional sports leagues (NFL, MLB, NBA, NHL, NASCAR, MLS, PGA) and hundreds of collegiate and professional teams, which include several of the biggest global soccer clubs.</div><div>&nbsp;</div><div>As a market leader with more than 9,000 employees, and hundreds of partners, suppliers, and vendors worldwide, we take responsibility for driving toward more ethical and sustainable practices. We are committed to building an inclusive Fanatics community, reflecting and representing society at every level of the business, including our employees, vendors, partners and fans. Fanatics is also dedicated to making a positive impact in the communities where we all live, work, and play through strategic philanthropic initiatives.</div><div>&nbsp;</div><div>At Fanatics, we’re a diverse, passionate group of employees aiming to ignite pride and passion in the fans we outfit, celebrate and support.&nbsp; We recognize that diversity helps drive and foster innovation, and through our IDEA program (inclusion, diversity, equality and advocacy) at Fanatics we provide employees with tools and resources to feel connected and engaged in who they are and what they do to support the ultimate fan experience.</div><div><br></div><div><a href="http://www.fanaticsinc.com/" style="font-size: 12pt" class="postings-link">www.fanaticsinc.com</a></div><div>&nbsp;</div><div><u>Ensure your Fanatics job offer is legitimate and don’t fall victim to fraud.&nbsp; Fanatics never seeks payment from job applicants.&nbsp; Fanatics recruiters will only reach out to applicants from an @fanatics.com or @fanatics.co.uk email address.&nbsp; For added security, where possible, apply through our company website at <a href="http://www.fanaticsinc.com/careers" class="postings-link">www.fanaticsinc.com/careers</a></u></div><div><br></div><div>Fanatics is committed to responsible planning and purchasing (RPP) practices, working with its business partners across its global and multi-layered supply chain, to ensure that planning, sourcing, and purchasing decisions, along with other supporting processes, do not impede or conflict with the fulfillment of Fanatics’ fair labor practices.</div><div><br></div><div><b>NOTICE TO CALIFORNIA RESIDENTS/APPLICANTS</b>: In connection with your application, we collect information that identifies, reasonably relates to or describes you (“Personal Information”). The categories of Personal Information that we collect include your name, government issued identification number(s), email address, mailing address, other contact information, emergency contact information, employment history, educational history, criminal record, and demographic information.<i>&nbsp;</i>&nbsp;We collect and use those categories of Personal Information about you for human resources and other business management purposes, including identifying and evaluating you as a candidate for potential or future employment or future contract positions, recordkeeping in relation to recruiting and hiring, conducting criminal background checks as permitted by law, conducting analytics, and ensuring compliance with applicable legal requirements and Company policies.</div>

Location: Remote - USA

  

Employment Type: Salaried

  

Team: Customer Org

  

Fanatics is a leading global digital sports platform, complete with offerings
that excite fans and maximize the reach and presence for partners across the
entire sports ecosystem. Come help us build a company the world has never seen
before! We are first and foremost a technology company. We build innovative
fan experiences through highly analytical, forward thinking, and open-minded
collaboration. We are passionate about evaluating and finding the right tech
for the jobs at hand, and we get excited about building solutions for modern
challenges.

  

Roles and Responsibilities:

  

>Develop Report Services Documents, Dossiers, Complex Grid and Graph Reports
in Microstrategy and Tableau

> Create Microstrategy objects like Metrics (Compound and Derived), Filters
> (Metric Qualifications, Nested Prompts, Relationship Filters)

>Gather BI reporting requirements and work with BI Product Managers , Business
users and Data Engineering Teams

>Design Aggregate tables, reporting views used in BI Reports of Microstrategy
and Tableau

>Performance tuning of Queries generated by Microstrategy and Tableau by
reading explain plan and also working with DBAs

>Build Data pipelines using SSIS packages

>Write new Stored Procedures and Maintain existing stored procedures in MS SQL
Server

  

  

Key Qualifications;

>10+ years of experience developing Reports, Schema Objects and Dashboards
using Microstrategy

>4+ years of experience with Tableau

>10+ years of SQL Skills with MS SQL Server, AWS Redshift, Teradata

>8+ years of Experience with MicroStrategy version 9 and above

>Experience in Financial Reporting and Finance Reporting KPIs in either
Retail, >Direct to Consumer business or eCommerce Domain

>4+ years of experience using Microsoft Excel and ability to read Excel
Dashboards, Pivot Table logic and Excel Macros

> Microstrategy Administration Knowledge will be a plus

 **Things We Care About**

  

·         Your career growth, your ideas, your work-life balance, and your
well-being.

·         Diversity and Inclusion

·         Our Company [Culture and
Values](https://www.fanaticsinc.com/culture)

·         Providing outstanding [Company Perks and
Benefits](https://www.fanaticsinc.com/perks-and-benefits)

  

 **Company Overview**



Fanatics is building a leading global digital sports platform to ignite and
harness the passions of fans and maximize the presence and reach for hundreds
of partners globally. Optimizing these long-standing partnerships, a database
of more than 80 million global consumers and a trusted, recognizable brand
name, Fanatics is expanding beyond its position as a global leader for
licensed sports merchandise to now becoming a next-gen digital sports
platform, featuring an array of offerings for fans across the sports
ecosystem.



The Fanatics family of companies currently includes Fanatics Commerce, a
vertically-integrated licensed merchandise business that has changed the way
fans purchase their favorite team apparel, jerseys, headwear and hardgoods
through a tech-infused approach to making and quickly distributing fan gear in
today’s 24/7 mobile-first economy; Candy Digital, a digital collectibles
company that is partnering with prominent sports properties, including MLB and
MLBPA, to build an official NFT ecosystem; Fanatics Collectibles, through
Topps as a cornerstone of the business, building a new model for the
collectibles and trading cards hobby with top leagues and players association
partners; and Fanatics Betting & Gaming, a mobile betting, gaming and retail
sportsbook platform. Fanatics’ partners include all major professional sports
leagues (NFL, MLB, NBA, NHL, NASCAR, MLS, PGA) and hundreds of collegiate and
professional teams, which include several of the biggest global soccer clubs.



As a market leader with more than 9,000 employees, and hundreds of partners,
suppliers, and vendors worldwide, we take responsibility for driving toward
more ethical and sustainable practices. We are committed to building an
inclusive Fanatics community, reflecting and representing society at every
level of the business, including our employees, vendors, partners and fans.
Fanatics is also dedicated to making a positive impact in the communities
where we all live, work, and play through strategic philanthropic initiatives.



At Fanatics, we’re a diverse, passionate group of employees aiming to ignite
pride and passion in the fans we outfit, celebrate and support.  We recognize
that diversity helps drive and foster innovation, and through our IDEA program
(inclusion, diversity, equality and advocacy) at Fanatics we provide employees
with tools and resources to feel connected and engaged in who they are and
what they do to support the ultimate fan experience.

  

[www.fanaticsinc.com](http://www.fanaticsinc.com/)



 _Ensure your Fanatics job offer is legitimate and don’t fall victim to fraud.
Fanatics never seeks payment from job applicants.  Fanatics recruiters will
only reach out to applicants from an @fanatics.com or @fanatics.co.uk email
address.  For added security, where possible, apply through our company
website at [www.fanaticsinc.com/careers](http://www.fanaticsinc.com/careers)_

  

Fanatics is committed to responsible planning and purchasing (RPP) practices,
working with its business partners across its global and multi-layered supply
chain, to ensure that planning, sourcing, and purchasing decisions, along with
other supporting processes, do not impede or conflict with the fulfillment of
Fanatics’ fair labor practices.

  

 **NOTICE TO CALIFORNIA RESIDENTS/APPLICANTS** : In connection with your
application, we collect information that identifies, reasonably relates to or
describes you (“Personal Information”). The categories of Personal Information
that we collect include your name, government issued identification number(s),
email address, mailing address, other contact information, emergency contact
information, employment history, educational history, criminal record, and
demographic information. _ _  We collect and use those categories of Personal
Information about you for human resources and other business management
purposes, including identifying and evaluating you as a candidate for
potential or future employment or future contract positions, recordkeeping in
relation to recruiting and hiring, conducting criminal background checks as
permitted by law, conducting analytics, and ensuring compliance with
applicable legal requirements and Company policies.

