2C
Data Analyst
22nd Century Technologies, Inc.
- ๐บ๐ธ United States
- Hybrid
- Manager or above
- 9 hours ago
- Databricks
- PySpark
- Power BI
- Change Management
- SQL
- Machine Learning
- Data Visualization
9 hours ago
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
| Skills | Required | Required Experience | Candidate Experience | Last Used |
| Databricks and PySpark proficiency: hands-on experience working in the Databricks platform and using PySpark for data analysis and transformation. | Required | 5 | Years | |
| Advanced Spark SQL: the ability to write efficient, complex queries to analyze large datasets within Databricks. | Required | 5 | Years | |
| Data visualization and dashboarding:building clear, intuitive dashboards in Power BI and Databricks' native visualization tools to communicate insight | Required | 5 | Years | |
| Data mapping and modeling: developing detailed mappings that integrate and transform data | Required | 5 | Years | |
| Business requirements and stakeholder collaboration: gathering and developing business requirements | Required | 5 | Years | |
| Data quality and analysis: conducting thorough data analysis | Required | 5 | Years |
| Description | Questions | Answers |
| Question 1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? | |
| Question 2 | What is your candidate's email address? | |
| Question 3 | How soon can your candidate start if selected for this opportunity? | |
| Question 8 | Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the Vendor to adhere to any applicable compensation laws including payment for overtime hours. Do you agree to this requirement? | |
| Question 9 | Have you thoroughly validated, and attest to the accuracy of, the credentials listed throughout your candidate's VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440? |
Data Analyst ยท 22nd Century Technologies, Inc.