Data Engineer 3 (Portland, OR)
PacifiCorp
- Portland, OR
- $100,700-118,400 per year
- Permanent
- Full-time
- 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.
- 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.
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: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.