Data Engineer IV

The Standard Portland , OR 97228

Posted 2 months ago

Overview

If you want to make a positive difference and stand out from the crowd, you'll fit in at The Standard (www.standard.com). Through our retirement plans and insurance products and services, we help people achieve financial well-being and peace of mind. Come join us and share our passion for serving our customers in a positively different way.

Responsibilities

What We're Looking For

We're looking for an amazing senior data engineer to join our talented enterprise data engineering team based in Portland, Oregon. Our team is responsible for a mature on premise data warehouse utilizing the MSBI technology stack of SQL Server, SSIS, SSAS (Tabular and MDX), SSRS, and Power BI and we are in the early stages of a fast-paced integration of Azure data services which include Data Factory, Data Lake Store/ Blob, Function Apps, HDI, Spark, Databricks, PolyBase, SQL/ and SQL Datawarehouse. We will continue to harden our MSBI stack while we integrate and operationalize Azure services and transform our workloads and the speed at which we are able to deliver solutions to business partners.

This key data engineering role will be critical to our success in maintaining our existing MSBI stack of database, ETL, and data warehouses and in integrating the Azure data services. We are looking for a well-rounded candidate with experience with big data technologies, cloud platforms - Azure experience highly preferred and an extensive background with traditional ETL, relational database architecture, and data warehouses are large plusses.

Qualifications

What You'll Bring

  • Our data engineers must be at the top of their game in data engineering, thrive in a collaborative team environment and enjoy working directly with our business partners.

  • Ability to profile data, understand and improve data quality, and bring best practices in data management to our business partners.

  • Develop data storage and modeling solutions using tools Azure SQL, Azure SQL Data Warehouse, Azure Data Lake, and Hadoop

  • Engineer data pipelines using Integration Runtimes, Azure Data Factory, U-SQL, and PolyBase. SSIS experience a plus.

  • Spark how to work with RDDs and Data Frames (emphasis on Data Frames) to query and perform data manipulation.

  • Deliver data to end user using tools such as SSAS Tabular models and downstream applications and REST Services. Experience with SSRS and Power BI a plus.

  • A Bachelor's degree in Engineering, Computer Science, Math, Information Systems or similar technical field of study.

What The Standard Offers

  • An opportunity to join an amazing team of talented data engineers responsible for modernizing our enterprise data platform.

  • A world-class location in the heart of downtown Portland, Oregon One of today's most vibrant cities. The Standard's campus is located only a few blocks from the vibrant waterfront and surrounded by food carts, breweries, restaurants, and an eclectic mix of local shopping.

  • Exercise facilities with locker rooms and showers, bike lockers, and access to almost every transit line within a block.

  • Competitive salary and benefits including health, dental, vision, and 401(k) with company match as well as pre-tax flexible spending accounts to pay for dependent care as well as commute expenses.

Standard Insurance Company, The Standard Life Insurance Company of New York, Standard Retirement Services, Inc., StanCorp Equities, Inc. and StanCorp Investment Advisers, Inc., marketed as The Standard, are Affirmative Action/Equal Opportunity employers. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, national origin, gender, sexual orientation, age, disability, or veteran status or any other condition protected by federal, state or local law. The Standard offers a drug and alcohol free work environment where possession, manufacture, transfer, offer, use of or being impaired by an illegal substance while on Standard property, or in other cases which the company believes might affect operations, safety or reputation of the company is prohibited. The Standard requires a criminal background investigation, drug test, employment, education and licensing verification as a condition of employment. All employees of The Standard must be bondable.

For more information regarding your Equal Employment Opportunity applicant rights, click here.

Individuals with disabilities who need assistance or accommodation with the application process should contact HR Direct at 971-321-7871. This number is only for the use of individuals with disabilities who need accommodation with the application process. General inquiries about application status will not be addressed.


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

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
Sr Data & Analytics Platform Engineer

Proenlist

Posted Yesterday

VIEW JOBS 11/13/2018 12:00:00 AM 2019-02-11T00:00 <span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;"><strong>Job Description: </strong><br /> Amazon Cloud Engineer to support our team responsible for the management of day-to-day operations and maintenance of our cloud-based infrastructures to ensure smooth 24x7 operation. The right candidate will contribute to system design, capacity planning, operations, maintenance, implementation and sustainment activities across development, staging and production environments and will work closely with Engineering and Program Managers to ensure proper and timely deployment of customer’s solutions.<br /> <br /> <strong>Additional responsibilities include:</strong></span></span> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Participate in system design planning, review, and implementation working groups.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Participate in providing technology assessments in support of automation and technology migration initiatives.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Recommend improvements; maintain/monitor production and non-production systems to ensure infrastructure performs at maximum efficiency.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Provide support of our applications including escalation and system performance of production platforms.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Develop and maintain plans to ensure successful recovery of operating systems in the event of a disaster, per DR policy.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Perform systems analysis and tuning to ensure optimal operating systems response for multi-user applications.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Implement/maintain IT security guidelines.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Use innovative methods and technologies to identify and solve problems related to performance, scalability, reliability, and availability.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Automating operational processes using scripting languages.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Develop, implement, and continually improve system and network monitoring and alerting capabilities and procedures.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Write knowledge base documents to improve operations, SOP and contribute to IT organization.</span></span></li> </ul> <br /> <br />   <h5><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;"><strong>Qualifications:</strong></span></span></h5> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Amazon Web Services operation, maintenance, implementation and design.</span></span> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Includes VPC maintenance/setup, EMR Clusters, EC2 management, IAM, Cloudtrail, Cloudwatch, EBS management, AMI and more.</span></span></li> </ul> </li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Windows 2008 systems administration or Linux systems administration</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Strong scripting for task automation in Python or other complex language</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Cloud management system APIs.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Strong written and verbal communication skills.</span></span></li> </ul> <br /> <span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;"><strong>Required Experience</strong></span></span> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">General Linux (RedHat, CentOS) or Windows (2008, 2012) system administration practices.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Strong scripting background for task automation and experience with cloud management system APIs.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Strong analytical and problem-solving skills.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Working knowledge of networking infrastructures, including LAN, WAN, VPN, etc.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Ensuring that solutions leverage industry best practices.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Demonstrated ability to generate and maintain technical documentation is required.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Experience with Active Directory, Active Directory Federation Services (ADFS), SAML, web Single Sign-on (SSO), OAuth and related authentication technologies</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Transport Layer Security / SSL principles and management</span></span></li> </ul> <br /> <span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;"><strong>Qualifications: </strong></span></span> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Bachelors’ degree or equivalent work experience in a technical or quantitative field; Masters or MBA degree a plus.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">Employment experience in a Fortune 100 company is a plus.</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">5+ years project experience deploying cloud solutions (AWS)</span></span></li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"><span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;">3+ years architecting and implementing Amazon Web Services infrastructure and topologies</span></span></li> </ul> Proenlist Portland OR

Data Engineer IV

The Standard