Senior Business Systems Analyst (Onsite)

Senior Business Systems Analyst (Onsite)
Our client, a leading Pacific Northwest utility provider committed to public service and environmental preservation, is looking for a Business Systems Analyst for their Vancouver, Washington location. This position is a combination of business and data analysis, business systems analysis, and Power BI report development. The primary focus of this role is to perform data modeling, data analysis, and reporting to provide consumable information, visibility into critical data metrics, and insights that assist data driven decision-making. This position promotes data integrity, monitors data quality, and executes timely reporting. This position also involves assessing customer needs, identifying sources of data, and preparing data models and reports (dashboards, visualizations, tables etc.).

This onsite position is a one-year renewable contract that includes employee benefits. If you think this position is a match with regards to your experience and professional goals, we want to hear from you!

Key Responsibilities for Senior Business Systems Analyst:

• Design and develop business intelligence solutions with tools such as Microsoft SSRS and Power BI.
• Provide report troubleshooting using tools such as SQL and database analysis.
• Utilize industry best practices and principles, methods, and procedures in system integration, integrate data from various systems, and optimize information systems components.
• Extract, interpret, and disseminate findings from large datasets.
• Program and refine highly complex, enterprise-level databases to provide efficient, cost effective, and secure data warehouses with integrated automation, governance and standardization.
• Explain and interpret database architecture, data capabilities, and limitations to supervisors, senior management, co-workers, stakeholders, and other interested parties.
• Utilize reverse engineering techniques on de-normalized, unstructured, and undocumented data from large datasets to recommend and deliver solutions to enterprise-level problems.
• Verify compliance with all data security requirements and regulations and facilitate the protection of large volumes of data.
• Work closely with IT groups to coordinate current and future IT plans and activities, including coordination and technical assistance to facilitate specific development projects that involve the computing environment.
• Draft and maintain performance metrics on the quality of key business information.
• Provide various reporting/tracking and variance analysis in support of critical data metrics for Transmission Services.
• Draft and maintain dashboards and internal reports used by managers, VPs and Senior VPs.
• Aggregate overall data collected; calculate performance measurement and report out.
• Draft management reporting tools, such as dashboards, PowerPoints, and spreadsheets that document and communicate the progress of financial and risk related activities to verify timely completion.
• Perform benchmark research activity to verify processes, policies, and other information are collected and organized.
• Assist project manager by collecting current state data across the organization and with analysis of the current state findings as needed.
• Research, analyze, model, and organize information for developing requirements.
• Conduct user, stakeholder, and sponsor interviews and facilitate workshops to elicit business requirements.
• Prepare key project deliverable documents including requirements, process diagrams, system designs, workflow maps, project plans, change management plans, and user plans.
• Assist with QA activities such as testing and validating data including portfolio management reports.
• Document business requirements for identified report users.

Requirements for Senior Business Systems Analyst:

• A degree in Information Technology/Systems, Technology Management, Information Management, Engineering, Business Systems, Computer Science or Technology (or related field) is preferred.
• 8 years of experience is required with an applicable bachelor s degree.
• 10 years of experience is required with an applicable associate degree.
• 12 years of experience is required without a degree or applicable degree.
• Experience should be consistent with the specific requirements of business systems analysis and progressively more technical in nature.
• Experience should include business/process analysis, re-engineering, and optimization in relation to implementing IT systems, Business processes, or Operations Management.
• Experience should also include practical use of modeling languages, technical product life cycle concepts, and requirements engineering,
• 8 years of experience in the following:
• Generating reports from various data repositories.
• Utilizing MS Access database design and administration.
• Utilizing Excel, including pivot tables, charting and reporting
• SSRS and/or SQL.
• 5 years of experience in the following:
• Utilizing Visio and/or other flowchart tools.
• Automating with Visual Basic for Applications (VBA).
• 1 year of experience using Power BI, including ability to write Data Analysis Expressions (DAX).
• Proficient with Power Query Language (M).

**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/BH13287