Data Analyst (Remote)

Data Analyst (Remote) Our client, a leading Pacific Northwest utility provider committed to public service and environmental preservation, is looking for a remote Data Analyst. Only candidates that reside in OR, WA, ID or MT will be considered for the position. This position is located in the Data Integration and Reporting organization within the IT department. This position will draft Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects. This position will also support operations and maintenance, as well as provide 24x7 production support on a rotational basis. This Remote position is a one-year renewable contract that includes employee benefits! If this opportunity is well-aligned with your experience and goals, we would love to hear from you! Key Responsibilities for Data Analyst: • Draft Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects. • Draft ETL procedures, batch processes, and scheduling; troubleshoot problems and make suggestions for performance tuning and system integrity. • Develop mappings and workflows in Informatica to automate data integration. • Develop data models and database design techniques, including relational and dimensional modeling. • Effectively map source to target data to meet business/system requirements. • Implement management approved SQL stored procedures and advanced SQL queries. • Assist with the development of functional and technical requirements documents for diverse audience (technical and non-technical), including migration, implementation and test plans. • Draft working documents for interfaces with non-Standard systems. • Debug, analyze and troubleshoot data quality issues. Requirements/Qualifications for Data Analyst: • Bachelor’s degree in information/computer technology or a closely-related field is preferred. • 5 years of experience is required with an applicable bachelor’s degree. • 9 years of experience is required without a degree or an applicable degree. • Experience should be technical in nature and reflect the duties consistent with the role. • 5 years of experience in Data Integration Techniques. • Oracle 11g, 12g, 18c or 19c. • Writing DDL and creating database objects. • Partitioning database tables. • Creating Oracle procedures, functions and views. • ETL tool such as Informatica Suite (including Power Center and Power Exchange) or an equivalent tool. • • 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. ED/BH 13696 Job ID: 13696