Business Intelligence Developer

Company: Bakkt
Location: Alpharetta
Posted on: November 16, 2021

Job Description:

Who We Are Bakkt unlocks the $1.2+ trillion that is currently held in digital assets like cryptocurrencies, rewards and loyalty points, gift cards, and gaming assets. We began in 2018 with the vision to bring trust and transparency to digital assets by showing people that they hold more value than they realize. We serve institutional clients through the Bakkt Warehouse and Bakkt-- Bitcoin Futures and Options contracts in an end-to-end regulated market with true price transparency. Merchants that partner with Bakkt see a lower cost of payment acceptance, enhanced customer engagement, and increased loyalty redemption options. For consumers like you, the Bakkt App allows you to aggregate your digital assets to track, spend, and send them in the way that best suits your lifestyle. Bakkt is the only place that puts the power in your hands by enabling all-in-one aggregation. Something like this has never been built before, and we aim to make what was previously thought impossible, possible - leveraging our values of betting big and serving as multipliers on our team. We believe we are more than the sum of our parts and we want you to bet big with us. Now, let's get to the real reason why you're here - how we can work together. Description The BI Developer will support the Data Engineering team, working close with business users, you'll be responsible to support end user data needs. This position requires to be able to convert business needs in technical requirements to support BI team to build the robust multi cloud DW. Business acumen or the desire to dig deep into the details focused on the customer experience & revenue generation is desired.

• Ability to partner with the business in an extremely agile, iterative, and collaborative process to generate "simplified" operational and business views of a very complex and fragmented set of enterprise sales and operations data.
• Experienced and comfortable with production prototyping and DevOps type delivery.
• Hands on experience with BI / Data Analysis, collecting business needs and converting those into technical reporting and dashboards. Act as liaison between the end users & tech team.
• Support users in the learning process for the reporting tools, User training on the data platform
• Skilled communication, data presentation and storytelling skills. Promote the Self-Service BI culture.
• Create and maintain replicable and scalable data pipelines for data generation, integration and dashboards displaying the metrics to facilitate business decisions.
• Maintain the DW standardization guidelines and methodologies, design sampling strategies to achieve the precise metrics of data standardization algorithms and ensure the quality of assessment.
• Experience conducting quantitative and qualitative financial & operational analyses working with complex unstructured datasets. Experience in Project Scoping, Process-Design, BA and PM work.
• Understand Descriptive, Predictive, Prescriptive and Diagnostic Analytics. Familiarity with advanced analytics and Data Science techniques to support Data Mining, Forecasting and Predictive modeling.
• Maintain Web Analytics platform to track and analyze site visits, conversions, promo tracking, hit maps etc. Experience with tools like Google Analytics, Heap, Matomo etc. Requirements
  • 5+ years of experience with reporting tools like Google Data Studio, Power BI, MS Excel, Looker, Tableau, etc. Proficiency with TSQL, Python, R etc.
  • Assemble large and complex heterogeneous data sets that meet functional/non-functional business requirements under the big data frameworks i.e. ADLS, HDFS, Hive, Spark.
  • In-depth understanding of RDBMS systems and usage of OLAP, OLTP for BI needs - MS SQL, My SQL, Maria DB and Oracle hands on experience preferred.
  • Demonstrated Data Visualization experience (Power BI / SSRS / Tableau / Looker / Google Data Studio). ETL experience such as SSIS, Segment, Azure Data Factory, Data prep etc.
  • Ability to write complex SQL, cohort / comparative analysis, and Data modeling skills. Strong knowledge of Data Warehousing and Multidimensional Data Modeling. Multidimensional Vs Tabular Data modeling. Star Schema Vs Snowflake, Fact & Dimension tables etc.
  • Technical expertise with DB design / development, ETL, data mining and segmentation techniques, handling large volumes of data and building scalable systems
  • Knowledge of back-end and front-end technologies: SQL, HTML, .Net, JSON, DAX, MDX, SSAS, etc.
  • Experience with GCP and MS Azure, migrate legacy ETL, Reporting to multi-cloud DW environment. Certification: Microsoft Azure / GCP Data or DW Engineer certification a plus Bakkt is devoted to having diversity in its workforce and is proud to be an equal opportunity employer. Bakkt does not make any employment decisions based on race, color, religion, sex, national origin, veteran status, disability, age, sexual orientation, gender identity of any other characteristic protected by law.

Keywords: Bakkt, Alpharetta , Business Intelligence Developer, IT / Software / Systems , Alpharetta, Georgia