Data Warehouse Analyst II — Hybrid BI & ETL Focus

SwitchThink Solutions LLC; Phoenix (AZ); Hybrid; USD 75,000 - 110,000; Full time

Job summary

SwitchThink Solutions LLC in Phoenix, AZ, is seeking a data-focused professional to gather business requirements, design, develop, and deliver data extracts, interfaces and reports. You will provide daily operational support and help implement data warehouse and reporting standards to support business goals.

The role requires 4+ years in a team setting, strong SQL and ETL experience, and proven report-writing and data modeling abilities. A Bachelor’s in IT/IS or equivalent is preferred.

Qualifications

• Bachelor's degree or some college courses; Information Technology or Information Systems (preferred) OR equivalent combination of education and experience
• 4+ years experience working in a team-oriented, collaborative environment in a similar position/role
• 4+ years experience with reporting tools, software, and applications including SQL Reporting Services
• 3+ years experience with financial services industry core and ancillary systems and business processes
• 3+ years experience in using ETL tools. Experience with databases, data warehouse or data lakes
• Proven experience with report writing, technical requirements analysis and data modeling
• Moderate SQL programming
• Practical knowledge in importing data for use in reports, spreadsheets and graphs
• Excellent Analytical, Mathematical, And Creative Problem-solving Skills Required.
• Excellent listening, interpersonal, written and oral communication skills
• Logical and efficient with keen attention to detail
• Ability to effectively prioritize and execute tasks while under pressure
• Strong Customer Service Skills Required.

Responsibilities

• Gather business requirements to design, develop and deliver data extracts, interfaces and reports
• Provides daily Operational support to assess and resolve break/fix related issues
• Participates in the design, development, and implementation of solutions to support Business goals
• Participates in the development and provides guidance in the creation of data warehouse and report development standards
• Perform other job-related duties as assigned.

Skills

Analytical skills

Problem-solving

Communication

Teamwork

Prioritization

Attention to detail

Customer service

Creative thinking

SQL programming

Data storytelling

Education

Bachelor's degree in IT/IS or equivalent

Information Technology or Information Systems degree (preferred)

Tools

SQL Reporting Services

ETL tools

Databases

Data warehouse

Data lakes

Job description

SwitchThink Solutions LLC in Phoenix, AZ, is seeking a data-focused professional to gather business requirements, design, develop, and deliver data extracts, interfaces and reports. You will provide daily operational support and help implement data warehouse and reporting standards to support business goals.

The role requires 4+ years in a team setting, strong SQL and ETL experience, and proven report-writing and data modeling abilities. A Bachelor’s in IT/IS or equivalent is preferred.