Careerlink Login
Back to Search New Search

Data Engineer

Pacific Life Insurance Company Lynchburg, VA

Job Description

Pacific Life is embarking on a multi-year initiative to invest in dynamic people and technology, ensuring a bright future for our customers and community. To support this process, we are looking for a skilled Database Management Consultant to join our team in Virginia.

As Database Management Consultant, youllplay a key role in Pacific Lifes digital and workplace transformation, working directly with Business Process Owners to deliver data products in a collaborative environment. Youll also design, build and maintain processes and components of a streaming data pipeline to support analytics, while focusing on data quality and performance tuning of Data Environments.
If yourea self-starter whos comfortable with ambiguity, technically-minded, with strong communication and analytical skills, youre precisely who were seeking. 
What Youll Do
  • Lead on-shore/off-shore resources to execute on multiple efforts
  • Provide technical direction to execution teams and drive the solution delivery
  • Develop compelling PoCs for data solutions using emerging technologies for real-time and big data ingestion and processing
  • Design, build, and maintain processes and components of a streaming data/ETL pipeline to support real-time analytics (from requirements to data transformation, data modeling, metric definition, reporting, etc.)
  • Focus on data quality - detect data/analytics quality issues all the way down to root cause, and implement fixes and data audits to prevent/capture such issues
  • Collaborate with data scientists to design and develop processes to further business unit and company-wide data science initiatives on a common data platform
  • Align with the systems engineering team to propose and deploy new hardware and software environments required and expand existing environments
  • Diligently team with the infrastructure, network, database, application and business intelligence teams to guarantee high data quality and availability
Tech & Tools Youll Use 
SQL, NoSQL databases (Cassandra, HBase, Mongo), data warehouses (Greenplum, Snowflake, Redshift), Python, informatica, Snowflake, SQL Server, Python, Powershell and SSIS  
  • Bachelor's in Computer Science or related field
  • 8+ years of data engineering experience in traditional data warehousing/ETL and/or big data pipeline & processing environments
  • Strong data modeling and SQL experience (Dimensional/Star, Transactional/3NF)
  • Strong programming experience with Python, Scala and/or Java
  • Experience with big data processing technologies (Spark, Storm, Kafka, Flume, Pig, Hive, Sqoop, Hadoop/MapReduce, etc.)
  • Experience with columnar storage and massive parallel processing data warehouses (Greenplum, Snowflake, Redshift preferred)
  • Hands on experience with building CI/CD
  • Experience modeling and querying for NoSQL databases (Cassandra, HBase, Mongo)
  • Experience working within agile software engineering methodologies

Job Details

Date Posted March 27, 2020
Date Closes April 26, 2020
Requisition 758712
Located In Lynchburg, VA
SOC Category 00-0000.00