Data Warehouse Developer - Cary, NC

6 months contract


SMART IT People has a 6 months contract opportunity for a Data Warehouse Developer who will provide and/or facilitate the planning, analysis, design, development, implementation, and maintenance of software, scripts and utilities that support timely and accurate data population of our clients’ data warehouse initiatives.

Responsibilities and Duties

Provide technical expertise necessary to meet the data warehouse project and business requirements as well as production and maintenance in support of assigned project/application areas
Work with other team members to estimate, plan and schedule tasks to meet assigned target dates
Participate in the requirements gathering, preparation of specifications, and design for new projects and/or existing systems
Document new and existing systems, develop workflows, and create other supporting documents in adherence to all departmental and corporate standards, provide a clear audit trail of activities taken on specific program or system projects
Provide input on best practices from infrastructure and architectural perspectives
Obtain approvals and consult with Production Services and Quality Assurance as needed to prepare programs/systems for implementation
Review completed code, documentation and other deliverables to ensure that they meet specifications and requirements based on defined expectations

Qualifications and Skills

Bachelor's degree in Computer Science, Information Systems or Engineering required or equivalent work-related experience
5 years’ of lead experience working in a Microsoft SQL Server data warehouse environment using ETL tools including T-SQL and/or Microsoft SSIS
Demonstrates expertise in data warehouse structure, concepts, and practices, with ability to monitor and tune performance
Expertise in multiple data warehouse/BI related technologies, including DBMS, dimensional warehouses, scripting, and reporting tools
Ability to interpret conceptual, logical and physical ER modelling and dimensional data models
Excellent verbal and written communication skills with the ability to lead collaborative project discussions and present technical solutions to a diverse array of business customers
Demonstrates experience in one or more systems development life cycle (SDLC) methodologies, including those that support agile/iterative development
Demonstrates knowledge of project/system management methodologies
Demonstrated successful ability to build positive relationships and partnerships within department, across the organization and with external customers
Ability to think strategically with supporting analytical and problem-solving skills, including the ability to deal with ambiguity
Healthcare claims experience preferred


Please email your resume to: michael@smart-itpeople.com with job title in subject line.