Senior Data Analyst

Job Title: Data Analyst 3 Job Number: 11942 Location: Vancouver, WA - Onsite Travel: Up to 5% for local meetings and travel OT: 5% anticipated Length: 1+ yrs, up to 5 years MUST be US Citizen to be eligible to apply for Federal Background Check Real ID or Passport REQUIRED for in-person interviews and onboarding OVERVIEW This full-time contract Data Analyst 3 assignment is located in the corporate Transmission Services’ Transmission Energy Imbalance Market (EIM) Settlements group, a part of the Transmission Commercial System Management department of Transmission Marketing and Sales organization. This assignment will support divisional Settlement and Market Analysis activities by documenting and producing Business Analytics solutions that support CAISO and day ahead Market Analysis. This assignment will work with various divisions and corporate business partners to understand business needs, document requirements, and design data models. RESPONSIBILITIES • Provide data analysis for quality assurance testing efforts related to corporate Settlements data. • Provide data analysis to support settlements daily, weekly and monthly calculations. • Document data flow diagrams, entity relationship diagrams and other project deliverables. • Provide PL/SQL databases (queries, functions, stored procedures) • Produce excel macros using VBA coding • Coordinate with various divisions, and other corporate organizational partners • Develop and maintain an understanding of higher-level activities of wholesale electric transmission customers in the western states as context for the goals of market, consumer, and business analysis. • Develop a working familiarity with essential databases that support Transmission product analyses including OASIS reservations system, scheduling and other transmission operations data, generation sources, curtailments data, generation interconnection information, customer-oriented data, etc. • Develop databases that enable analyses of power markets and corporate Transmission products and services. • Translate data quality and architecture issues to both technical and non-technical teams. • Work with business partners to understand business needs, design data models and develop specifications for analytical reports and data visualizations. • Develop and design functional and technical requirements for Business Analytics projects. • Perform logical data modeling and physical data modeling. • Conduct data modeling sessions with business users and technical staff REQUIREMENTS Education & Corresponding Experience • A degree in Information Technology, Business Systems, Computer Technology or a closely-related technical field such as Data Analytics is preferred. • With an applicable Bachelor’s degree, 6 yrs of experience is required. • With an applicable Associate’s degree, 8 years of experience is required. • Without an applicable degree, 10 years of experience is required. Required Technical Skills & Experience • 5 years of application of skills to analyses of markets, business analyses, and consumer products and services analyses • Knowledge of Data Warehousing techniques, terminology, implementation and ETL (Extract, Transform & Load). • 5+ years of statistical analysis or data analysis experience. • 2+ years of data analytics applied to analyses of markets, business to business products and services, and consumer products and services. • Demonstrated experience designing physical and logical data models. Prefer experience using the Erwin Data Modeling tool. • Experience using enterprise data modeling tools. • Experience should include relational and dimensional modeling. • Experience with identification and evaluation of data quality issues. Preferred Skills & Experience • Experience with Market Analysis or Product Management teams • Ability to conduct data modeling sessions with business users and technical staff • Ability to understand database management system administration with regard to performance, configuration, and de-normalization. Pre-Employment Requirement All employment offers are contingent upon successful completion of our pre-employment screening that may include drug testing, background/criminal check, and if applicable, must meet eligibility requirements for access to classified information. APR Staffing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. About APR Staffing APR Staffing was born from the merger of two well-respected technical staffing firms in Portland. ieSolutions and Data Resource Group. Both companies have been recent award winners for the Portland Business Journal's Fastest-Growing Private Companies. The two firms, now as APR Staffing, make for one of the fastest-growing and most-respected professional and technical staffing companies in Oregon and Southwest Washington. Collaborating with our customers, we augment their workforce with technical and administrative professionals. We provide only high-caliber, professional-grade resources throughout the Pacific Northwest.