MSBI Developer

About UPS:

Moving our world forward by delivering what matters! UPS is a company with a proud past and an even brighter future. Our values define us. Our culture differentiates us. Our strategy drives us. At UPS we are customer first, people led and innovation driven. UPS’s India based Technology Development Centers will bring UPS one step closer to creating a global technology workforce that will help accelerate our digital journey and help us engineer technology solutions that drastically improve our competitive advantage in the field of Logistics.

‘Future You’ grows as a visible and valued Technology professional with UPS, driving us towards an exciting tomorrow. As a global Technology organization we can put serious resources behind your development. If you are solutions orientated, UPS Technology is the place for you. ‘Future You’ delivers ground-breaking solutions to some of the biggest logistics challenges around the globe. You’ll take technology to unimaginable places and really make a difference for UPS and our customers.

Job Summary:

This position participates in the support of batch and real-time data pipelines utilizing various data analytics processing frameworks in support of data science practices for Marketing and Finance business units. This position supports the integration of data from various data sources, as well as performs extract, transform, load (ETL) data conversions, and facilitates data cleansing and enrichment. This position performs full systems life cycle management activities, such as analysis, technical requirements, design, coding, testing, implementation of systems and applications software. This position participates and contributes to synthesizing disparate data sources to support reusable and reproducible data assets.

RESPONSIBILITIES

• Supervises and supports data engineering projects and builds solutions by leveraging a strong foundational knowledge in software/application development. He/she is hands on.

• Develops and delivers data engineering documentation.

• Gathers requirements, defines the scope, and performs the integration of data for data engineering projects.

• Recommends analytic reporting products/tools and supports the adoption of emerging technology.

• Performs data engineering maintenance and support.

• Provides the implementation strategy and executes backup, recovery, and technology solutions to perform analysis.

• Performs ETL tool capabilities with the ability to pull data from various sources and perform a load of the transformed data into a database or business intelligence platform.

• Codes using programming language used for statistical analysis and modeling such as Python/Spark

REQUIRED QUALIFICATIONS:

• Literate in the programming languages used for statistical modeling and analysis, data warehousing and Cloud solutions, and building data pipelines.

• Proficient in developing notebooks in Data bricks using Python and Spark and Spark SQL.

• Strong understanding of a cloud services platform (e.g., GCP, or AZURE, or AWS) and all the data life cycle stages. Azure is preferred

• Proficient in using Azure Data Factory and other Azure features such as LogicApps.

• Preferred to have knowledge of Delta lake, Lakehouse and Unity Catalog concepts.

• Strong understanding of cloud-based data lake systems and data warehousing solutions.

• Has used AGILE concepts for development, including KANBAN and Scrums

• Strong understanding of the data interconnections between organizations’ operational and business functions.

• Strong understanding of the data life cycle stages - data collection, transformation, analysis, storing the data securely, providing data accessibility

• Strong understanding of the data environment to ensure that it can scale for the following demands: Throughput of data, increasing data pipeline throughput, analyzing large amounts of data, Real-time predictions, insights and customer feedback, data security, data regulations, and compliance.

• Strong knowledge of algorithms and data structures, as well as data filtering and data optimization.

• Strong understanding of analytic reporting technologies and environments (e.g., Power BI, Looker, Qlik, etc.)

• Understanding of distributed systems and the underlying business problem being addressed, as well as guides team members on how their work will assist by performing data analysis and presenting findings to the stakeholders. •

REQUIRED SKILLS:

 3 years of experience with Databricks, Apache Spark, Python, and SQL

Preferred SKILLS:

 DeltaLake Unity Catalog, R, Scala, Azure Logic Apps, Cloud Services Platform (e.g., GCP, or AZURE, or AWS), and AGILE concepts.

Description of Role: 

We are looking for a career-minded professional with global perspective to join the Mumbai based Data & Analytics Group (DAG).

Key responsibilities:

As part of the Data & Analytics Group (DAG) and reporting to the Head of the India DAG locally, the individual is responsible for the following –

1.Review, analyze, and resolve data quality issues for enterprise core data in the IM Data Warehouse.

2.Coordinate with data owners and other teams to identify root-cause of data quality issues and implement solutions.

3.Coordinate the onboarding of data from various internal / external sources into the central repository.

4.Work closely with Data Owners/Owner delegates on data analysis and development data quality (DQ) rules. Work with IT on enhancing DQ controls.

5.End-to-end analysis of business processes, data flows, and data usage to improve business productivity through re-engineering and data governance.

6.Interact with business stakeholders to identify, prioritize, and address data-related needs and issues.

7.Document business requirements and use cases for data-related projects.

8.Manage change control process and participate in user acceptance testing (UAT) activities.

9.Support other DAG initiatives.

Key Skills:

1.Ability to interact with business and technology teams to understand processes and data usage.

2.Ability to do data analysis - to trace data from source to consumption.

3.Capable of working across organization and as part of a cross-functional virtual team. Ability to work and think independently, but within a team-based approach.

4.Problem solver, self-starter, ability to work through an entire issue lifecycle. Ability to effectively prioritize and multi-task.

5.Strong communication skills

Key qualifications:

1.Bachelor’s Degree required and any other relevant academic course a plus.

2.Strong domain knowledge of investment data

3.5+ years of data management, data analytics, or data governance experience in financial services

4.Experience in data analysis, exploratory analysis using SQL and formulating data quality rules.

5.Experience working with BI reporting tools like Tableau, Power BI is preferred.

6.Knowledge in coding, Python is a plus.

7.Prior experience working with Data Platforms like Aladdin, FactSet, Bloomberg, MDM platforms preferred.

Key Responsibilities:

Power BI Development:

• Design, develop, and deploy interactive dashboards and reports using Power BI.
• Connect to various data sources, import data, and transform data for Business Intelligence.
• Optimize and fine-tune Power BI dashboards to ensure performance and usability.
• Implement data modeling, DAX queries, and custom visualizations to meet business requirements.
• Collaborate with business stakeholders to understand their needs and deliver data-driven solutions.
• Ensure data accuracy, consistency, and security across all reports and dashboards.

PowerApps Development:

• Design, develop, and deploy applications using PowerApps to streamline business processes.
• Integrate PowerApps with other Microsoft services (e.g., SharePoint, Dynamics 365) and third-party applications.
• Develop custom connectors and APIs to extend PowerApps capabilities.
• Maintain and troubleshoot existing PowerApps solutions to ensure they meet user needs and performance standards.
• Provide training and support to end-users on how to use PowerApps effectively.

Qualifications:

Education:

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field.

Experience:

• Minimum of 3 years of experience in Power BI development.
• Minimum of 1 year of experience in PowerApps development.
• Proven track record of delivering business intelligence solutions and applications that meet business requirements.

Responsibilities:

·       Analyze complex data sets to answer specific questions using MMIT’s market access data (MMIT) and Norstella claims data, third-party claims data (IQVIA LAAD, Symphony SHA). Applicant must have experience working with the aforementioned data sets exclusively.

·       Deliver consultative services to clients related to MMIT RWD sets

·       Produce complex analytical reports using data visualization tools such as Power BI or Tableau

·       Define customized technical specifications to surface MMIT RWD in MMIT tools. 

·       Execute work in a timely fashion with high accuracy, while managing various competing priorities; Perform thorough troubleshooting and execute QA; Communicate with internal teams to obtain required data

·       Ensure adherence to documentation requirements, process workflows, timelines, and escalation protocols

·       And other duties as assigned.

Requirements:

·       Bachelor’s Degree or relevant experience required

·       2-5 yrs. of professional experience in RWD analytics using SQL

·       Fundamental understanding of Pharma and Market access space

·       Strong analysis skills and proficiency with tools such as Tableau or PowerBI

·       Excellent written and verbal communication skills.

·       Analytical, critical thinking and creative problem-solving skills.

·       Relationship building skills.

·       Solid organizational skills including attention to detail and multitasking skills.

·       Excellent time management and prioritization skills.

• Deliver full-cycle Tableau development projects, from business needs assessment and data discovery, through solution design, to delivery to client.

• Enable our clients and ourselves to answer questions and develop data-driven insights through Tableau.

• Provide technical leadership and support across all aspects of Tableau development and use, from data specification development, through DataMart development, to supporting end-user dashboards and reports.

• Administrate Tableau Server by creating sites, add/remove users, and provide the appropriate level access for users.

• Strategize and ideate the solution design. Develop UI mock-ups, storyboards, flow diagrams, conceptual diagrams, wireframes, visual mockups, and interactive prototypes.

• Develop best practices guidelines for Tableau data processing and visualization. Use these best practices to quickly deliver functionality across the client base and internal users.

• Degree in a highly-relevant analytical or technical field, such as statistics, data science, or business analytics.

· 5+ years as a Tableau developer and administrator.

· Extensive experience with large data sets, statistical analyses, and visualization as well as hands-on experience on tools (SQL, Tableau, Power BI).

· Ability to quickly learn and take responsibility to deliver.

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.

HIRING SQL Developers with max 20 days Of NOTICE PERIOD

Job ID: TNS2023DB01

Who Should apply?

• Only for Serious job seekers who are ready to work in night shift
• Technically Strong Candidates who are willing to take up challenging roles and want to raise their Career graph
• No DBAs & BI Developers, please

• Exposure to the latest technology
• Opportunity to work on different platforms
• Rapid Career Growth
• Friendly Knowledge-Sharing Environment

• BE/MTech/MCA/MSc
• 2yrs Hands Experience in MS SQL / NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 20 days
• Candidates will be selected based on logical/technical and scenario-based testing
• Work time - 10:00 pm to 6:00 am

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

1. Technical Skills Desired:
   1. Experience in MS SQL Server, and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / any of NoSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in the parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

1. Functional Skills Desired:
   1. The banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, and mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements
   5. Think out-of-box for business solution