Data Analytics Analyst 2 jobs in United States
info-icon
This job has closed.
company-logo

Mindlance · 3 hours ago

Data Analytics Analyst 2

Mindlance is a company that specializes in staffing and consulting services, and they are seeking a Data Analytics Analyst 2. The role involves analyzing complex datasets, supporting enterprise reporting and dashboards, and ensuring data quality in a cloud-based environment.

Human Resources
check
H1B Sponsor Likelynote

Responsibilities

All applicants required to complete QuantHub skills assessment: please use below link and access code
Job is posted as "on site" but will have option for 1 remote work day per week
Experience • 3-5 years of professional experience in data analytics, business intelligence, or a related role • Proven experience working with large, complex datasets in a cloud-based environment • Experience supporting enterprise reporting, dashboards, and analytics products • Demonstrated experience troubleshooting data quality, pipeline, or ingestion issues
Technical Skills & Languages • Advanced SQL (required) o Complex joins, CTEs, window functions, performance optimization o Writing and maintaining reusable, well-documented queries • Cloud data platforms o Hands-on experience with Databricks, Azure Synapse, Snowflake, BigQuery, or similar o Understanding of how data moves from source systems into cloud storage and analytics layers • Data modeling & transformation o Experience structuring data for analytics (fact/dimension models, wide vs. narrow tables, etc.) o Ability to prepare data optimized for visualization and dashboard consumption • Data quality & validation o Ability to identify discrepancies between source systems and cloud datasets o Experience facilitating root-cause analysis and coordinating resolution across teams
Analytics & Visualization • Experience supporting dashboards and reports using tools such as: o Power BI, Tableau, or similar enterprise BI platforms • Strong understanding of how data structure impacts visualization performance and usability
Soft Skills & Work Style • Strong analytical and problem-solving skills • Ability to work independently while collaborating with data engineers and internal SMEs • Clear written and verbal communication, especially when explaining data issues or findings • Experience prioritizing work across multiple data requests and investigations
Preferred Qualifications • Experience with data visualization (Power BI) is a plus
Technical Preferences • Experience specifically with Microsoft Azure ecosystem o Azure Data Factory, Azure SQL, ADLS • Experience with PySpark or Python for data analysis and transformations • Familiarity with ETL / ELT pipelines and orchestration concepts • Experience with version control (Git or similar) • Basic understanding of data governance, lineage, or metadata management
Domain & Business Experience • Experience in utilities, energy, infrastructure, or regulated industries • Familiarity with operational, asset, or time-series data • Experience working with imperfect or operational source systems
Professional Attributes • Experience mentoring junior analysts or providing technical guidance • Ability to translate business questions into efficient analytical datasets • Demonstrated attention to detail with a strong focus on data accuracy

Qualification

Advanced SQLCloud data platformsData modeling & transformationData quality & validationPower BITableauPythonETL / ELT pipelinesAnalytical skillsProblem-solving skillsClear communicationAttention to detail

Required

3-5 years of professional experience in data analytics, business intelligence, or a related role
Proven experience working with large, complex datasets in a cloud-based environment
Experience supporting enterprise reporting, dashboards, and analytics products
Demonstrated experience troubleshooting data quality, pipeline, or ingestion issues
Advanced SQL (required)
Complex joins, CTEs, window functions, performance optimization
Writing and maintaining reusable, well-documented queries
Hands-on experience with Databricks, Azure Synapse, Snowflake, BigQuery, or similar
Understanding of how data moves from source systems into cloud storage and analytics layers
Experience structuring data for analytics (fact/dimension models, wide vs. narrow tables, etc.)
Ability to prepare data optimized for visualization and dashboard consumption
Ability to identify discrepancies between source systems and cloud datasets
Experience facilitating root-cause analysis and coordinating resolution across teams
Experience supporting dashboards and reports using tools such as: Power BI, Tableau, or similar enterprise BI platforms
Strong understanding of how data structure impacts visualization performance and usability
Strong analytical and problem-solving skills
Ability to work independently while collaborating with data engineers and internal SMEs
Clear written and verbal communication, especially when explaining data issues or findings
Experience prioritizing work across multiple data requests and investigations

Preferred

Experience with data visualization (Power BI) is a plus
Experience specifically with Microsoft Azure ecosystem
Azure Data Factory, Azure SQL, ADLS
Experience with PySpark or Python for data analysis and transformations
Familiarity with ETL / ELT pipelines and orchestration concepts
Experience with version control (Git or similar)
Basic understanding of data governance, lineage, or metadata management
Experience in utilities, energy, infrastructure, or regulated industries
Familiarity with operational, asset, or time-series data
Experience working with imperfect or operational source systems
Experience mentoring junior analysts or providing technical guidance
Ability to translate business questions into efficient analytical datasets
Demonstrated attention to detail with a strong focus on data accuracy

Company

Mindlance

company-logo
Mindlance is a Staffing and Recruiting company which provides multi-vertical staffing services

H1B Sponsorship

Mindlance has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (71)
2024 (53)
2023 (37)
2022 (72)
2021 (36)
2020 (40)

Funding

Current Stage
Late Stage

Leadership Team

R
Rajat Paul Dhall
Co-Founder & Managing Director
linkedin
V
Vik Kalra
Co-Founder and Managing Director
linkedin
Company data provided by crunchbase