In this role, you will design and maintain ETL processes, collaborate with teams for data insights, and utilize various programming tools to enhance operations.
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
Argo Cd
AWS
Bash
Containers
Csv
Git
Github Actions
Go
JSON
Kubernetes
Linux
Excel
Python
Ruby
SQL
Yaml
Similar Jobs
Other • Real Estate • PropTech
The role involves creating dashboards and visual frameworks, building data pipelines, performing analyses to uncover insights, and communicating findings to stakeholders.
Top Skills:
AirflowDatabricksDbtGoogle App ScriptLookerNode.jsPlotlyPythonRedshiftSnowflakeSparkSQLTableau
Healthtech
The Senior Manager will lead the development of data operations, focusing on building a data warehouse, managing data quality, and supporting analytics initiatives.
Top Skills:
AthenaAWSDbtDuckdbGitPythonQuicksightRedshiftS3SagemakerSnowflakeSQL
Artificial Intelligence • Cloud • Information Technology • Database • Analytics • Consulting • Cybersecurity
The Senior Data Analytics Engineer analyzes, develops, and delivers business intelligence solutions, builds and maintains databases, and collaborates with clients to meet business needs.
Top Skills:
Azure Data FactoryAzure DatabricksAzure SynapseFabricMicrosoft Analytics StackPythonSQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
