Data Analyst 3 - Data Analysis and Architecture

Job Title: Data Analyst 3 - Data Analysis and ArchitectureJob Number: 11942Location: Vancouver, WA - OnsiteTravel: Up to 5% for local meetings and travelOT: 5% anticipatedLength: 1+ yrs, up to 5 yearsMUST be US Citizen to be eligible to apply for Federal Background CheckReal ID or Passport REQUIRED for in-person interviews and onboardingOVERVIEWThis 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.RESPONSIBILITIESProvide 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 codingCoordinate with various divisions, and other corporate organizational partners including corporate consultants.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.With appropriate data analytic modeling, 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, which include conveying complex ideas both verbally and in written form.REQUIREMENTSEducation & Corresponding ExperienceA 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.Experience must include direct work experience in Information Technology performing Data Analysis.Required Technical Skills & Experience5 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 & ExperienceExperience with Market Analysis or Product Management teams, especially those dealing with evolving customer and business needs.Ability to conduct data modeling sessions with business users and technical staff, which includes conveying complex ideas both verbally and in written form.Ability to understand database management system administration with regard to performance, configuration, and de-normalization.Additional RequirementsValid U.S. Driver's License is required.Pre-Employment RequirementAll 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 StaffingAPR 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.