Data Engineer III
| Company | Energy Solutions |
|---|---|
| Location | Boston, MA, USA, Orange, CA, USA, Oakland, CA, USA, Chicago, IL, USA, Portland, OR, USA |
| Salary | $120000 – $145000 |
| Type | Full-Time |
| Degrees | Bachelor’s, Master’s |
| Experience Level | Senior |
Requirements
- A bachelor’s degree in computer science or information technology and 6 years of relevant experience, or a master’s degree in a related field.
- High proficiency in programming languages commonly used in ETL development, such as PLSQL, SQL, and Python.
- Expertise in utilizing AWS services, including but not limited to Amazon s3, glue, data catalog, Amazon redshift, redshift spectrum, and Amazon Athena.
- Proficiency in working with relational databases such as Postgres, Oracle, MySQL, or SQL Server.
- Experience in performance tuning and optimizing database operations.
- Familiarity with data governance frameworks and data security best practices.
- Passion for learning new technologies, staying up to date with industry trends, and exploring innovative approaches to ETL development.
Responsibilities
- Architecting and Optimizing ETL Pipelines: Design, implement, and optimize scalable ETL processes using industry-leading tools and technologies. Ensure data integrity, consistency, and efficiency while handling complex transformations and large-scale data ingestion.
- Enterprise Data Modeling & Database Architecture: Develop and refine enterprise-level data models and database architectures for optimal storage, retrieval, and analytics. Leverage best practices in normalization, denormalization, and dimensional modeling to support high-performance data ecosystems.
- Advanced Performance Optimization & Scalability: Identify and resolve performance bottlenecks across ETL pipelines, database operations, and distributed systems. Implement advanced tuning strategies, indexing, partitioning, and caching mechanisms to enhance query efficiency and system throughput.
Preferred Qualifications
-
No preferred qualifications provided.