NorthWestern Energy Data Engineering Technologist in Butte, Montana
Data Engineering Technologist
21-Apr-2021 to Until Filled (MST)
Butte, MT, USA
Regular Full Time
Email Me Similar JobsEmail Me This Job
INTERNAL/EXTERNAL POSTING: JOB REQUISITION #3286
POSTING DATES: November 16, 2021 through Open Until Filled
Data Engineering Technologist
Butte, MT or Sioux Falls, SD
7-9 ($65,600 to $123,000)
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
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
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.
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 firstname.lastname@example.org.
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.