Job Location: Bangalore/Bengaluru
Job Description – Senior Data Analytics
(SQL Server Integration services, Reporting & Analysis SSIS, SSAS & SSRS) with experience on SQL Query knowledge, reporting PowerBI,
Description:
The BI Developer will support the Data Engineering team, working close with business users, youll 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 maintainability 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.
Submit CV To All Data Science Job Consultants Across India For Free
