Senior Data Analyst (Onsite)

Senior Data Analyst (Onsite) Our client, a leading Pacific Northwest utility provider committed to public service and environmental preservation, is looking for a Senior Data Analyst for their Vancouver, Washington location. This onsite position will support Settlement and Market Analysis activities by documenting and producing business analytics solutions that support demand forecasting and day ahead Market Analysis. This assignment will work with business partners to understand business needs, document requirements, and design data models. This position is a one-year renewable contract that includes employee benefits! If you fell that this position aligns with your professional experience, we want to hear from you! Key Responsibilities for Senior Data Analyst: • Provide data analysis for quality assurance testing efforts related to 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 organizational partners including 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 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. Requirements for Senior Data Analyst: • U.S. Citizenship and valid U.S. Driver’s License required. • 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 Associates 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. • 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. • • We are unable to accommodate corp. to corp. candidates • • About Motus Recruiting and Staffing, Inc: Founded in 2006, Motus is an award-winning recruiting and staffing firm in the Pacific Northwest, specializing in professional services and technology solutions. We are a group of people who not only recognize the importance of representation, but actively fight for diversity, equity, and inclusion in the recruitment process. Our goal is to educate organizations on the importance of DEI when hiring, promoting, and supporting diverse employees. We are calling organizations to demonstrate their commitment to DEI by being intentional about who they hire. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, disability or protected veteran status. AG/BH14057