Data Engineer at Molecular Connections · Bengaluru (Bangalore) · 2 - 5 years · ₹13L - ₹16L / yr · Profitable · Posted 12 Dec 2024
Data AnalyticsResponsibilities:
· 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.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Molecular Connections
About
Company social profiles
Similar jobs (3)
PythonWe're hiring a Data Analyst to turn raw data into clear, actionable insight. You'll partner with product, sales, marketing, and operations teams to answer their most important questions with data — building dashboards, running deep-dive analyses, and defining the metrics the business runs on. The ideal candidate is fluent in SQL, comfortable wrangling messy datasets, and just as strong at telling the story behind the numbers as they are at producing them. You'll own the accuracy and trustworthiness of the reporting stakeholders rely on to make decisions.
Key Responsibilities
- Design, build, and maintain dashboards and recurring reports across business functions
- Write and optimize SQL queries to extract, join, and transform data from multiple sources
- Run ad-hoc and deep-dive analyses to answer specific business questions
- Define, document, and standardize metrics and KPIs alongside stakeholders
- Investigate data-quality issues and ensure the numbers people see are accurate
- Translate analysis into clear recommendations and present them to non-technical audiences
- Support experimentation and A/B test analysis where relevant
- Automate repetitive reporting to free up time for higher-value analysis
Requirements
- 3+ years in a data analyst or business-intelligence role
- Strong SQL and hands-on experience with Power BI and/or Tableau
- Working knowledge of Python (pandas/numpy) for analysis
- Solid grounding in statistics and analytical methods
- Advanced Excel and strong data-visualization / storytelling skills
- Ability to work independently with stakeholders across functions
Nice to have
- Experience with cloud data warehouses (BigQuery, Snowflake, Redshift)
- Exposure to dbt or other ETL/transformation tooling
Data AnalyticsThe Power BI Intern will assist the analytics team in using Microsoft Power BI to create interactive dashboards and reports. Working with actual datasets to assist well-informed business decision-making, this position provides practical exposure to data analysis, visualization, and business intelligence techniques.
Key Responsibilities
- Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
- Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
- Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
- Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
- Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
- Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
- Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
- Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
- Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.
Required Skills & Qualifications
- Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.
- Proven experience (1–3 years or as per company requirement) in MIS, data reporting/analysis, or similar role.
- Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
- Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
- Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
- Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
- Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon