Data Engineer (Remote - Can Sit Anywhere In U.S.)

Nexant Seattle , WA 98101

Posted 3 weeks ago

Nexant is seeking a Data Engineer to join our growing Advanced Analytics team, which focuses on advancing the use of applied econometrics and data science for electric and gas utilities. This position will be responsible for creating and optimizing our data pipeline and architectures, as well as optimizing data flow and collection for our internal and external customers. The ideal candidate will have experience in data wrangling and pipeline development and enjoys optimizing data systems and building them from the ground up. This is a highly collaborative position that will primarily support the consulting and software teams by creating the necessary data infrastructure using Amazon Web Services (AWS) for their advanced analytics initiatives. The candidate must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products.

This position provides the opportunity to help accelerate the transition to a cleaner and more efficient energy mix for utilities throughout North America. Projects commonly involve high-volume time-series analysis of IoT data based on hourly energy consumption data for hundreds of thousands (if not millions) of utility customers.

Requirements

  • Collaborate with members of your team (e.g. data scientists, engineers, and managers) on your projects goals and expectations.
  • Create data tools for data science team members that assist them in building and optimizing advanced analytics applications, with a focus serving business intelligence and machine learning.
  • Design, build, and maintain infrastructure required for optimal extraction, transformation, and loading (ETL), and storage of data from a wide variety of data sources using SQL and AWS.
  • Build and maintain physical and logical data models.
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Ensure data security/privacy and protocols are established and followed based on client and company requirements.
  • Create custom software components and analytics applications as needed.
  • Employ an array of programming languages and tools to connect systems together.
  • Ensure that all systems meet stakeholder requirements as well as industry best-practices.

Required Qualifications:

  • A bachelors degree in computer science, information systems, informatics, statistics, applied mathematics, or other quantitative fields
  • 2+ years of experience designing, building, and maintaining large-scale data pipelines and warehouses in the cloud
  • Experience optimizing data pipelines, architectures, and integrating disparate data sets.
  • Knowledge in data modeling, data structures, and query performance tuning on MySQL, PostgreSQL, AWS RDS and Redshift, or similar data stores
  • Knowledge of serverless computing in AWS using AWS Lambda and Step Functions
  • Experience with object-oriented/object function scripting languages
  • Strong project management and organizational skills.
  • Experience supporting and working with cross-functional teams in a dynamic environment.
  • Git or other version control experience

Preferred Qualifications:

  • Deep expertise with AWS cloud services as demonstrated by work history and cloud certifications is highly desired.
  • Graduate degree in computer science, information systems, informatics, statistics, applied mathematics, or another quantitative field
  • Experience with Microsoft Azure
  • Experience working on high-volume time-series IoT data
  • Experience with Docker and containerization
  • Experience with big data platforms: Hadoop, Spark, Hive, etc.
  • Experience building and deploying APIs
  • Experience working with data scientists and machine learning applications
  • System management expertise with monitoring, disaster recovery, backup, automated testing, automated schema migration, and continuous integration/deployment

Benefits

Nexant offers competitive salaries based on candidate's qualifications. Nexant also offers competitive paid vacation per year, a Group RRSP plan with employee matching funds and an overall comprehensive benefits package.

Nexant is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, national origin, disability status, protected veteran status, or any other characteristic protected by law.

About Nexant

Nexant is a globally recognized software, consulting and services leader that provides innovative solutions to utilities, energy enterprises, chemical companies and government entities worldwide. Founded in 2000 and headquartered in San Francisco, Nexant and its 500+ employees work from 32 global offices providing deep technical expertise and regional knowledge to improve customer engagement, boost operational efficiency, reduce costs and achieve superior business results. Our core values are: integrity, community, communication, creativity, impact, curiosity, and passion. Nexant supports clients through four distinct business units:

  • Nexant Energy Software has developed and commercialized a number of industry-leading software platforms and applications, including Nexant iEnergy, Nexant Grid360, and Nexant iHedge
  • Nexant Utility Services works with clients to drive customer energy savings, ensure cost-effective program design, implementation and management, and promote customer engagement
  • Nexant Energy & Chemicals Advisory provides strategic planning, project development, competitor analysis, market and price forecasting, and NexantThinking, a subscription program and online product portal.
  • Nexant Government Services assists developing countries with energy sector policies, infrastructure, financing, and access to affordable electricity.

Every day, Nexant employees partner with customers to reimagine the world we live in and create a more sustainable energy tomorrow.

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
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
Senior Data Engineer (Python / SQL / Redshift)

Rooster Park

Posted Yesterday

VIEW JOBS 10/21/2020 4:16:57 PM 2021-01-19T16:16 <div dir="ltr"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">We’re working with one of our favorite partners on a significant greenfield data initiative, and are searching for experienced data engineers to join the team. You’ll be closely integrating with our client and helping to improve data ingestion, reporting, business intelligence, and ETL performance and reliability.</b></div>   <div dir="ltr"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">You have deep technical expertise in the data ecosystem (SQL, Python, Redshift, ETL) and a strong understanding of working with data and business intelligence, and building data pipelines and tools.</b></div>   <div dir="ltr"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">What you’ll be doing:</b></div>   <ul> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Work with product teams and analysts to gather and understand data requirements</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Design and build data models to support both Tableau and ad-hoc data queries</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Build and migrate complex ETL pipelines into Redshift clusters</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Perform complex SQL queries</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Understand the design of existing pipelines and data sources, and integrate with those as needed</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Optimize ETL performance and reliability</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Understand business goals and data well enough to be able to check the reasonability of data sources</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Work well with team members, and be willing to ask for help rather than getting stuck on your own</b></div> </li> </ul>   <div dir="ltr"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">What you bring to the table:</b></div>   <ul> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">10+ years of experience as a Data / BI / ETL Engineer or similar, building and maintaining ETL pipelines</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Significant experience modeling complex data sets</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Extensive experience bringing ETL pipelines into Amazon Redshift</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Strong SQL skills</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Experience in Python and other data ingestion languages and tools</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Experience working with complex data in fast moving and scaled environments</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">Strong collaboration and communication skills; you function well autonomously with drive and self-direction, but you’re also comfortable being part of a team and working in partnership with your colleagues</b></div> </li> <li dir="ltr" style="padding: 0; margin: 0;"> <div dir="ltr" role="presentation"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">You are reliable, responsible, consistent, nice, and passionate about what you do</b></div> </li> </ul>   <div dir="ltr"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">This is a fully remote consulting opportunity, based in the Puget Sound. Unfortunately at this time we are not able to provide sponsorship for employment and request no agency submissions. Thank you!</b></div>   <div dir="ltr"><b id="docs-internal-guid-9bef0d68-7fff-d701-7b77-f1a422231167">We’re Rooster Park (http://www.roosterpark.com/), and we’re passionate about matching your dreams with our partners' needs. We're an equal opportunity employer who celebrates diversity, and chooses to work with similarly open-minded clients. We pay competitively and have excellent healthcare and other benefits. </b></div> Rooster Park Seattle WA

Data Engineer (Remote - Can Sit Anywhere In U.S.)

Nexant