About the Company Gemini is a global crypto and Web3 platform founded by Cameron and Tyler Winklevoss in 2014, offering a wide range of simple, reliable, and secure crypto products and services to individuals and institutions in over 70 countries. Our mission is to unlock the next era of financial, creative, and personal freedom by providing trusted access to the decentralized future. We envision a world where crypto reshapes the global financial system, internet, and money to create greater choice, independence, and opportunity for all — bridging traditional finance with the emerging cryptoeconomy in a way that is more open, fair, and secure. The Department: Data The Role: Analytics Engineer As a member of our data team, youll deliver high quality work while solving challenges that impact the whole or part of the teams data architecture. Youll update yourself with recent advances in Big data space and provide solutions for large-scale applications aligning with teams long term goals. Your work will help resolve complex problems with identifying root causes, documenting the solutions, and implementing Operations excellence (Data auditing, validation, automation, maintainability) in mind. Communicating your insights with leaders across the organization is paramount to success. This role is required to be in person twice a week at either our Seattle, WA or New York City, NY office. Responsibilities: <ul> <li>Design, architect and implement best-in-class Data Warehousing and reporting solutions</li> <li>Partner with product managers, data engineers and other functions to drive insights for the firm</li> <li>Design, automate, build, and launch scalable, efficient and reliable data pipelines into production using Python</li> <li>Design, build and enhance dimensional models for Data Warehouse and BI solutions</li> <li>Perform analysis to derive actionable insights for key stakeholders</li> <li>Perform root cause analysis and resolve production and data issues</li> <li>Create test plans, test scripts and perform data validation</li> <li>Tune SQL queries, reports and ETL pipelines</li> <li>Build and maintain data dictionary and process documentation</li> <li>Research new tools and technologies to improve existing processes</li> </ul> Minimum Qualifications: <ul> <li>2+ years experience developing a BI applications (Tableau/Looker/Power BI, etc)  </li> <li>Advanced skills with SQL are a must</li> <li>2+ years experience in custom ETL design, implementation and maintenance</li> <li>2+ years experience with schema design and dimensional data modeling</li> <li>Experience making sense of data and developing actionable insights</li> <li>Experience with one or more MPP databases (Redshift, Bigquery, Snowflake, etc)</li> <li>Experience with one or more ETL frameworks (Custom, DBT, Databricks, etc)</li> <li>Experience with statistics, machine learning and generative AI</li> <li>Strong software engineering skills in any server side language, preferable Python</li> <li>Experienced in working collaboratively across different teams and departments</li> <li>Strong technical and business communication</li> </ul> Preferred Qualifications: <ul> <li>Proficient in Developing LookML</li> <li>Proficient in Python</li> <li>Knowledge and experience of financial markets, banking or exchanges</li> </ul> <div>It Pays to Work Here</div> <div> </div> <div>The compensation &amp; benefits package for this role includes:</div> <ul> <li>Competitive starting salary</li> <li>A discretionary annual bonus</li> <li>Long-term incentive in the form of a new hire equity grant</li> <li>Comprehensive health plans</li> <li>401K with company matching</li> <li>Paid Parental Leave</li> <li>Flexible time off</li> </ul> Salary Range: The base salary range for this role is between $116,250 - $155,000 in the State of New York, the State of California and the State of Washington. This range is not inclusive of our discretionary bonus or equity package. When determining a candidate’s compensation, we consider a number of factors including skillset, experience, job scope, and current market data. In the United States, employees within the New York, Seattle, and Miami metropolitan areas are expected to work from the designated office twice a week, unless there is a job-specific requirement to be in the office every work day. We believe our hybrid approach for those near our NYC, Seattle, and Miami offices increases productivity through more in-person collaboration where possible. Employees outside of these areas are considered part of our remote-first workforce. At Gemini, we strive to build diverse teams that reflect the people we want to empower through our products, and we are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. Equal Opportunity is the Law, and Gemini is proud to be an equal opportunity workplace. If you have a specific need that requires accommodation, please let a member of the People Team know. #LI-JS2