Must Have Technical/Functional Skills
Primary & strong SQL background with 5 years of experience writing, maintaining, and troubleshooting business-critical queries / dashboard
- Must have Looker , Plx and Data Studio experience
- Deep understanding of mechanisms behind correlated subqueries, indexes, analytical functions, table-valued functions, and non-traditional joins- Experience working with hierarchical data- Should have the ability to come up with cost effective and optimized SQL and understand the query execution plan- Experience creating and guiding data analysis and visualization while communicating business value
Nice to have-
Deep sales operations/software sales/recurring revenue reporting subject-matter expertise- Deep financial reporting experience for a software company- Expert-level data visualization in Data Studio, Looker, etc.- Strong statistical/quantitative experience developing and defending forecasting models in Python/R- Knowledge of creating and/or maintaining ETL jobs
Experience Required 5 years
Roles & Responsibilities
•Provide BI Support to multiple engagements within Clould Organization
•Mapping Requirements to Data Model
•Creating Architecture Documents, Data Models and Data Mart
•Build new data sets and identify data outages
•Document the existing data model
•Investigate and resolve data access issues
•Gather and verify business requirements and identify gaps against existing data models
•Managing Master Data and maintaining data warehouse
•Migration of the legacy pipelines to the new infrastructure
•Manage data engineering and BI projects
•Maintaining Data Dictionaries
•Data cleansing
•Build new dashboards, modify existing dashboards
•Designing Security Model and implementing access policies
•Developing Data Extraction (ETL)
•Coding Data Aggregation Workflows
•Designing & Configuring Data Storage