BI Engineer

Position Title : BI Engineer

Location : Austin, TX

Duration : Full Time

GRS ID : 245703

RGS ID (Please put the requirement ID)

8575689

# of requirements

1

Job Title

BI Engineer

Relevant Experience

(in Yrs)

7 -8 years

Technical/Functional Skills

Primary & strong SQL background
- 7+ years of experience writing, maintaining, and troubleshooting business-critical queries
- 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

Interpersonal Skills
- Self-lead problem-solver; seeks to identify and face problems, dig in, get answers, and share information
- High expectations of fit, finish, polish, accuracy, testing, QA, and attention to detail
- Experience working in a structured SDLC environment (Scrum, Agile, Kanban, etc.)
- Experience in a high-volume reporting environment - intaking, scoping, taking bugs to completion
- Strong understanding of the importance of metadata management, documentation, data dictionaries, code comments
- Excellent verbal and written communication with technical & non-technical business partners and stakeholders
- Confidence to take calculated risks in ambiguous situations

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

Roles & Responsibilities

Part of team providing BI Support to multiple teams within Cloud 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

Administrating BI Systems

Designing Security Model and implementing access policies

Developing Data Extraction (ETL)

Coding Data Aggregation Workflows

Designing & Configuring Data Storage

Generic Managerial Skills

Manage day to day Individual work , Good Communication

Education

Bachelors / Masters

Start date (dd-mmm-yy)

Immediate

Duration of assignment (in Months)

12+ months

Work Location

Austin, TX