Data Engineer

Transamerica Life Insurance Company Denver , CO 80208

Posted 1 week ago

Job FamilyData Engineering

Job Description SummaryAt Transamerica, we believe achieving a secure future requires both smart financial planning and a healthy lifestyle. We're using data science, machine learning, computer vision, natural language processing, and IoT to revolutionize the way our customers save, invest, protect, and retire and to help them develop better wellness habits. As part of the Data Engineering team in our Analytics Execution group, you will work with data scientists and analytics engagement managers to develop innovative data-based solutions that transform the way we do business.Job Description


  • You have a solid understanding of data engineering, integration, and warehousing concepts and patterns

  • You know how to design, build, and maintain batch and streaming data solutions at scale in both on-premises and cloud environments, specifically in the Hadoop ecosystem

  • You're proficient with Linux operations and development, including basic commands and shell scripting

  • You can demonstrate experience with DevOps methodologies and continuous integration/continuous delivery practices

  • You are fluent in Python, R, and Java

  • You have excellent command of SQL

  • You have a passion for data science and machine learning with a strong desire to develop your analysis and modeling skills

Preferred Qualifications:

  • You have worked with statistical analysis and machine learning libraries

  • You have experience with NoSQL database implementations

  • You understand the fundamentals of lambda architectures and serverless applications

  • You are proficient in Tableau

  • You're comfortable leveraging ETL tools, like Informatica

  • You are proficient in Scala or Node.js

  • You have a master's degree in a quantitative field

Job Description:

  • Partner with data scientists, analytics engagement managers, and other data engineers to discover, collect, cleanse, and refine the data needed for analysis and modeling

  • Analyze large datasets to extract actionable insights and inform experimental design and model development

  • Design robust, reusable and scalable data driven solutions and data pipeline frameworks to automate the ingestion, processing and delivery of both structured and unstructured batch and real-time streaming data

  • Build models using basic statistical and machine learning techniques, partnering with data scientists for education and guidance

Working Conditions

  • Office environment

Why Work for Us

Total Rewards at Transamerica: It's more than a paycheck.

Our comprehensive Total Rewards package is designed to help support you in many ways throughout all stages of your life and career. We provide a competitive, market-driven program that encompasses base compensation, bonus potential, retirement, health and wellness benefits, learning and development opportunities, plus great employee perks. All designed with you in mind to help you live your best life, grow personally and professionally - and feel valued for the work you do.

Learn more about our Total Rewards Package.

Equal Opportunity Employer:

Transamerica Life Insurance Company is an Equal Employment Opportunity employer and does not discriminate against any applicant or employee because of age, religion, sex, gender identity, genetic information, race, color, national origin, pregnancy, sexual orientation, marital status, participation in the uniformed services (e.g. U.S. Armed Forces, National Guard), physical or mental disability, or any other status protected by federal, state, or local equal employment opportunities laws.

AEGON USA Realty Advisors, LLC, is an Equal Employment Opportunity/ Affirmative Action Employer and does not discriminate against any applicant or employee because of age, religion, sex, gender identity, genetic information, race, color, national origin, pregnancy, sexual orientation, marital status, participation in the uniformed services (e.g. U.S. Armed Forces, National Guard), physical or mental disability, or any other status protected by federal, state, or local equal employment opportunities laws.

Applicants with physical or mental disabilities may be entitled to a form of reasonable accommodation under the Americans with Disabilities Act and certain state and local laws. A reasonable accommodation is a change in the way things are normally done which will insure equal employment opportunity without imposing undue hardship on the Transamerica Companies. Please contact: if you are a job seeker with a disability, or are assisting someone with a disability, and require assistance to apply for one of our jobs.

Ontario Applicants:

Our Company is committed to providing accessibility to those with disabilities in a manner that is consistent with the principles of independence, dignity, integration and equality of opportunity, that is in compliance with the Accessibility for Ontarians with Disabilities Act 2005 ("AODA"). Please contact if you are a job seeker with a disability, or are assisting someone with a disability, and require assistance to apply for one of our jobs.

Technical Assistance:

If you experience technical problems during the application process, please email

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Engineer


Posted 4 weeks ago

VIEW JOBS 2/20/2019 12:00:00 AM 2019-05-21T00:00 Alterra Mountain Company COMPANY OVERVIEW Alterra Mountain Company is a community of 12 iconic year-round destinations, including the world's largest heli-ski operation. The company owns and operates a range of recreation, hospitality, real-estate development, food and beverage and retail businesses. Headquartered in Denver, Colorado with destinations across the continent, we are rooted in the spirit of the mountains and united by a passion for outdoor adventure. Alterra Mountain Company's family of diverse playgrounds spans five U.S. states and three Canadian provinces: Steamboat and Winter Park Resort in Colorado; Squaw Valley Alpine Meadows, Mammoth Mountain, June Mountain and Big Bear Mountain Resort in California; Stratton in Vermont; Snowshoe in West Virginia; Tremblant in Quebec, Blue Mountain in Ontario; Deer Valley in Utah; and CMH Heli-Skiing & Summer Adventures in British Columbia. We honor each destination's unique character and authenticity and celebrate the legendary adventures and enduring memories they bring to everyone. TEAM OVERVIEW, CULTURE AND VISION EIM team members will require strong business acumen, high energy, and a high level of sociality. They must bring a combination of technical depth, with a mind for business process and business strategy. They should also possess a strategic personality with a sense of entrepreneurial spirit and drive for innovation. Each must be self-directed, but not rogue, with the strategic business goals and EIM program vision in mind. Employees enjoy many different perks related to the portfolio of companies, including free ski passes, discounted access to CMH and other ski resorts, ECO pass, and a great office located in the heart of Lower Downtown. POSITION SUMMARY Alterra is a distributed organization, and enterprise data capabilities will be a core technology discipline to enable growth and success. This position will help build the data platform of the future for Alterra, utilizing progressive ideas and strategies for managing the flow and storage of information across the enterprise. The new company is working to aggregate and unify data to achieve tactical and strategic business decision making; support innovative guest and employee experience applications; and drive guest & business analytics. You will be responsible for executing the technical architecture and development of the data processing, storage, access capabilities. You will work closely with the Business Intelligence and Enterprise/Cloud Infrastructure teams, as well as various business partners and executive stakeholders across sales, marketing, finance, operations, security and compliance. ESSENTIAL DUTIES * Provide input to and execute the design, implementation, maintenance, enhancement, monitoring and governance of enterprise data repositories including the Alterra data lake, data warehouse, LOB specific data marts, enterprise master data (customer, product, location), enterprise reference data, and raw data archives. * Monitor and provide input into the enterprise IT architecture including cloud infrastructure and connectivity; database architecture and connectivity; external data connectivity (S/FTP, APIs); security, backup and DR as these subject areas relate to the enterprise information architecture. * Ensure data ingestion processes catalog and tag arriving data and provide data life cycle and version management across landing, near-term archive, long term cold storage, and data destruction events based on corporate security, compliance, and data retention policies. * Ensure data pipelines provide appropriate access security, encryption (at rest and in motion) and data masking/stripping based on content and corporate security and compliance guidelines. * Ensure proper governance of enterprise data assets including data access at the subject and row level, enforcement of data privacy (PII), protection of financial data (PCI), and country specific treatment and regional storage of data. * Provide input to and execute development of design patterns and best practices for data integration and data analysis across the enterprise. * Provide input to and execute development and enforcement of naming conventions for enterprise data assets including data models; database, schema, table, view, index, trigger, stored proc/function names; object level storage container names and paths; file names; and ETL scripts. * Collaborate with teams that manage operational data masters and lead the design and development of data mastering processes. * Provide input to and execute development of logical and physical enterprise data models; enterprise master data and reference data models; metadata models; and data catalogs. Support the governance and stewarding of master and reference data. * Lead the ongoing development and code reviews of data acquisition, data movement, data cleansing, data transformation, data mapping, data quality screens, ETL jobs and schedules, and other ETL and data integration activities. * Ensure that ETL jobs are scheduled, monitored and generate detailed logs sufficient to support ongoing diagnostics, exception processing, and audit trails for compliance. * Ensure data related design and code assets are tested and documented and managed in a version control repository. Assets should include models, code, run-books, and infrastructure-as-code scripts. * Manage the packaging of code assets, models, configurations, schemas and migration instructions to support updates to development, test and production environments. * Coordinate with the change control approval board and operations teams to schedule the migration of code assets, models, configurations and schemas across test and production environments. * Mentor and support data integration and business intelligence teams. EDUCATION & EXPERIENCE REQUIREMENTS (state minimum required and preferred) Education: * Undergraduate Major preference: Business, IS/IT, Computer Science, related field and/or experience Experience: The ideal candidate has experience: * Organizing data at scale including data lakes, data marts, and data warehouses. * Data Architecture, Data Management Services, Data Governance, Data Quality processes and Data Lifecycle. * Design and construction of information architectures that enable well-integrated transactional, collaborative and analytical systems. * Enterprise level data modeling at the logical and physical levels for 3NF, star schema, slowly changing data. * Data cataloging and metadata management. * Cloud-based data platforms such as Azure and AWS; cloud security (accounts, users, groups, roles); logging and monitoring; lambdas and functions; data versioning and life cycle management; infrastructure-as-code. * Commercial ETL tools such as SSIS, Talend, Informatica and/or the use of 3GL languages such as C#/Python to implement ETL services. * ETL job scheduling tools/techniques, job control, exception handling, logging, and monitoring. * ETL workflow design including change data capture, transformations, mapping, and data quality screens. * Code and infrastructure-as-code testing techniques including unit, integration, system, performance/stress, and acceptance tests. * SQL databases, DDL, DML, DQL, DCL, and TCL, triggers, stored procedures/functions, indexes, sequences, table schema types, transactions, and replication. * Database schema migration techniques. * Schema-on-read query paradigm, columnar file formats such as Parquet/AVRO, compression and partitioning techniques. * SDLC concepts including application lifecycle management, release management, and optionally continuous delivery. * Version management via a version control system/repository. * Conceptual understanding of advanced analytic and machine learning data processing requirements. * Various data connectivity techniques including FTP and APIs, * Master data management using mapping tables and/or commercial MDM tools. * Serverless and microservice architectures and techniques. QUALIFICATIONS, KNOWLEDGE, SKILL AND ABILITY REQUIREMENTS * 3+ years building cloud-based data platforms (architecture, storage, management, monitoring) * 1+ years with cloud-based development technologies such as Python, Lambda, Azure Functions * 3+ years of experience building information architectures * 3+ years of experience data profiling & data mining * 3+ years of experience building data warehouses and/or data marts * Business Process Management process and application experience * Experience with Informatica & SSIS is a plus * Experience with metadata applications and solutions * Experience with master data management APPITUDE AND PASSIONS * Strong project management and organizational skills. * Collaborative and mentoring work style. * Strong analytic skills and hands-on attention to detail. * Mechanical tendencies and a curiosity to know how things work and how to make them better. * Passion for statistics & analytics, process engineering, and information management. * Loves being hands-on in a fast-paced, entrepreneurial environment. TRAVEL REQUIREMENTS * Some limited travel may be required. An Equal Opportunity Employer Intrawest Denver CO

Data Engineer

Transamerica Life Insurance Company