Looking for Principal Data analyst, expertise in Healthcare domain

@neerajdhameliya

Hello, Your bottleneck sounds less like dashboards and more like warehouse/query architecture under growing clinical-trial workloads. I specialize in healthcare analytics using BigQuery, Redshift, Tableau, advanced SQL, and Python, with experience optimizing large datasets for fast clinician-facing reporting. I can help refactor schemas, improve partitioning/clustering, tune long-running SQL, automate QA checks in Python, and build Tableau dashboards that stay responsive under heavy filtering. I’m comfortable working in daily sprint-style collaboration and delivering fully documented, walkthrough-ready handoffs. Question: What’s your current biggest pain point: query speed, dashboard latency, or data-model scalability? Best, Niral

@LiveExperts

Hello, As a Principal Data Analyst with a speciality in healthcare, I'm confident that my skills, experience, and those of the whole Live Experts team are exactly what your project needs. We've been providing high-quality work for years, specializing in research writing, computer science, statistics/data analysis and big data analysis - all of which are crucial for transforming complex datasets into meaningful insights. In terms of technical skills, we’re seasoned veterans when it comes to working with Google Cloud Platform (BigQuery), Amazon Redshift, SQL, and Python - optimizing queries and tuning warehouse performance is second nature to us. We're also proficient in Tableau dashboards and extracting or connecting live data as necessary. Our data wrangling and automation expertise using Python will be invaluable for filling any gaps that pure SQL can't handle. But what sets us apart from the competition is our deep understanding of not only the healthcare analytics realm but also the intricate quirks of clinical trial data. We understand the importance of scalable data models reflecting trial requirements as well as ensuring efficient pipelines. Additionally, our commitment to detailed documentation and sharing practical guidance will ensure that the improvements we make stick long after each sprint. I would be thrilled to discuss your project subequently with you and get started turning your raw tables into insightful tableau dashboards! Thanks!

@Herculesz

Hi Clinical-trial datasets demand both performance and precision, because poorly structured models or slow queries can block real-time analysis and decision-making. The main challenge here is optimizing BigQuery/Redshift schemas while keeping complex clinical metrics accurate and easy to query. I can review your current models, refactor schemas with proper partitioning and clustering, and rewrite SQL for performance while maintaining readability and auditability. I’ll also implement data-quality checks and caching strategies to ensure consistent, fast results. From a technical side, I work with BigQuery, Redshift, advanced SQL optimization, Tableau, and Python for automation and analytics. I can build high-performance Tableau dashboards using extracts or live connections where appropriate, ensuring sub-5-second load times. I’ll document table structures, joins, and update logic clearly for long-term maintainability. My focus is delivering fast, scalable analytics that clinicians can rely on without delays. Thanks, Hercules

@tangramua

Dear ,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in Python, SQL, Big Data Sales, QlikView, Data Warehousing, Tableau, Data Analysis, PySpark, Data Modeling, BigQuery and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details.    Best regards, Sales department Tangram Canada Inc.     

@hoangnn90

✅Full Experience in Medical Data Analysis and Processing Automation with Python/SQL/Tableau Programming✅. ✳️I am very confident that complete your project perfectly. ✳️I can guarantee the quality of the job and deliver the result on time. I hope we will discuss in more detail via chat. Best regards!

@Feriver

Hello I understand you are looking for a principal-level data analyst with strong healthcare domain experience to optimize your clinical-trial analytics stack and deliver high-performance Tableau dashboards on BigQuery/Redshift. I will start by auditing your existing schema to identify bottlenecks in data modeling, partitioning, and clustering strategy. From there, I will refactor the data warehouse structure to ensure efficient query execution at scale, particularly focusing on clinical-trial KPI workloads. I will also implement optimized SQL patterns, materialized views where appropriate, and reusable transformation logic to reduce redundant computation. On the analytics layer, I will design and refine Tableau dashboards with a strong focus on usability for clinical stakeholders—ensuring fast load times, clean filter hierarchies, and reliable metric definitions. Python will be used for automation, data validation checks, and any advanced transformations that exceed SQL efficiency. Every component will be documented with clear schema definitions, grain-level clarity, and update logic. The final deliverable will include optimized SQL scripts, structured data models, Python utilities, and fully functional Tableau workbooks aligned with your acceptance criteria for performance and maintainability. Thanks, Asif

@emilesd617

Hi, I am a data analyst with 8 years of rich experience with a background in healthcare data systems. I am familiar with Python, SQL, BigQuery, Redshift, Tableau. For this project, the most important part is optimizing data models and queries so dashboards load fast and handle large clinical datasets efficiently. I will focus on partitioning, query tuning, and building clean Tableau dashboards with reliable data pipelines and documentation. This ensures fast performance and clear insights for clinical use. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.

@alizain721

Your note about the schema “straining under growing volume and new KPI requests” hits home — that’s usually where performance and clarity break down at the same time. Often the real issue isn’t a single slow query but missing partitioning/clustering, ambiguous join keys, and refresh patterns that force full-table scans. Fix those and dashboards become usable. I recently refactored BigQuery models for a multi-site oncology trial: added partitioning/clustering, rewrote the heaviest queries, and deployed Python DQ checks — dashboard loads dropped from minutes to under 5 seconds. I’d start with a targeted schema review to identify quick wins, implement partitioning/clustering and incremental loads, refactor the top 3 slow queries, add automated DQ and docs for grain/joins/update cadence, then tune Tableau (extracts vs live) for clinician UX. Quick question: what’s the largest table size (rows or GB) and are your current Tableau workbooks using extracts or live connections?

@Dtechonolgy

Drawing from my 9 years of experience in data analysis and ardent understanding of the specific domain of healthcare analytics that your project requires, I strongly believe our Full Stack AI Development Agency, Team Diligent, is well-equipped to provide the keen insights you're seeking. Our expertise in Google Cloud Platform, Amazon Redshift, and advanced SQL make us the ideal choice to optimize your growing clinical-trial datasets which will only get more imperative as time goes on. What sets us apart and makes us worthy of your trust is our unwavering commitment towards delivering high-performing platforms which drive real business outcomes. Whether it's improving schema models and introducing best-practice partitioning or clustering for your data warehouses or delving into complex queries leveraging Python to meet specific KPIs, rest assured we'll rise to the occasion each day. We understand your need for maximum efficiency and aim to translate all clinical trial requirements into scalable models within an acceptable timeframe. Notably, our 'hand-off package' passes a code walkthrough with zero critical findings ensuring seamless collaboration even post-implementation. So if you're on the lookout for a seasoned partner in this crucial stage of your clinical trial project, I urge you to reach out for a discussion on how we can not just meet but exceed your expectations. Let's take healthcare analytics to new heights together!

@mayankinnovative

Hi, As per my understanding: You need a data expert to optimize your clinical-trial data stack (BigQuery/Redshift), refactor schemas for performance, and deliver fast, intuitive Tableau dashboards. The focus is reducing query time, improving scalability, and ensuring clean, well-documented pipelines with ongoing collaboration. Implementation approach: I’ll begin with a performance audit of your current schema, queries, and workloads—identifying bottlenecks, inefficient joins, and scan-heavy tables. Then I’ll redesign key models using partitioning, clustering, and optimized indexing strategies (BigQuery/Redshift specific) to bring query times down significantly. SQL will be refactored into modular, documented layers (staging → marts) for clarity and speed. Python will be used for automated data-quality checks, anomaly detection, and scheduled transformations where needed. For Tableau, I’ll design high-performance dashboards using extracts or optimized live queries, applying caching and aggregation strategies to ensure sub-5s load times. Daily collaboration will focus on iterative improvements and quick troubleshooting. A few quick questions: 1. What is your current average query runtime and dataset size? 2. Are you using dbt or any transformation framework already? 3. Preference for Tableau live vs extract for core dashboards? 4. Any compliance constraints (HIPAA, etc.) impacting architecture?

@mobiwebsolutions

✋ Hi There!!! ✋ The Goal of the project:- Optimize healthcare data models and deliver high-performance clinical analytics dashboards with scalable SQL, Python automation, and Tableau reporting. I carefully read your complete requirement including BigQuery and Redshift optimization, clinical trial data modeling, query tuning, Python data-quality scripting, dashboard performance targets, and documentation handoff. I am the right fit because I bring strong experience in healthcare analytics, performance-focused data engineering, and decision-ready dashboard development. 1. Refactor data models with partitioning, clustering, database management, and advanced SQL performance tuning. 2. Build Tableau dashboards, Python automation scripts, testing workflows, and scalable KPI reporting solutions. 3. Deliver documented source code, data validation support, handoff package, and structured analytical implementation. With 9+ years experience as a full stack developer, I have completed similar healthcare analytics, BI dashboard, and large-scale data modeling projects successfully. Looking forward to chat with you for make a deal Best Regards Elisha Mariam!

@riogushiken1114

Hi there, ❤️❤️❤️ I’ve reviewed your clinical-trial analytics project and it aligns well with my experience in healthcare data warehousing, BigQuery/Redshift optimization, advanced SQL, Python automation, and Tableau performance tuning. I can help refactor your growing schema and deliver fast, clinician-friendly dashboards. **How I can help:** • Review existing BigQuery/Redshift models and improve partitioning, clustering, grain, joins, and update cadence documentation. • Optimize complex SQL and warehouse performance so key queries and dashboards meet your sub-minute and sub-five-second targets. • Build polished Tableau workbooks with the right live/extract strategy, plus Python checks for repeatable data quality and pipeline automation. **Relevant experience:** I’ve worked on healthcare analytics projects involving large datasets, scalable data models, KPI pipelines, SQL tuning, Python validation scripts, and Tableau dashboards, and I can start working immediately. **Approach:** I focus on measurable performance gains, clean hand-off packages, clear daily collaboration, and durable improvements your team can maintain. Best regards,

@Altantsetseg

Hello. My names is Alta and I m from Mongolia. From your project description, its kind of project I have been experienced well. I have master's degree in public health which was completed in Japan, and since then I have been working as a Data Scientist in a leading Bank in Mongolia. Overall, I have a full stack experience over 20+ years using Python, C#, SQL and queries. What you described in your requirement are very close what I currently do every day. Lets chat about detail requirements of your project. Hope to hear from you soon. Warm Regards, Alta

@carlosd178

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I have experience handling healthcare analytics and large-scale data warehouse optimization projects and I'm available to start your project right now. I bring deep expertise in BigQuery, Amazon Redshift, advanced SQL, Python, Tableau, Data Modeling, and Data Warehousing with over 10 years of experience. One of the key challenges here is reducing slow clinical-trial queries while keeping KPI logic accurate and easy to maintain. I would review the current schema, improve partitioning/clustering, optimize SQL models, add Python-based data quality checks, and build Tableau dashboards using extracts or live connections based on performance needs. I have a couple of quick questions. • Are the current Tableau dashboards using live connections, extracts, or both? • Do you already have documented KPI definitions and table grain for the clinical trial datasets? I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Best regards, Carlos.

@murtaza1981

Hi, I’ll turn your clinical datasets into fast, reliable insights—optimized BigQuery/Redshift models + Tableau dashboards that load in seconds. Rate: $30/hr | Capacity: 40 hrs/week ? Budget-First (Performance Fix + Dashboards) Timeline: ~3–4 weeks (120–160 hrs) Cost: ~$3,600–$4,800 Scope: Query tuning, partitioning/clustering, core KPI models, Tableau dashboards (<5s load), basic Python automation Best for: Immediate speed + usable insights ? Premium (Scalable Analytics Engine) Timeline: ~5–6 weeks (200–240 hrs) Cost: ~$6,000–$7,200 Scope: Advanced data modeling, caching strategy, optimized pipelines, high-performance Tableau (extract/live tuning), robust Python workflows, full documentation Best for: Long-term, production-grade analytics ? Milestones Audit + Optimization Plan – 20% Data Modeling + SQL Tuning – 35% Dashboards + Performance – 30% Automation + Handover – 15% ✔ <5s dashboards ✔ <1 min heavy queries ✔ Clean, documented models No guesswork—just fast, scalable, audit-ready analytics. Let’s make your data work at clinical speed. Thanks, Murtaza

@juanestebana17

Hello, With extensive experience in healthcare data analytics, I excel at transforming large clinical trial datasets into actionable insights through advanced SQL, Python, and Tableau visualization. I will optimize your existing data models on BigQuery and Redshift, ensuring speedy queries and efficient data handling. Could you share more about the current KPIs and any specific challenges you're facing with your existing models? Thanks, Juan Aponte

@adisonw

Dear Sir, I am thrilled to bid your project. I can help optimize your clinical-trial data stack from raw warehouse tables to fast, polished Tableau dashboards that clinicians can use without delay. I have experience with BigQuery, Redshift, advanced SQL, Python automation, data-quality checks, dashboard performance, and translating complex reporting requirements into clean analytical models. For your current schema, I would review table grain, joins, query patterns, KPI logic, bottlenecks, and storage design, then refactor models with proper partitioning, clustering, indexing strategy where applicable, and documented update cadence. On the dashboard side, I would design Tableau workbooks with performance in mind, choosing extracts or live connections based on data freshness needs, filter behaviour, and clinician workflow. I can also write repeatable Python checks for validation, anomaly detection, and pipeline support so data quality remains stable as volume and KPI requests grow. One crucial question: which KPIs or dashboards are currently the slowest or most business-critical for clinicians? That will help me prioritize optimization work around measurable impact, such as sub-five-second dashboard loads and under-one-minute analytical queries. Sincerely, Adison.

@johnedwardl

Hi, I will optimize your clinical-trial datasets for seamless integration with Tableau, ensuring performance and usability. With extensive experience in Google Cloud Platform, particularly BigQuery, and Amazon Redshift, I'm adept at refining complex SQL queries and enhancing warehouse performance to meet your growing KPI demands. My approach will include a comprehensive review of your existing schema, implementing best practices for partitioning and clustering to drastically reduce query times. I'll design intuitive Tableau dashboards that clinicians can navigate effortlessly, ensuring they load in under five seconds for standard filters. My background in Python will support any necessary automation and data wrangling, complementing the SQL solutions. To align our efforts, I propose daily check-ins to prioritize tasks, troubleshoot, and identify opportunities for optimization, ensuring we stay agile and responsive. Let’s connect and start transforming your data into actionable insights. Thank you.

@cindyviorinar

Hi there, I understand you're looking for a dedicated partner to refine your clinical trial data analytics with speed and precision. I'm Cindy Viorina, a seasoned data analyst with extensive experience in healthcare analytics and a strong proficiency in Google Cloud Platform, particularly BigQuery, and Amazon Redshift. I will start by assessing your existing schema to optimize it under the growing volume and evolving KPI requirements. My approach involves refactoring the models using best-practice techniques for partitioning and clustering, ensuring your queries run efficiently. After this, I will design user-friendly Tableau dashboards that clinicians can navigate seamlessly while ensuring performance remains top-notch. I thrive in collaborative environments, so I look forward to our daily check-ins to prioritize tasks and ensure we're addressing any bottlenecks promptly. I can provide a demo of my work within 12 hours of starting and am available for real-time communication based on your time zone. Q1: What specific KPIs do you envision needing for future reports? Q2: Are there any existing performance issues you want to prioritize? Q3: How frequently do you anticipate updates to the dashboards after deployment? Let's dive deeper into this project and make it a success! Best regards, Cindy Viorina