NCDIT - Data Analyst

Software Technology Inc; Wake Forest (NC); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Software Technology Inc. is seeking a Data Analyst for a hybrid role in Wake Forest, NC. You will conduct comprehensive data analysis, build dashboards, and ensure data quality across diverse sources.

You will leverage Databricks with PySpark, create Power BI dashboards, and collaborate with data engineers to produce reliable data products. Strong emphasis on data mapping, ML insights, and clear documentation.

Qualifications

• Hands-on Databricks and PySpark for data analysis and transformation.
• Advanced Spark SQL for large datasets.
• Clear data visualization and dashboarding in Power BI or Databricks visuals.
• Detailed data mappings to integrate sources and transform data.
• Gather and translate business requirements with stakeholders.
• Thorough data quality analysis.

Responsibilities

• Leverage Spark SQL in Databricks to query and analyze large datasets.
• Collaborate with data engineers to design high-quality data products.
• Develop detailed data mappings for data integration and transformation.
• Design dashboards using Power BI or Databricks visuals to communicate insights.
• Build Gold-layer data products for dashboards, APIs, and UI tools.
• Document data pipelines, mappings, models, and dashboards functionality.
• Perform statistical analysis, data mining, and ML to uncover insights.

Skills

Databricks PySpark

Spark SQL

Data viz & dashboards

Data mapping & modeling

Business requirements

Data quality

Tools

Databricks

PySpark

Power BI

Visualization tools

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.

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

• 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 insightRequired5Years
• Data mapping and modeling: developing detailed mappings that integrate and transform dataRequired5Years
• Business requirements and stakeholder collaboration: gathering and developing business requirementsRequired5Years
• Data quality and analysis: conducting thorough data analysisRequired5Years