Motus Recruiting and Staffing, Inc. · 10 hours ago
Data Analyst (Remote)
United States
Contract
Remote
Senior Level
5+ years expMotus Recruiting and Staffing, Inc. is seeking a remote Data Analyst for a leading Pacific Northwest utility provider committed to public service and environmental preservation. The role involves drafting ETL procedures, supporting data integration projects, and providing production support while ensuring data quality and system integrity.
Human ResourcesInformation Technology
Hiring Manager
Eric Duncan
Responsibilities
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
Qualification
Required
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
Benefits
Employee benefits
Company
Motus Recruiting and Staffing, Inc.
Founded in 2006, Motus Recruiting is an award-winning firm in the Pacific Northwest specializing in accounting and finance, professional services, technology solutions, and executive search.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Orlando Williams
Chief Executive Officer
Recent News
Company data provided by crunchbase