Data Engineer

Company: Pacific Life
Location: Lynchburg
Posted on: March 18, 2020

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, you'll play a key role in Pacific Life's digital and workplace transformation, working directly with Business Process Owners to deliver data products in a collaborative environment. You'll 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 you're a self-starter who's comfortable with ambiguity, technically-minded, with strong communication and analytical skills, you're precisely who we're seeking. What You'll 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 You'll Use SQL, NoSQL databases (Cassandra, HBase, Mongo), data warehouses (Greenplum, Snowflake, Redshift), Python, informatica, Snowflake, SQL Server, Python, Powershell and SSIS Factors for Success 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 For more than 150 years, Pacific Life has offered innovative products and services including life insurance, annuities, and mutual funds, along with a variety of investment products, all of which provide The Power to Help You Succeed. We firmly believe each employee plays a part in our continued growth and success, and we pride ourselves in providing a work environment that is challenging, inclusive, collaborative, and results-oriented. With a powerful past and a strong future, Pacific Life offers an environment where you're empowered to achieve your personal best. In return, we look to your passion and insight to help us grow. For additional company information, including current financial strength ratings, visit www.PacificLife.com.Join the Pacific Life team and watch your career grow! We offer a competitive compensation and benefits package that includes: --- Competitive salary and bonus program --- Medical, dental, and vision as part our commitment in investing in the health and wellbeing of our employees --- Two retirement savings plans: 401k savings plan with company match and Company Retirement Contribution (company-paid) --- Generous vacation time and holiday pay --- And much more!Pacific Life Insurance Company is an Equal Opportunity /Affirmative Action Employer, M/F/D/V. If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact a Human Resources Representative at Pacific Life Insurance Company. - provided by Dice

Keywords: Pacific Life, Lynchburg , Data Engineer, Engineering , Lynchburg, Virginia