Data Consultant USA - Remote

Particle41; Northern (KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Particle41 is seeking a Data Consultant to design, build, and maintain scalable data pipelines and infrastructure for diverse client needs. You will collaborate with cross-functional teams to deliver end-to-end data solutions, ensuring high-quality, scalable data delivery.

The role emphasizes hands-on ETL development, data modeling, and cloud-based data engineering across AWS/Azure/GCP, with a focus on data accuracy and robust testing.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or related field.
• 3+ years of experience as a Data Engineer or Data Consultant.
• Proficiency in Python programming language.
• Experience with SQL (MySQL, PostgreSQL) and NoSQL (MongoDB) databases.
• Strong understanding of data warehousing/lakehouse concepts and ETL/ELT pipelines.
• Familiarity with cloud data engineering stacks (Azure, AWS, or GCP).
• Version control with Git and collaborative workflows.
• Linux OS experience and shell scripting.
• Excellent problem-solving and communication skills.

Responsibilities

• Design, build, and maintain scalable ETL pipelines processing large data volumes from diverse sources.
• Create and optimize data storage solutions (data lakes, data warehouses) for efficient retrieval.
• Integrate structured and unstructured data into unified analytical views.
• Ensure data accuracy, consistency, and quality through validation and cleansing.
• Maintain documentation for data processes and promote best practices.

Skills

Python

SQL

NoSQL

ETL

Data Warehousing

Cloud Platforms

Git

Linux

APIs

Spark/PySpark

Pandas

Education

Bachelor's degree in Computer Science/Engineering

Tools

Flask

API frameworks

ORM

Databricks

Spark

Open Source Tools

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.
• 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.
• 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.

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.

This is specifically for USA location only.