Business Intelligence Developer

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

Key Skills

• SQL