Analytics & Business Intelligence Specialist 3 (Portland, OR) #114146 - Military veterans preferred

General Purpose

Working independently under minimal supervision, provides advanced technical expertise and guidance in the architecture, design, programming, testing, documentation and implementation of business intelligence and data analytic systems. Responsible for the complex and efficient ETL maps, highly intuitive data models, reports and dash boards, migrations into different environments, maintenance and monitoring of the Enterprise Reporting. Evaluates software packages, provides recommendations to management and business clients, and identifies best technology solutions. Identifies future needs for key technologies and techniques and develops plans for adoption. Provide advice and counsel to management and client organizations. Conduct special studies and analyses, develop alternatives, present recommendations to management and influence management decisions. Research, analyze, develop, and implement new strategies, programs, and/or processes in response to changing internal and external conditions.

Responsibilities

• Act as the technical lead for highly complex projects related to the development of new business analytical solutions, testing and implementing business intelligence reporting systems, data mapping components, source system data, ETL strategy, data staging, moving and aggregation, information and analytics delivery, and data quality strategy.
• Oversee software development and ensure conformance to performance optimization and interoperability standards and requirements. Ensure adherence to secure development lifecycle practices and policies.
• Perform project planning, system analysis, software design and coding, testing, documentation, implementation and research activities as necessary for software engineering projects.
• Act as the subject matter expert and consults with clients on company's IT strategy and business requirements.
• Collaborate with IT teams from applications and infrastructure to identify technology deficiencies and improvement opportunities in practices and procedures.
• Provide guidance and direction to team members as necessary in the completion of assigned projects.
• Participate in on-call rotation, including after hour and weekend support.
• Performs additional responsibilities as requested or assigned.

Requirements

• 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.)
• Five years of related experience in database administration, systems analysis or data engineering.
• Demonstrated knowledge of data relationship management.
• Demonstrated knowledge of data modeling and code design impacts for data loading and reporting performance.
• Maintain the professional competence, knowledge and skills necessary for the satisfactory completion of responsibilities; enhance job knowledge and abilities by taking personal responsibility for professional development and training.
• 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.
• Program and design skills including development of interventions, processes, or new or modified programs to meet customer needs.
• Communication and interpersonal skills involving the ability to establish trust, maintain confidence, and understand social behavior and interactions.
• Ability to work with all organizational levels to influence actions and negotiate outcomes.
• Ability to listen and communicate effectively through oral and written means.
• Proficient with the use of personal computers to gather, analyze, and summarize data.
• Availability for regular on-call responsibilities.

Additional Information

Req Id: 114146
Company Code: PacifiCorp
Primary Location: PORTLAND
Department: PacifiCorp Corporate
Schedule: M-F/ FT
Personnel Subarea: Exempt
Hiring Range: $103,800 -$122,000
This position is eligible for an annual discretionary performance incentive bonus of up to 15% 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.