Data Engineering Technologist - Butte, MT

  • Northwestern Energy
  • Nov 22, 2021
Full time Data Engineering

Job Description

NORTHWESTERN ENERGY

INTERNAL/EXTERNAL POSTING: JOB REQUISITION #3286

POSTING DATES: November 16, 2021 through Open Until Filled

Title

Data Engineering Technologist

Department/Division

Business Technology

Work Location

Butte, MT or Sioux Falls, SD

Guidepost

7-9 ($65,600 to $123,000)

Employment Status

Regular Full-time

Employment Physical

Not Required

Drug Test

Required

Background Check

Required

Relocation Benefit

Negotiable

SUMMARY OF JOB DESCRIPTION

The Data Engineering Technologist is responsible for expanding and optimizing data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The Data Engineering Technologist is experienced in data pipeline building and data wrangling, and optimizing data systems and building them from the ground up. The Data Engineering Technologist will support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. The Data Engineering Technologist must be self-directed and comfortable supporting the data needs of multiple teams, systems and products across the organization.

DESCRIPTION OF ESSENTIAL FUNCTIONS

  • All NorthWestern Energy employees are required to adhere to company safety standards and the Code of Business Conduct & Ethics
  • Ensure all actions are consistent with NorthWestern Energy's values, mission, and strategic business objectives
  • Develop, construct, test and maintain optimal data pipeline architecture
  • Assemble large, complex data sets that meet business requirements
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-design data processes for greater scalability, etc.
  • Build the data applications required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and other big data technologies
  • Build analytics tools that utilize the data pipeline to provide actionable insights into customers, operational efficiency and other key business performance metrics.
  • Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs.
  • Work with data and analytics experts to strive for greater functionality in our data systems
  • Work with data analysts, data scientists and business leaders to develop and deploy data driven analytical models
  • Implements process and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it
  • Write unit/integrations tests for data pipelines and contributes to data engineering documentation
  • Defines company data assets (data models) and defines jobs to populate models
  • Designs data integrations and data quality framework
  • Plan, direct and set priorities with project teams to ensure timely task completion
  • Some travel and extended hours may be required

GENERAL QUALIFICATIONS

  • Demonstrate and maintain a good safety record
  • A Bachelor's Degree in IT, Computer Science, or related field from four-year accredited college, who has attained a degree in Computer Science, Information Systems or other quantitative field.
  • 4+ years of experience in a Data Engineering role preferred.
  • Experience using the following software/tools:
    • Big data tools: Hadoop, Spark, Kafka, etc.
    • Relational SQL and NoSQL databases
    • Data pipeline and workflow management tools: Azure Data Factory, Airflow, Kubeflow, etc.
    • Cloud services, including: VMs, ETL Tools, Data Lake Storage, Hive, and Data Warehouses
    • Object-oriented/object function scripting languages: Python, Java, Scala, .NET
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
  • Experience building and optimizing big data pipelines
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
  • Strong analytic skills related to working with unstructured datasets
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management
  • A successful history of manipulating, processing and extracting value from large disconnected datasets
  • Working knowledge of message queuing, stream processing, and highly scalable big data stores
  • Thorough understanding of the OSI model and ability to apply knowledge to system design and troubleshooting
  • Proven knowledge of secure software development and building secure data systems
  • Strong project management and organizational skills
  • Experience supporting and working with cross-functional teams in a dynamic environment
  • Experience with or knowledge of Agile Software Development methodologies
  • The candidate should be results-driven, an analytical and creative thinker, an innovative problem solver, self-motivated and proactive, highly organized and have the ability to handle multiple and simultaneous tasks to meet aggressive deadlines

SELECTION PROCESS

When considering applicants for this position, the selection process will take into consideration the needs of NorthWestern, including such factors as reorganization requirements, diversity opportunities, relocation requirements, employee development and job succession. If any of the preceding language conflicts with the applicable bargaining unit agreements, the bargaining unit agreement will prevail.

APPLICATION PROCEDURES

External applicants should apply online at http://www.northwesternenergy.com. Internal applicants should apply online at iConnect. In compliance with the ADA Amendments Act, should you have a disability that requires assistance and/or reasonable accommodation with the job application process, please contact the Human Resources department via phone at 1-800-245-6977, or via email at job.inquiries@northwestern.com.

NorthWestern Energy

Human Resources Department Job #3286

3010 West 69th Street

Sioux Falls, SD 57108

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, gender, age, disability, veteran status, genetic information or any other protected class in accordance with applicable federal or state laws and statutes.