Data Engineer Job at California Creative Solutions Inc., Remote

V1lqUy9yRUoyOFdpTk5SZXNqRk9adHZ3akE9PQ==
  • California Creative Solutions Inc.
  • Remote

Job Description

Position Overview:

We are looking for an experienced Data Engineer with a strong foundation in data engineering best practices and experience with modern data warehousing and ETL platforms. The ideal candidate will have at least 5 years of hands-on experience, preferably with Snowflake, SQL Server, AWS, and Matillion ETL, to build, optimize, and maintain data pipelines and data integration solutions. This role involves working closely with cross-functional teams to support data-driven initiatives across the organization.

SKILLS:

Matillion, Snowflake, SQL, AWS Cloud

Required Qualifications:
  • Experience: At least 5 years of experience in data engineering, with proficiency in Snowflake, SQL Server, AWS and ETL tools (preferably Matillion).

  • Technical Skills: Strong SQL and Python skills with experience in query optimization and performance tuning.

  • Education: Bachelor's degree in Computer Science, Information Technology, or a related field.

  • Soft Skills: Strong analytical, problem-solving, and communication skills.

  • Data Engineering Skills: Experience in building, maintaining, and optimizing data pipelines and ETL processes.

  • Data Modeling: Knowledge of data warehousing concepts and hands-on experience in data modeling, particularly within Snowflake.

Preferred Qualifications:
  • Additional Tools and Platforms: Experience with additional ETL tools, data transformation methods, or cloud platforms is a plus.

  • Healthcare and PBM: PBM-specific knowledge and experience with transforming various healthcare data is a plus, but not required.

Key Responsibilities: Data Pipeline Development and Maintenance:
  • Design, develop, and maintain scalable and high-performance ETL pipelines using Matillion ETL to ingest, transform, and load data into Snowflake.

  • Integrate and manage data from various sources, ensuring data quality, reliability, and performance.

  • Optimize SQL queries, scripts, and stored procedures in Snowflake and SQL Server to improve efficiency and reduce processing time.

Data Warehousing and Modeling:
  • Develop and implement data models within Snowflake to support business intelligence and analytics requirements.

  • Collaborate with data architects and analysts to design and enhance data warehouse schemas and ensure alignment with reporting and analytics needs.

Collaboration and Requirements Gathering:
  • Work with business stakeholders to understand data requirements and translate them into technical specifications.

  • Support data architects and analysts by guiding data ingestion, storage, and retrieval methods.

Platform Monitoring and Optimization:
  • Monitor data pipeline and ETL performance, identifying bottlenecks and making necessary adjustments to ensure optimal system performance.

  • Perform troubleshooting and root cause analysis to resolve data issues and prevent future occurrences.

Job Tags

Full time, Part time, Seasonal work,

Similar Jobs

Love's Travel Stops & Country Stores

General Manager - Restaurant Job at Love's Travel Stops & Country Stores

 ...Development * Quarterly Bonus Program * Hiring Immediately * Profit Sharing - Loves Shares Welcome to Loves! Restaurant General Managers play a key role in ensuring the smooth and efficient operation of our high-volume, multifaceted restaurants and fresh... 

MAU Workforce Solutions

Interviewer Job at MAU Workforce Solutions

MAU is hiring an Interviewer in Anderson, SC. As an Interviewer, you will conduct in-depth interviews with candidates to assess qualifications...  ...~Conduct one-on-one interviews with candidates (in-person, phone, virtual)~Review and evaluate resumes, applications, and assessments... 

Robeson County

Director, Board of Elections Job at Robeson County

 ...at (***) ***-**** or by email ****@*****.***. We are an equal opportunity employer: Robeson County Local Government considers applicants on the basis of qualifications and without regard to race, color, religion, sex, national origin, age,... 

Addison Kenway.

Dermatology Physician - Dermatologist Job at Addison Kenway.

Fresh Meadows, NY Dermatologist Job#16665984 Our client has a full time opening for a dermatologist. Opportunity is due to growth. Full or part time position with a flexible schedule. Enjoy competitive compensation , major benefits malpractice, 401K, life insurance, ...

Rivian

Technical Trades Technician Job at Rivian

 ...Rivianis on a mission to keep the world adventurous forever. This goes for the emissions...  ...Role Summary Our Rivian Technical Trades Program is a pathway to grow our Field Service...  ...hands-on training at a Rivian Service center and receive exclusive instructional...