Data Warehouse Programmer/Analyst Needed!

HealthCare Talent; Orange (CA); On-site; USD 80,000 - 100,000; Full time

Job summary

A health services company based in California is seeking a Data Warehouse Programmer/Analyst to develop and support reporting, ETL, and data analysis technologies. Key responsibilities include troubleshooting complex code, collaborating with teams across the organization, and applying extensive SQL Server knowledge. Candidates should have at least 3 years of experience in BI analysis and hold a relevant Bachelor's degree. This full-time position offers opportunities for hands-on development in a dynamic work environment.

Qualifications

• 3-5 years of relational database and reporting development experience.
• 3+ years of BI/data warehousing analysis and development experience.
• 3+ years experience with SQL Server stored procedures and SSIS/DTS packages.

Responsibilities

• Review and troubleshoot complex code designs.
• Maintain and extend server software operation.
• Communicate effectively with team members and clients.

Skills

SQL Server development

ETL processes

Reporting tools (Crystal Reports)

Business Intelligence tools (MicroStrategy)

Problem-solving in fast-paced environments

Effective communication

Education

Bachelor's degree in a related field

Tools

Microsoft SQL Server

SSIS/DTS

Crystal Reports

Microsoft OLAP tools

Microsoft Office Suite

Job description

Data Warehouse Programmer/Analyst Needed!

Full-time

The Data Warehouse (DW) Programmer/Analyst works in conjunction with the Data Warehouse team to develop and support organization-wide reporting, ETL, data warehouse, and data analysis technologies. The DW Programmer/Analyst shall participate in gathering and documenting requirements, designing and building reporting solutions for internal departments. This position will participate in the design and development of data warehouse and reporting infrastructure using SQL Server technologies. The DW Programmer/Analyst shall have a significant role in hands on development as well as high level design of these initiatives.

Responsibilities

• Demonstrate advanced techniques for reviewing and troubleshooting complex code designs written by multiple developers, reverse engineering, identifying incompatibilities and providing alternatives for improved design and performance.
• Knowledge of server software operation, maintenance and extension (using various programming tools) and demonstrated ability to apply this knowledge to multiple server platforms.
• Ability to take direction, accept criticism constructively and to be diplomatic when reviewing work of others.
• Ability to solve problems and work on multiple projects in a fast-paced, deadline-driven environment.
• Build consensus and work effectively within a cross-departmental team.
• Listen to customers (e.g. staff, etc.) to understand and respond positively to their requests.
• Communicate effectively, both verbally and in writing, with all levels of staff and outside vendors.
• Have exceptional initiative and follow-through on projects with minimal supervision and guidance.
• Ability to initiate and maintain cooperative relationships with co-workers, managers and supervisors, customers/clients, and members of the public.

Experience & Education

• 3-5 years general relational database and reporting development experience.
• 3+ years experience with BI/data warehousing analysis and development including database design, ETL and reporting.
• 3+ years experience using Microsoft SQL Server stored procedures and SSIS/DTS packages and using reporting tools such as Crystal Reports and/or Microsoft SQL Server Reporting Services.
• 2+ years experience using Business Intelligence tools (MicroStrategy preferred).
• Bachelor’s degree in a related field.
• Experience using modeling techniques as a tool for application design and development.

Knowledge of

• Advanced knowledge of SQL Server development including database design and stored procedures.
• Advanced knowledge of SSIS/DTS package design and development.
• Advanced knowledge of Crystal Reports and/or Microsoft Reporting Services including report design and development.
• Advanced knowledge of Microsoft OLAP tools and analysis constructs.
• Thorough understanding of Software Development Life Cycle Methodology.
• Knowledge of Microsoft Office Suite, Access and Project.

If you feel that you have the skills we require, please respond to this posting with your contact information and your resume in a Word document. We look forward to hearing from you today!