Data Engineer 3 (Portland, OR) #111946
PORTLAND, OR, US, 97232
Applications have closed
*
PacifiCorp is seeking customer-centric candidates to grow and sustain our commitment to a culture of customer service excellence, environmental sustainability and diversity, equity and inclusion.
General Purpose
Data engineers are mainly tasked with transforming data into a format that can be easily analyzed. They do this by developing, maintaining, and testing infrastructures for data generation. Data engineers work closely with data scientists and are largely in charge of architecting solutions for data scientists that enable them to do their jobs.
Data engineers generally have a bachelor's degree in computer science, information technology, or applied math, as well as a few data engineering certifications like Azure Certified Data Engineer. In addition, data engineers possess a plethora of technical skills and the ability to approach problems in a creative manner.
Working with significant independence and under general direction, position is responsible for the data management and design, implementation, maintenance and monitoring of database technologies and related software. Provides direct support to application and analytics teams. Conducts analysis, creates system specifications, develops, tests and implements engineering, scientific and business applications, operating systems, and file/database servers. Utilizes existing or new technology in the automation of processes. Evaluates software packages and provides recommendations to management. Provides actionable recommendations for improvements in application performance after analyzing underlying database-related infrastructure components. Write and maintain comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents. Recommends and implements improvements of client accessibility to corporate information.
Responsibilities of this position include the following:
- Designs, codes, tests, documents, implements and maintains data lake utilities.
- Supports vendor-developed database implementation and periodic maintenance releases as required.
- Provides technical input to assist in development of project planning.
- Maintains data lake software at appropriate vendor-supported levels.
- Supports data management, movement, security, and performance.
- Implements data pipelines within Azure Data Factory.
- Participate in on-call rotation, including after hour and weekend support.
- Assemble large, complex data sets that meet functional / non-functional business requirements.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Python.
- 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’ data pipelines, architectures and data sets.
- Performs additional responsibilities as requested or assigned.
Requirements for this position include the following:
- Bachelor’s degree in computer science, information technology or related field; or equivalent work experience. (Typically four years of additional related, progressive work experience would be needed for candidates applying for this position who do not possess a bachelor’s degree.)
- 5+ years of experience in one of the following or any combination of: ADLS, Python, Hadoop, SQL, Databricks, Oracle Fusion Middleware, Azure DevOps, GitHub, ML Studio, Oracle Cloud Infrastructure
- Demonstrated knowledge of backup and recovery, disaster recovery, high availability, security, infrastructure, performance tuning, lifecycle, data management and data movement.
- Effective oral and written communication skills fostering an atmosphere of teamwork, high productivity and accuracy.
- Consistently delivers requirements and meets timelines.
- Advanced analytical and problem-solving skills.
- Ability to prioritize and handle multiple tasks and projects concurrently.
Additional Information
Req Id: 111946
Company Code: PacifiCorp
Primary Location: PORTLAND
Department: PacifiCorp Corporate
Schedule:FT
Personnel Subarea: Exempt
Hiring Range: $100,700 - $118,400
This position is eligible for an annual discretionary performance incentive bonus of up to 15.00% of salary.
Benefits: Health care, retirement, paid time off, tuition assistance, paid short-term and long-term disability, paid bereavement leave. For more information, please visit: https://careers.pacificorp.com/content/New-Benefits-Page/?locale=en_US
Employees must be able to perform the essential functions of the position with or without an accommodation.
At PacifiCorp, we celebrate diversity, equity and inclusion. PacifiCorp is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, medical condition, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.
All offers of employment are contingent upon the successful completion of a background check and drug screening.
Tags: Architecture Azure Big Data Computer Science Databricks Data management Data pipelines DevOps Engineering GitHub Hadoop Machine Learning Mathematics Oracle Pipelines Python RDBMS Security SQL Testing
Perks/benefits: Equity Health care Medical leave Parental leave Salary bonus
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs