Dieses Stellenangebot ist nicht mehr verfügbar
Über
9 - 13 Years Location: Dallas, Texas,
Onsite Role:
Only W2
Interview: Need to come to office for F2F round and 3 Days work from office once selected.
We are looking for a highly technical and hands-on
Lead Data Analyst
to lead complex analytical initiatives, design scalable data solutions, and drive enterprise-level reporting and insights. This role requires deep expertise in SQL, data modeling, performance optimization, cloud analytics platforms, and advanced statistical analysis.
Key Responsibilities Design, develop, and optimize complex SQL queries (CTEs, window functions, subqueries, indexing strategies, query tuning) across large-scale relational databases Develop scalable data models (star/snowflake schemas), data marts, and semantic layers for enterprise reporting Lead end-to-end analytics lifecycle: requirement gathering → data extraction → transformation → modeling → visualization → stakeholder presentation Build advanced dashboards and executive-level reporting using Tableau, Power BI, or similar BI platforms Perform deep data profiling, validation, reconciliation, and root cause analysis Develop automated ETL/ELT pipelines in collaboration with data engineering teams Analyze structured and semi-structured datasets (JSON, logs, APIs) Conduct advanced statistical analysis, forecasting, segmentation, cohort analysis, and KPI development Implement data governance, quality checks, and audit controls Optimize performance of BI dashboards and underlying queries Work with cloud data warehouses (Snowflake, Redshift, BigQuery, Synapse) Support real-time and batch reporting use cases Translate complex business requirements into technical data specifications
Technical Skills Required Programming & Querying Advanced SQL (performance tuning, indexing, partitioning, execution plans) Python (Pandas, NumPy, SciPy) for data analysis and automation Experience with stored procedures, functions, views
Data Warehousing & Modeling Dimensional modeling (Kimball methodology) Fact/dimension design Slowly Changing Dimensions (SCD) Data normalization/denormalization
BI & Visualization Tableau (calculated fields, LOD expressions, parameters) Power BI (DAX, Power Query, data modeling) Dashboard optimization and storytelling with data
Cloud & Big Data AWS (Redshift, S3, Athena, Glue) Azure (Synapse, Data Factory) GCP (BigQuery) Experience working with large datasets (millions/billions of rows)
Preferred Experience Experience in regulated industries (Healthcare, Finance, Supply Chain) Exposure to ML model outputs and feature engineering CI/CD basics for analytics deployments API integrations and data ingestion automation
Qualifications 9 - 15 years of hands-on data analytics experience Bachelor’s/master’s in computer science, Data Science, Statistics, or related field
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.