Sr Analytics & BI Specialist (Portland, OR) #113306

Sr Analytics & BI Specialist (Portland, OR) #113306Apply promptly! A high volume of applicants is expected for the role as detailed below, do not wait to send your CV.Date: Mar 3, 2025Location: PORTLAND, OR, US, 97232Company: PacifiCorp* PacifiCorp is seeking customer-centric candidates to grow and sustain our commitment to a culture of customer service excellence, environmental sustainability inclusion & belonging.General Purpose Working with significant independence and under general direction, 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.Provide technical leadership to staff; may direct work of developers and various analysts in the completion of assigned projects.Plan, schedule and assign work based on established priorities.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 consult 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 assignedRequirements Bachelor's degree in computer science, information technology or related field; or equivalent work experience.Six years of related experience in database administration, systems analysis or data engineering.Demonstrated advanced knowledge of data relationship management.Demonstrated advanced 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.5 years of Informatica ETL development experience2 years of Oracle Data Integrator ETL development experience5 years of AIX and Linux operating system experienceAdditional Information Req Id: 113306Company Code: PacifiCorpPrimary Location: PORTLANDDepartment: PacifiCorp CorporateSchedule: FTPersonnel Subarea: ExemptHiring Range: $119,400 - $140,400This 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: must be able to perform the essential functions of the position with or without an accommodation.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.Unless otherwise required by law, all offers of employment are contingent upon the successful completion of a background check and drug screening including for marijuana. While marijuana is legal in several states, including Oregon, a positive test for positions in Oregon may disqualify a candidate. The company complies with the laws of Washington and California and only obtains and considers positive tests for marijuana in safety-sensitive positions or those covered by U.S. Department of Transportation regulations.Career Segment: Test Engineer, Testing, Systems Analyst, DBA, Relationship Manager, Engineering, Technology, Customer ServicePIb538da823dbd-35216-37068955

Created: 2025-03-05