Location
Phoenix, AZ | United States
Job description
ETL Developer
Location: Phoenix, AZ, 85007 (Onsite)
12 Months Contract
Job Description:
Position Description
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.)
Report this job
- Dice Id: 10282790
- Position Id: 8211974
Job tags
Salary
