27 Sep
|
Cloudxtreme
|
Hyderabad
27 Sep
Cloudxtreme
Hyderabad
As a KS Analytics Data Analyst, you will be responsible for delivering technical solutions on building high performing datamart and reporting tools using tools/technologies like MS SQL Server, MS Azure SQL, MSBI Suite, Azure Data Factory, Python.
Your key responsibilities include:
- Interact with end users to gather, document, and interpret requirements.
- Leverage requirements to design technical solution.
- Develop SQL objects and scripts based on design.
- Analyze, debug, and optimize existing stored procedures and views.
- Leverage indexes, performance tuning techniques, and error handling to improve performance of SQL scripts.
- Should be able to seamlessly work with different Azure services.
- Improve performance and find opportunities to improvise process to bring in efficiency in SQL, SSIS and ADF.
- Create, schedule and monitor SQL jobs.
- Should be proficient in building pipelines in SSIS and ADF.
- Should possess relevant experience in working with different sources and destinations.
- Should have knowledge on sourcing data through API calls.
- Should possess good knowledge in building applications and automate processes using Python.
- Should be capable of building solutions by leveraging different Azure Services in a cost effective and efficient way.
- Proactively prioritize activities, handle tasks and deliver quality solutions on time.
- Communicate clearly and regularly with team leadership and project teams.
- Manage ongoing deliverable timelines and own relationships with end clients to understand if deliverables continue to meet clients need.
- Work collaboratively with other team members and end clients throughout development life cycle.
- Research, learn,
implement, and share skills on new technologies.
- Understand the customer requirement well and provide status update to project lead (US/USI) on calls and emails efficiently.
- Proactively prioritize activities, handle tasks and deliver quality solutions on time.
- Guide and Mentor junior members in team to get them up to speed in domain, tool and technologies we work on.
- Manage and QA junior developers code and share feedback
- Continuously improves skills in this space by completing certification and recommended training.
- Obtain and maintain a thorough understanding of the MDM data model, Global Systems & Client attributes.
- Valuable to have knowledge on Full stack development.
Preferred candidate profile
Educational Qualification: B.E/B.Tech or MTech (60% or 6.5 GPA and above)
- Should be proficient in understanding of one or more of the following Technologies: Extensive knowledge in DBMS concepts, exposure to querying on any relational database preferably MS SQL Server, MS Azure SQL, SSIS and Tableau.
- Should have good experience in automating and generating insights using Python.
- Understands development methodology and lifecycle.
- Excellent analytical skills and communication skills (written, verbal, and presentation)
- Ability to chart ones’ own career and build networks within the organization.
- Ability to work both independently and as part of a team with professionals at all levels.
- Ability to prioritize tasks, work on multiple assignments, and raise concerns/questions where appropriate.
- Seek information / ideas / establish relationship with customer to assess any future opportunities
📌 SQL & SSIS + Azure (Hyderabad)
🏢 Cloudxtreme
📍 Hyderabad