Automation Analyst

Role Automation Analyst(RPA)

Location India, Remote (Work from Anywhere in India)

Minimum Qualification B. Tech. (or equivalent) from an accredited institution

Indicative Experience 5+ Years

Domain Preferably Life-Sciences/Pharma.

Other benefits Health Insurance, Provident Fund, Life Insurance, Reimbursement of Certification

Expenses, Gratuity, 24x7 Health Desk

About Norstella

At Norstella, our mission is simple: to help our clients bring life-saving therapies to market quicker—and help patients in need.

Founded in 2022, but with history going back to 1939, Norstella unites best-in-class brands to help clients navigate the complexities at each step of the drug development life cycle —and get the right treatments to the right patients at the right time.

Each organization (Citeline, Evaluate, MMIT, Panalgo, The Dedham Group) delivers must-have answers for critical strategic and commercial decision-making. Together, via our market-leading brands, we help our clients:

· Citeline – accelerate the drug development cycle

· Evaluate – bring the right drugs to market

· MMIT – identify barrier to patient access

· Panalgo – turn data into insight faster

· The Dedham Group – think strategically for specialty therapeutics

By combining the efforts of each organization under Norstella, we can offer an even wider breadth of expertise, cutting-edge data solutions and expert advisory services alongside advanced technologies such as real-world data, machine learning and predictive analytics.

As one of the largest global pharma intelligence solution providers, Norstella has a footprint across the globe with teams of experts delivering world class solutions in the USA, UK, The Netherlands, Japan, China and India.

Job Description

Automation Analyst for Data Quality Testing for automated Data Production Systems

Automation Analyst- Software Engineer is expected to plan, develop script and manage Comparative Testing and ensuring data quality across dimensions like Accuracy, Completeness, Consistency, Uniqueness, Timeliness, Validity, Currency, Conformity, Integrity, and Precision, the skillset encompasses a broad range of technical proficiencies, analytical capabilities, and specialized knowledge areas. This comprehensive skillset is crucial for addressing the multifaceted challenges of maintaining high-quality data in automated processes.

Technical Skills:

RPA Platform Expertise: Proficient in leading RPA tools (e.g., UiPath, Blue Prism, Automation Anywhere) with the ability to design, develop, and implement RPA solutions.

Database Management: Proficiency in SQL and experience with database technologies for managing, querying, and manipulating data. Understanding of NoSQL databases can also be beneficial for handling unstructured data.

Data Quality Tools: Familiarity with specialized data quality tools for data profiling, cleansing, and validation. Knowledge of ETL tools and processes for data integration and transformation.

APIs and Integration Techniques: Skills in integrating RPA solutions with various data sources and third-party applications through RESTful APIs, web services (SOAP, REST), and other integration methods.

Analytical Skills:

Data Analysis: Ability to analyze and interpret data, identifying issues related to accuracy, completeness, consistency, etc., and applying statistical methods to validate findings.

Quality Assurance Methods: Deep understanding of QA best practices, testing methodologies, and frameworks to ensure the reliability and validity of data within RPA processes.

Data Quality Dimensions Focus:

Accuracy & Precision: Ensure data accuracy and precision through validation checks, error detection mechanisms, and comparative testing against known standards or benchmarks.

Completeness: Ability to identify missing or incomplete data and implement processes to ensure data completeness.

Consistency & Conformity: Skills in ensuring data consistency across systems and conformity to predefined formats and standards.

Uniqueness & Integrity: Techniques to identify and eliminate duplicate data entries, ensuring data uniqueness and integrity, especially in databases and data lakes.

Timeliness & Currency: Ensure data is up-to-date and relevant, implementing checks for data timeliness and currency, especially in time-sensitive applications.

Validity & Conformity: Proficiency in applying rules and criteria to validate data inputs and ensure they conform to specific schemas, formats, or standards.

Additional Skills:

Documentation: Strong documentation skills for creating clear and detailed reports on data quality issues, RPA process designs, and testing outcomes.

Collaboration: Ability to work effectively with cross-functional teams, including data analysts, business stakeholders, and IT support, to address data quality issues.

Continuous Learning: Commitment to staying updated with the latest trends in RPA, data quality management, and emerging technologies in data analytics and automation.

Project Management: Basic project management skills, including task prioritization, timeline management, and the use of project management tools.

An RPA Software Engineer with these skills will be well-equipped to design and implement robust RPA solutions that adhere to high standards of data quality, ensuring that automated processes are reliable, accurate, and effective in supporting business objectives.

Mandatory Skills required:

Experience with RDS / Cloud based RDBMS

Strong SQL skills.

2+ years’ experience in writing automation scripts using Python, Java, VB Script, Power shell, C#.

Hands on experience on RPA tools and cognitive platforms such as UiPath, Blue Prism, Automation Anywhere, etc. UiPath experience is highly preferred.

Hands on experience using Intelligent Documentation Processing Automation Tools; similar to ABBY

Understanding of workflow-based logic.

Familiarity and experience in using PowerAutomate and Office 365 applications.

Familiarity and experience in using Cloud based ecosystems like AWS, Azure, GCP, etc.

Important Skills:

Able to design technical specification documents for RPA Projects.

Experience developing and consuming APIs.

Familiar with and experience with Snowflake and SnowSQL

UiPath RPA Developer or similar certifications preferred.

Strong attention to detail and analytical skills.

Excellent problem solving/analytical skills and complex troubleshooting methods both in Production and internal QA environments.

Ability to work through ambiguous situations.

Excellent presentation, verbal, and written communication skills.

Self-motivated, able to work independently, and able to take initiative without always being directed.

Ability to multitask in a fast-paced environment and prioritize the most critical tasks and projects.

Experience with Agile development methodology.

The guiding principles for success at Norstella:

01: Bold, Passionate, Mission-First

We have a lofty mission to Smooth Access to Life Saving Therapies and we will get there by being bold and passionate about the mission and our clients. Our clients and the mission in what we are trying to accomplish must be in the forefront of our minds in everything we do.

02: Integrity, Truth, Reality

We make promises that we can keep, and goals that push us to new heights. Our integrity offers us the opportunity to learn and improve by being honest about what works and what doesn’t. By being true to the data and producing realistic metrics, we are able to create plans and resources to achieve our goals.

03: Kindness, Empathy, Grace

We will empathize with everyone's situation, provide positive and constructive feedback with kindness, and accept opportunities for improvement with grace and gratitude. We use this principle across the organization to collaborate and build lines of open communication.

04: Resilience, Mettle, Perserverance

We will persevere – even in difficult and challenging situations. Our ability to recover from mis-steps and failures in a positive way will help us to be successful in our mission.

05: Humility, Gratitude, Learning

We will be true learners by showing humility and gratitude in our work. We recognize that the smartest person in the room is the one who is always listening, learning, and willing to shift their thinking.