Skip to Main Content

Technical Analyst EDW and Data Lake

Wollborg Michelson Recruiting
Phoenix, AZ
  • Expired: over a month ago. Applications are no longer accepted.
Job Description

Technical Analyst EDW and Data Lake IV opening with a GREAT Healthcare organization in the Phoenix area.

 

DUTIES:

Develops technical documentation, designs, analyzes, tests, provides end user support and training for new applications and data structures; and provides post-implementation review for systems and reporting to support customers and management.

 

LEVEL 1

PRODUCTION SUPPORT

  • Track and resolve basic or routine processing problems, coordinating with all areas.
  • Research, analyze, track and resolve basic production problems.
  • Develop business objectives, processing requirements, and technical specifications.
  • Analyze files and map data from one system to another.
  • Responsible for production cycles, solving production incidents and notification of problems.
  • Write SQL queries needed for production support.

QUALITY ASSURANCE

  • Develop basic test data.
  • Process test files and analyze test results.
  • Perform execution of test cases/scripts, document results, log defects, and regression testing of defects.
  • Perform test execution and defect reporting utilizing testing tools.
  • Assist with root cause analysis and triage of key/critical defects for quick turn-around.
  • Monitor and track traceability of business requirements to text execution.
  • Participate in defect review meetings to explain and/or demonstrate defects.
  • Develop and maintain SQL queries to test results and to create mockup data for testing and reporting.

TECHNICAL ANALYSIS

  • Learn business and systems data and process flows; and how they affect surrounding systems and operational areas.
  • Research and analyze application procedural problems and provide recommendations for improvements and changes.
  • Develop functional & technical specifications, logic flows and other documentation as applicable.
  • Synthesize complex or diverse information, collect and research data, use intuition and experience to complement data, workflows, and procedures.
  • Review computer system capabilities, workflow, and scheduling limitations to determine if requested application or application change is possible within the existing system.
  • Translate business needs into technical solutions with knowledge of programming languages (SQL, C# or VB.net, ETL, SOA, and OLAP).
  • Participate in maintaining operational and disaster-recovery procedures.
  • Write or modify procedures for internal use, operational procedures, and computer operations, as applicable.

PROJECT MANAGEMENT

  • Participate on small to large, scoped projects.
  • Use sound project management methodology and demonstrate solid time management skills.
  • Create and deliver presentations.
  • Monitor and create priority list(s) that are agreed to by user management.

LEVEL 2

  • Research, analyze, track and resolve moderately complex production problems.
  • Work with IT Infrastructure team to develop and implement effective production monitoring.
  • Ensure the department leverages internal tools and applications effectively.
  • Build, support, and maintain moderately complex processes, programs, and data.
  • Participate or lead medium to large, scoped projects.
  • Create moderately complex ad-hoc reports for internal usage and external usage.
  • Develop project plans, time estimates and project schedules based on prioritization and business requirements.
  • Research and become proficient in one or more applications or data marts.

LEVEL 3

  • Research, analyze, track and resolve high complex production problems
  • Work with IT Infrastructure team to develop and implement effective production monitoring.
  • Ensure the department leverages internal tools and applications

 

SKILLS:

REQUIRED COMPETENCIES

1. Required Job Skills

  • Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones.
  • Intermediate PC proficiency.
  • Intermediate proficiency in spreadsheet, database, flow charting, and word processing software.
  • Intermediate knowledge of data mapping techniques and data analysis software.
  • Intermediate knowledge of computer operating systems.
  • Intermediate knowledge of Microsoft Applications and Suites, Windows Server, and Microsoft SQL databases.

2. Required Professional Competencies

  • Strong analytical skills to support independent and effective decisions.
  • Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints.
  • Perseverance in the face of resistance or setbacks.
  • Effective interpersonal skills and ability to maintain positive working relationship with others.
  • Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.
  • Systems research and analysis. Ability to write and present business intelligence documentation.
  • Demonstrate the ability to stay current on global threats and vulnerabilities.
  • Experience working with and managing third parties.
  • Knowledge of business requirements development and user acceptance testing.
  • Maintain confidentiality and privacy.
  • Analytical knowledge necessary to generate reports based on available data and then make decisions based on reported data.
  • Understanding of data governance best practices and data quality improvement principles.

3. Required Leadership Experience and Competencies

  • Facilitate and resolve customer requests and inquiries for all levels of management within the Corporation.
  • Build synergy with a diverse team in an ever-changing environment.

PREFERRED COMPETENCIES

1. Preferred Job Skills

  • Knowledge of HIPAA regulations
  • Advanced proficiency in spreadsheet, SQL queries, database, flow charting, and word processing software
  • Advanced knowledge of data mapping techniques
  • Advanced knowledge of computer operating systems
  • Advanced knowledge of decision support systems
  • Advanced knowledge of programming, database systems, and data management.
  • Advanced knowledge of decision support systems
  • Advanced knowledge of Business Objects

2. Preferred Professional Competencies

  • Advanced systems research and analysis expertise
  • Impeccable project management skills
  • Solid technical ability and problem-solving skills
  • Knowledge of internal departments and operations
  • Strong technical documentation skills and a strong ability to translate technical concepts so that they are easily understood by laypersons

3. Preferred Leadership Experience and Competencies

  • Ability to provide mentoring and peer review to junior team members
  • Ability to build lesson plans and deliver lessons to junior team members  

 

EDUCATION:

Required Education

  • High-School Diploma or GED in general field of study

Preferred Education

  • Bachelor’s Degree in Computer Science, Information Systems, Business, or related field

Required Work Experience

  • 3 years of experience in computer technology and/or information systems
  • 2 years of experience in data analysis, data management and integration, extracting and analysis reporting.

Preferred Work Experience

  • 2 years of experience working in healthcare-related systems as a business / systems analyst or programmer
  • 5 years of experience in data analysis, management, integration, and reporting
  • 3 years of experience working in corporate enterprise-level systems as a business or systems analyst or programmer

 

Wollborg Michelson Recruiting does require all applicants to be able to provide proof that they are fully vaccinated from COVID prior to their start date, unless otherwise prohibited by law.
Wollborg Michelson Recruiting is an Equal Opportunity Employer and prohibits discrimination of any kind. We ensure job offers are made based of one’s employment experience, skills, and qualifications, regardless of race, gender, ethnic origin, or any other classification protected by law. All applicants must furnish proper identification to prove their legal right to work in the US upon a job offer. We participate in E-Verify to confirm one’s right to work in the US. Wollborg Michelson Recruiting does not provide sponsorship for an employment-based visa status.

 

Wollborg Michelson Recruiting

Address

Phoenix, AZ
USA

Industry

Technology

Website

View all jobs at Wollborg Michelson Recruiting