NCDIT - Data Analyst

OST Workforce; Wake Forest (NC); Hybrid; USD 60,000 - 90,000; Full time

Job summary

OST Workforce is seeking a Data Analyst for a hybrid role near Wake Forest, NC. The position involves hands-on Databricks (PySpark) work, creating dashboards, and ensuring data quality while aligning data solutions with business needs.

You will collaborate with a technical lead and stakeholders to support design discussions and planning with the broader development team. The ideal candidate has experience with Spark SQL, Power BI, and Databricks visualization tools, and can translate complex

Qualifications

• Proficient in Databricks PySpark for data analysis and transformation.
• Advanced Spark SQL for large dataset queries.
• Experience building dashboards with Power BI and Databricks visuals.
• Strong data mapping and modeling capabilities.
• Ability to gather business requirements and collaborate with stakeholders.
• Focus on data quality and thorough analysis.

Responsibilities

• Analyze data, create mappings, develop dashboards, ensure data quality.
• Query large datasets using Spark SQL in Databricks.
• Collaborate with data engineers to design data products.
• Create data mappings for data integration and transformation.
• Build dashboards using Power BI and Databricks visuals.
• Document data pipelines, mappings, models, and dashboards.
• Apply statistical analysis, data mining, and ML to uncover insights.

Skills

Databricks PySpark

Spark SQL

Statistical analysis

Data mining

Machine learning

Data quality

Stakeholder collaboration

Business requirements

Tools

Databricks

Power BI

Job description

Data Analyst

This is a hybrid position. The manager is unsure how often he will need the contractor onsite, but the maximum requirement would be three days a week on Tuesday, Wednesday, and Thursday.

The ideal candidate will have hands‑on expertise with Databricks (PySpark) and visualization tools, including both Databricks native tools and Power BI. In this role, you will be responsible for developing business requirements, supporting change management documentation, and actively collaborating with stakeholders to ensure alignment between data solutions and business needs. You will work closely with a technical lead and participate in design discussions and planning with the broader development team.

Key Responsibilities

Conduct comprehensive data analysis, create data mappings, develop dashboards, and ensure data quality and integrity

• Leverage Spark SQL within Databricks to query and analyze large datasets, writing efficient and complex SQL queries
• Collaborate closely with data engineers to design and deliver high-quality data products
• Develop detailed data mappings to support the integration and transformation of data from diverse sources into structured, analysis-ready formats
• Design and build intuitive, informative dashboards using tools such as Power BI or Databricks' native visualization tools to effectively communicate insights
• Build Gold-layer data products to support custom-built dashboards, APIs, and UI tools
• Create clear and comprehensive documentation for data pipelines, mappings, models, and dashboard functionality
• Perform statistical analysis, data mining, and machine learning to uncover patterns, trends, and actionable insights

Required/Desired Skills

SkillRequired /DesiredAmountof Experience

• Databricks and PySpark proficiency: hands‑on experience working in the Databricks platform and using PySpark for data analysis and transformation. Required5Years
• Advanced Spark SQL: the ability to write efficient, complex queries to analyze large datasets within Databricks. Required5Years
• Data visualization and dashboarding: building clear, intuitive dashboards in Power BI and Databricks native visualization tools to communicate insight. Required5Years
• Data mapping and modeling: developing detailed mappings that integrate and transform data. Required5Years
• Business requirements and stakeholder collaboration: gathering and developing business requirements. Required5Years
• Data quality and analysis: conducting thorough data analysis. Required5Years