Sr. Data Warehouse Developer in Dallas, TX at HUNTER Technical Resources

Date Posted: 1/25/2020

Job Snapshot

Job Description

• Create, debug, modify, test, document, maintain, and tune SSAS cubes, SQL code, stored procedures, views, indices.
• Develop reports and application data changes in Production and non-Production environments, implementing various SDLC methodologies, depending on the contextual requirements.
• Collaborate with business teams and other developers to define scope of work, deliverables, and level of effort estimates, milestones, and timelines.

• Analyze business requirements and translate them into technical designs, technical specifications, and code.

• Must be proficient in Microsoft BI stack (SSAS, SSMS, SSRS, SSIS), MS SQL Server 2008/12/14/16+

• Must have Informatica Server Administrator and Informatica Developer experience.

• Must possess clear and concise verbal and non-verbal communication and comprehension skills.

• Must have experience working in OLTP and DSS environments.

• Demonstrate expert-level knowledge of Data Warehouse concepts: OLAP, ETL, Data Marts, Fact/Dimension tables, Normalization, and Star Schemas.

• Demonstrate technical knowledge, skills, and experience with data warehouse development, preferably in the insurance industry and ideally in specialty insurance.

• Bachelor’ s degree preferred with 5 – 7 years experience (Experience can be substituted in lieu of Bachelor’ s degree)

• Strong verbal, reading comprehension, and written communication skills; ability to simplify and articulate technical concepts to non-technical business users