Data Consultant

Particle41; New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Particle41 is seeking a versatile Data Consultant to design, build, and maintain data pipelines and infrastructure for client data needs in the United States. You will work end-to-end on data solutions, collaborating with cross-functional teams to deliver high-quality, scalable data delivery.

The role emphasizes designing ETL pipelines, data storage optimization, data integration, validation, and documentation while staying current with best practices and cloud platforms.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or related field.
• Proven experience as a Data Engineer/Consultant with 3+ years.
• Proficiency in Python.
• Experience with SQL and NoSQL databases.
• Strong understanding of data warehousing, data lakes, and ETL.
• Familiarity with cloud data platforms (AWS, Azure, or GCP).

Responsibilities

• Design, develop, and maintain scalable ETL pipelines to process large data volumes from diverse sources.
• Build and optimize data storage solutions, such as data lakes and data warehouses, for efficient data retrieval.
• Integrate structured and unstructured data from various systems to create a unified view for analysis.
• Ensure data accuracy, consistency, and completeness through validation and cleansing processes.
• Maintain documentation for data processes, tools, and systems and promote best practices for workflows.

Skills

Python

SQL

NoSQL

Data warehousing

Flask

Pandas

Spark

Pyspark

Machine learning

OpenCV

scikit-learn

Git

Linux

Shell scripting

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

ELK stack

Redis

Distributed task queues

Git

Shell scripting

Job description

Particle41 is seeking a talented and versatile Data Consultant to join our innovative team. As a Data Consultant, you will play a key role in designing, building, and maintaining robust data pipelines and infrastructure to support our clients' data needs. You will work on end-to-end data solutions, collaborating with cross-functional teams to ensure high-quality, scalable, and efficient data delivery. This is an exciting opportunity to contribute to impactful projects, solve complex data challenges, and grow your skills in a supportive and dynamic environment.

In This Role, You Will:

• Design, develop, and maintain scalable ETL (Extract, Transform, Load) pipelines to process large volumes of data from diverse sources.


• Build and optimize data storage solutions, such as data lakes and data warehouses, to ensure efficient data retrieval and processing.


• Integrate structured and unstructured data from various internal and external systems to create a unified view for analysis.


• Ensure data accuracy, consistency, and completeness through rigorous validation, cleansing, and transformation processes.


• Maintain comprehensive documentation for data processes, tools, and systems while promoting best practices for efficient workflows.

Requirements Gathering and Analysis

• Collaborate with product managers, and other stakeholders to gather requirements and translate them into technical solutions.


• Participate in requirement analysis sessions to understand business needs and user requirements.


• Provide technical insights and recommendations during the requirements-gathering process.

Agile Development

• Participate in Agile development processes, including sprint planning, daily stand-ups, and sprint reviews.


• Work closely with Agile teams to deliver software solutions on time and within scope.


• Adapt to changing priorities and requirements in a fast-paced Agile environment.

Testing and Debugging

• Conduct thorough testing and debugging to ensure the reliability, security, and performance of applications.


• Write unit tests and validate the functionality of developed features and individual elements.


• Writing integration tests to ensure different elements within a given application function as intended and meet desired requirements.


• Identify and resolve software defects, code smells, and performance bottlenecks.

Continuous Learning and Innovation

• Stay updated with the latest technologies and trends in full-stack development.


• Propose innovative solutions to improve the performance, security, scalability, and maintainability of applications.


• Continuously seek opportunities to optimize and refactor existing codebase for better efficiency.


• Stay up-to-date with cloud platforms such as AWS, Azure, or Google Cloud Platform.

Collaboration

• Collaborate effectively with cross-functional teams, including testers, and product managers.


• Foster a collaborative and inclusive work environment where ideas are shared and valued.

Skills and Experience We Value:

• Bachelor's degree in Computer Science, Engineering, or related field.


• Proven experience as a Data Engineering, with over of 3 years of experience.


• Proficiency in Python programming language.


• Experience with database technologies such as SQL (\"e.g., MySQL, PostgreSQL\") and NoSQL (\"e.g., MongoDB\") databases.


• Strong understanding of Programming Libraries/Frameworks and technologies such as Flask, API frameworks, datawarehousing/lakehouse, principles, database and ORM, data analysis databricks, panda's, Spark, Pyspark, Machine learning, OpenCV, scikit-learn.


• Utilities & Tools: logging, requests, subprocess, regex, pytest


• ELK stack, Redis, distributed task queues


• Strong understanding of data warehousing/lakehousing principles and concurrent/parallel processing concepts.


• Familiarity with at least one cloud data engineering stack (Azure, AWS, or GCP) and the ability to quickly learn and adapt to new ETL/ELT tools across various cloud providers.


• Familiarity with version control systems like Git and collaborative development workflows.


• Competence in working on Linux OS and creating shell scripts.


• Solid understanding of software engineering principles, design patterns, and best practices.


• Excellent problem-solving and analytical skills, with a keen attention to detail.


• Effective communication skills, both written and verbal, and the ability to collaborate in a team environment.


• Adaptability and willingness to learn new technologies and tools as needed.

About Particle41

Our core values of Empowering, Leadership, Innovation, Teamwork, and Excellence drive everything we do to achieve the ultimate outcomes for our clients. Empowering Leadership for Innovation in Teamwork with Excellence ( ELITE )

• E - Empowering: Enabling individuals to reach their full potential.


• L - Leadership: Taking initiative and guiding each other toward success.


• I - Innovation: Embracing creativity and new ideas to stay ahead.


• T - Teamwork: Collaborating with empathy to achieve common goals.


• E - Excellence: Striving for the highest quality in everything we do.

We seek team members who embody these values and are committed to contributing to our mission. Particle41 welcomes individuals from all backgrounds who are committed to our mission and values. We provide equal employment opportunities to all employees and applicants, ensuring that hiring and employment decisions are based on merit and qualifications without discrimination based on race, color, religion, caste, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, local, or international laws. This policy applies to all aspects of employment and hiring.

We appreciate your interest and encourage applicants from these regions to apply. If you need any assistance during the application or interview process, please feel free to reach out to us at [e-mail]. This is specifically for USA location only.