Sophinea Corporation Logo

Sophinea Corporation

Senior Data Analytics Engineer

Reposted Yesterday
Remote
Hiring Remotely in United States
Expert/Leader
Remote
Hiring Remotely in United States
Expert/Leader
You will design, implement, and maintain ETL processes, ensuring data quality while providing insights to drive business growth and support decision-making.
The summary above was generated by AI
Description

Position Overview:

As a Senior ETL Operations and Data Analytics Engineer, you will play a crucial role in our data-driven decision-making process. You will be responsible for designing, implementing, and maintaining ETL processes, ensuring data accuracy, and providing valuable insights to drive business growth.

Key Responsibilities:

  • Design, develop, and maintain ETL processes to extract, transform, and load data from various sources.
  • Monitor and optimize ETL workflows to ensure data quality and performance.
  • Collaborate with cross-functional teams to gather and understand data requirements.
  • Optimize and tune ETL processes for performance and scalability.
  • Create and maintain documentation for ETL processes and data analytics solutions.
  • Create and maintain data models to support reporting and analysis needs.
  • Utilize expert knowledge of Go, Python, SQL, git, JSON, YAML, CSV, and MS Excel
  • Working knowledge and experience with Ruby, Bash, Argo CD/Workflow, Kubernetes (K8s), containers, GitHub actions, Linux, and AWS to enhance data operations.
  • Collaborate with DevOps teams to deploy ETL solutions efficiently in a Kubernetes environment using CI/CD pipelines.
  • Support and troubleshoot ETL processes and resolve any issues in a timely manner.
  • Perform data analysis, develop dashboards, and present actionable insights to stakeholders.
Requirements
  • Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
  • Minimum of 10 years of experience in ETL operations, Systems Operations, and Data Analytics.
  • Expert knowledge of SQL, git, various data formats (JSON, YAML, csv), and MS Excel.
  • Expert Python and Bash skills including OO techniques.
  • Proficiency in Ruby, Go, and other languages is a plus.
  • Familiarity with Argo CD/Workflow, Kubernetes (K8s), containers, GitHub ac0ons, Linux, and AWS is highly desirable.
  • Strong problem-solving skills and attention to detail.
  • Excellent communication and collaboration skills.
  • Ability to work independently and as part of a team.
  • Strong proficiency in SQL and experience with MySQL or similar relational databases.
  • Must be able to interact with databases using raw-SQL.
  • Solid understanding of data modeling concepts and techniques.
  • Experience with Jaspersob or similar reporting tools is preferred.

Desired:

  • Familiarity with ELK (Elasticsearch, Logstash, Kibana) or OpenSearch for advanced log and data analysis
  • Familiarity with Jasper Reports and BIRT
  • Familiarity with Apache Kafka for real-time data streaming and event-driven architectures
  • Experience with relational databases such as PostgreSQL and MySQL for handling structured data
  • Knowledge of Druid, an open-source analytics data store, and its integration into data pipelines
  • Proficiency in Apache Superset for creating interactive and insightful data visualizations
Benefits
  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k, IRA)
  • Life Insurance (Basic, Voluntary & AD&D)
  • Paid Time Off (Vacation, Sick & Public Holidays)
  • Short Term & Long Term Disability
  • Training & Development
  • Work From Home

Top Skills

Apache Kafka
Apache Superset
Argo Cd
AWS
Bash
Containers
Csv
Druid
Git
Github Actions
Go
JSON
Kubernetes
Linux
Excel
MySQL
Postgres
Python
Ruby
SQL
Yaml

Similar Jobs

2 Days Ago
Easy Apply
Remote or Hybrid
USA
Easy Apply
145K-190K
Mid level
145K-190K
Mid level
Food • Software
As a Senior Data Analytics Engineer, you'll manage ChowNow's data platform, build tools for data insights, and collaborate with teams to enhance data availability and accuracy.
Top Skills: AWSDbtPythonSigma ComputingSnowflakeSQLTableau
10 Days Ago
Remote
United States
120K-145K Annually
Mid level
120K-145K Annually
Mid level
Insurance • Financial Services
The Senior Python Developer will write maintainable Python code, debug data issues, and collaborate with cross-functional teams to create data solutions that improve efficiency and meet business needs.
Top Skills: GitPythonSQL
4 Days Ago
Remote
USA
Senior level
Senior level
Cloud • Information Technology • Software
The Senior Software Engineer (Data Analytics) will develop and maintain data analytics services, support data management, and design data visualizations using various technologies.
Top Skills: Apache ParquetAws AthenaAws LambdaAws QuicksightCloudFormationCloudwatchElastic Container ServiceElasticsearchFargateGitGlueGoogle AnalyticsKibanaKinesisNode.jsPythonS3SqsStep FunctionsTerraform

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account