* Location: Vancouver, Washington
* Type: Contract
* Job #8617
Overview:
ACS Professional Staffing is looking for an employee to work on-site with our client. This Data Analyst 3 will support Settlement and Market Analysis activities by developing and delivering Business Analytics solutions that support CAISO operations and day-ahead market analysis. This role involves collaborating with multiple departments and business partners to understand business needs, document requirements, and design effective data models. This full-time position is located in Vancouver, WA.
Pay range: $54.36 - $77.66
Benefits:
* Paid holidays: 11
* PTO: Starting at 10 days
* Sick Leave: Up to 56 hours per year (prorated based on start date)
* EAP: Employee Assistance Program
* Benefit Options Available: Medical, Dental, Vision, FSA, DCA, LPFSA, HSA, Group Life/AD&D, Voluntary Life/AD&D, Voluntary Short-Term Disability, Voluntary Long-Term Disability, Voluntary Critical Illness, Voluntary Accident, Hospital Indemnity, 401k (immediately eligible for employee and employer contributions - employer match up to 4%)
* Other benefits include the following: Calm App, LifeBalance Discount Program
Responsibilities:
* 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 assigned departments and other 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:
* 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 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 bus
To view the full job description, click here