EnergySolutions

Senior Data Engineer

EnergySolutions

full-time

Posted on:

Location Type: Hybrid

Location: Orange • United States

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 $140,000 - $165,000 per year

Job Level

Senior

Tech Stack

Amazon RedshiftAWSCloudETLMySQLNoSQLOraclePostgresPythonSQL

About the role

  • Build, automate, and manage near-real-time scalable data ingestion pipelines for master data management, deep-learning, and predictive analytics
  • Build and maintain cloud native big data environments on AWS, that are highly secure, scalable, flexible, and highly performant using appropriate SQL, NoSQL and NewSQL technologies
  • Lead data governance and data profiling efforts to ensure data quality and proper metadata documentation for data lineage
  • Provide technical input into build/buy/partner decisions for all components of the data infrastructure
  • Partner closely with Data Scientists, BI developers, and Product Managers to design and implement data models, database schemas, data structures, and processing logic
  • Design and develop ETL (extract-transform-load) processes to validate and transform data, calculate metrics, and model features
  • Lead by example, demonstrating best practices for code development and optimization, unit testing, CI/CD, performance testing
  • Define SLAs for data availability and correctness
  • Communicate progress across organizations and levels from individual contributor to executive

Requirements

  • A bachelor’s degree in computer science or information technology plus 8 years minimum of relevant experience
  • High proficiency in programming languages commonly used in ETL development, such as PLSQL, SQL, 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
  • 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
Benefits
  • generous retirement package
  • excellent benefits package including medical, dental and vision insurance
  • other pre-tax contribution plans
  • Employee Stock Ownership Plan (ESOP)

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
ETLPLSQLSQLPythondata modelingdata structuresdata profilingdata qualityperformance testingunit testing
Soft skills
leadershipcommunicationcollaborationproblem-solvingadaptabilitytechnical inputbest practicesinnovationprogress reportingdata governance
Certifications
Bachelor's degree in Computer ScienceBachelor's degree in Information Technology