LanceSoft, Inc. · 14 hours ago
Analytics Analyst
LanceSoft, Inc. is seeking a Data Analytics Analyst 2 to join their team in Birmingham, AL. The role involves working with large datasets in a cloud-based environment, supporting enterprise reporting, and troubleshooting data quality issues.
Responsibilities
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
Writing and maintaining reusable, well-documented queries
Hands-on experience with Databricks, Azure Synapse, Snowflake, BigQuery, or similar
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
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
Experience specifically with Microsoft Azure ecosystem
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
Qualification
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)
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
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
LanceSoft, Inc.
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele.
H1B Sponsorship
LanceSoft, Inc. 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 (55)
2024 (32)
2023 (23)
2022 (25)
2021 (60)
2020 (80)
Funding
Current Stage
Late StageCompany data provided by crunchbase