• Phoenix, AZ
• Salary: $110,000 - $126,000 per year
• Full time Contract

Requisition Id: #1132

REQ#1132

The Sr. ETL Developer contributes to the success by designing and developing complex data-centric solutions, including data warehousing, system integration, ETL & data integration, and BI/semantic models, e.g. SSAS. The incumbent will participate in the full life-cycle of solution implementation, from requirements gathering/review and data modelling through development, testing, implementation and maintenance. Expert level skills with Microsoft SQL Server database and BI technologies and data modeling/architecture are required.

Primary Functions:

• Work with business analysts and subject matter experts to assess and understand business’ data and BI requirements.

• Design, develop and implement and maintain data integration solutions data between operational systems and data warehouses.

• Design and implement robust data models (relational and dimensional) that are right-sized, scalable, and maintainable.

• Ensure that solutions/code are well-managed in source-control.

• Serve as an administrator for data warehouse, reporting, and BI solutions; contribute to database backup/restore strategies, security, and change-management/deployment practices.

• Create and maintain documentation of data-warehouse/BI architecture, including ERDs, process flows, data flow diagrams, etc.

• Mentor other team members, providing design guidance, troubleshooting and code-reviews as necessary.

• Stay current with industry best practices and technologies related to data, reporting, and Business Intelligence (BI), including cloud-based technologies, e.g. SQL Server stack in Azure. Provide guidance as we chart our path to the cloud within the data/BI space.

Skills Required :

• Ability to understand and deconstruct complex business processes, e.g. loan origination & servicing, into meaningful data structures.

• The ability to work in teams (and with individuals) of diverse backgrounds in a cooperative and productive partnership.

• Strong organizational skills and attention to detail, able to work with a minimum of supervision, ability to meet deadlines, work independently, and manage multiple tasks and priorities

• The ability to learn rapidly, to ask relevant and insightful questions, and take instruction constructively.

• The ability to analyze problems, identify root-causes and make good decisions quickly

Required Experience:

• Minimum of five years progressive experience as a Database Developer or DBA, including physical database design/implementation, ETL development, and report development. Experience must include support of DW/BI systems. Experience in healthcare services industry is preferred.

• 5+ years experience directly supporting data warehousing and data integration solutions

• 5+ years experience with the Microsoft SQL Server stack; i.e., SQL Database Engine, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS).

• Advanced experience with the T-SQL scripting/programming language, including the ability to develop, test, and debug complex ad-hoc queries, stored procedures, and data migration scripts.

• Strong knowledge of standard data modeling patterns and best-practices, e.g. 3NF, dimensional models.

• Strong understanding and experience with various ETL/ELT strategies and system design (staging environments, data transformation, change data capture, slowly changing dimensions, etc.), with an eye towards delivering functional, scalable and maintainable solutions in a timely manner.

• 2+ years developing and supporting SSAS Tabular or PowerBI solutions. • Experience supporting user-facing Report/BI tools (SSRS, PowerBI, Tableau, etc.)

Required Education: Bachelors or equivalent work experience

Education Preferred: Masters