Azure Data Engineer

Exp-Min 10 Years

Location Mumbai

Sal-Nego

Powerbi, Tableau, QlikView,

Solution Architect/Technology Lead – Data Analytics

Role

Looking for Business Intelligence lead (BI Lead) having hands on experience BI tools (Tableau, SAP Business Objects, Financial and Accounting modules, Power BI), SAP integration, and database knowledge including one or more of Azure Synapse/Datafactory, SQL Server, Oracle, cloud-based DB Snowflake. Good knowledge of AI-ML, Python is also expected.

• You will be expected to work closely with our business users. The development will be performed using an Agile methodology which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc.) and XP (continuous integration, refactoring, unit testing, etc) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership, leadership and be able to work well in teams.
• Responsibilities :
• Design, development and support of multiple/hybrid Data sources, data visualization Framework using Power BI, Tableau, SAP Business Objects etc. and using ETL tools, Scripting, Python Scripting etc.
• Implementing DevOps techniques and practices like Continuous Integration, Continuous Deployment, Test Automation, Build Automation and Test-Driven Development to enable the rapid delivery of working code-utilizing tools like Git. Primary Skills

Requirements

• 10+ years working as a hands-on developer in Information Technology across Database, ETL and BI (SAP Business Objects, integration with SAP Financial and Accounting modules, Tableau, Power BI) & prior team management experience
• Tableau/PowerBI integration with SAP and knowledge of SAP modules related to finance is a must
• 3+ years of hands-on development experience in Data Warehousing and Data Processing
• 3+ years of Database development experience with a solid understanding of core database concepts and relational database design, SQL, Performance tuning
• 3+ years of hands-on development experience with Tableau
• 3+ years of Power BI experience including parameterized reports and publishing it on PowerBI Service
• Excellent understanding and practical experience delivering under an Agile methodology
• Ability to work with business users to provide technical support
• Ability to get involved in all the stages of project lifecycle, including analysis, design, development, testing, Good To have Skills
• Experience with other Visualization tools and reporting tools like SAP Business Objects.

Responsibilities

> Selecting features, building and optimizing classifiers using machine

> learning techniques

> Data mining using state-of-the-art methods

> Extending company’s data with third party sources of information when

> needed

> Enhancing data collection procedures to include information that is

> relevant for building analytic systems

> Processing, cleansing, and verifying the integrity of data used for

> analysis

> Doing ad-hoc analysis and presenting results in a clear manner

> Creating automated anomaly detection systems and constant tracking of

> its performance

Key Skills

> Hands-on experience of analysis tools like R, Advance Python

> Must Have Knowledge of statistical techniques and machine learning

> algorithms

> Artificial Intelligence

> Understanding of Text analysis- Natural Language processing (NLP)

> Knowledge on Google Cloud Platform

> Advanced Excel, PowerPoint skills

> Advanced communication (written and oral) and strong interpersonal

> skills

> Ability to work cross-culturally

> Good to have Deep Learning

> VBA and visualization tools like Tableau, PowerBI, Qliksense, Qlikview

> will be an added advantage

Seeking Data Analytics Trainer with Power BI and Tableau Expertise

Experience Required: Minimum 3 Years

Location: Indore

Part-Time / Full-Time Availability

We are actively seeking a qualified candidate to join our team as a Data Analytics Trainer, with a strong focus on Power BI and Tableau expertise. The ideal candidate should possess the following qualifications:

  A track record of 3 to 6 years in delivering technical training and mentoring.

  Profound understanding of Data Analytics concepts.

  Strong proficiency in Excel and Advanced Excel.

  Demonstrated hands-on experience and effective training skills in Python, Data Visualization, R Programming, and an in-depth understanding of both Power BI and Tableau.

Follow me on LinkedIn to get more job updates 👇

https://www.linkedin.com/in/shweta-bharti-a105ab197/

JOB DESCRIPTION:. THE IDEAL CANDIDATE WILL:

• Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view. Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences. Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.

• Providing technical leadership to large enterprise scale projects. You will also be responsible for preparing estimates and defining technical solutions to proposals (RFPs). This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the project Roles & Responsibilities.

ELIGIBILITY CRITERIA: Desired Experience/Skills:
• Must have total 5+ yrs. in IT and 2+ years' experience working as a snowflake Data Architect and 4+ years in Data warehouse, ETL, BI projects.
• Must have experience at least two end to end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise preferably on Oracle.

• Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
• Experience with data security and data access controls and design
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
• Must have expertise in AWS or Azure Platform as a Service (PAAS)
• Certified Snowflake cloud data warehouse Architect (Desirable)
• Should be able to troubleshoot problems across infrastructure, platform and application domains.
• Must have experience of Agile development methodologies
• Strong written communication skills. Is effective and persuasive in both written and oral communication

Nice to have Skills/Qualifications:Bachelor's and/or master’s degree in computer science or equivalent experience.
• Strong communication, analytical and problem-solving skills with a high attention to detail.

About you:
• You are self-motivated, collaborative, eager to learn, and hands on
• You love trying out new apps, and find yourself coming up with ideas to improve them
• You stay ahead with all the latest trends and technologies
• You are particular about following industry best practices and have high standards regarding quality

• Create and maintain optimal data pipeline architecture,
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Author data services using a variety of programming languages
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure ‘big data’ technologies.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep our data separated and secure across national boundaries through multiple data centres and Azure regions.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Work in an Agile environment with Scrum teams.
• Ensure data quality and help in achieving data governance.

• 2+ years of experience in a Data Engineer role
• Undergraduate degree required (Graduate degree preferred) in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
• Experience using the following software/tools:
• Experience with big data tools: Hadoop, Spark, Kafka, etc.
• Experience with relational SQL and NoSQL databases
• Experience with data pipeline and workflow management tools
• Experience with Azure cloud services: ADLS, ADF, ADLA, AAS
• Experience with stream-processing systems: Storm, Spark-Streaming, etc.
• Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Understanding of ELT and ETL patterns and when to use each. Understanding of data models and transforming data into the models
• Experience building and optimizing ‘big data’ data pipelines, architectures, and data sets
• Strong analytic skills related to working with unstructured datasets
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management
• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores
• Experience supporting and working with cross-functional teams in a dynamic environment

• Actively engage with internal business teams to understand their challenges and deliver robust, data-driven solutions.
• Work alongside global counterparts to solve data-intensive problems using standard analytical frameworks and tools.
• Be encouraged and expected to innovate and be creative in your data analysis, problem-solving, and presentation of solutions.
• Network and collaborate with a broad range of internal business units to define and deliver joint solutions.
• Work alongside customers to leverage cutting-edge technology (machine learning, streaming analytics, and ‘real’ big data) to creatively solve problems and disrupt existing business models.

In this role, we are looking for:

• A problem-solving mindset with the ability to understand business challenges and how to apply your analytics expertise to solve them.
• The unique person who can present complex mathematical solutions in a simple manner that most will understand, including customers.
• An individual excited by innovation and new technology and eager to finds ways to employ these innovations in practice.
• A team mentality, empowered by the ability to work with a diverse set of individuals.

• A Bachelor’s degree in Data Science, Math, Statistics, Computer Science or related field with an emphasis on analytics.
• 5+ Years professional experience in a data scientist/analyst role or similar.
• Proficiency in your statistics/analytics/visualization tool of choice, but preferably in the Microsoft Azure Suite, including Azure ML Studio and PowerBI as well as R, Python, SQL.

• Excellent communication, organizational transformation, and leadership skills
• Demonstrated excellence in Data Science, Business Analytics and Engineering