Data Engineer

Job Overview

Location: Centennial, CO Description: Our client is currently seeking a Data Engineer. This job will have the following responsibilities: Proficiency in SQL Server is a MUST, with good understanding of database design and development.Experience with very large databases and/or data warehousing.Develop and maintain SSIS packages using SQL Server 2016 to integrate with other SQL Servers, Oracle, Hadoop systems, flat files, and non-SQL data sources.Familiarity with RDBMS principles, database design and normalization.Understanding of index design and performance-tuning techniques.Understanding of the full development life cycle, development methodologies, and version control.Develop and maintain tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax.Work with the application developer to identify and address performance problems.Provide support for testing effort, including:Developing scripts to load test dataProviding scripts / tools to help automate testingArchiving test dataAdhere to standards for all databases, e.g.,Data modelsData architectureNaming conventionsManage the lifecycle of physical data models and data maps for data warehouse system.Experience with Fuzzy matching techniques.Confer with end-users, peers or senior management to define business requirements.Work with business analysts to translate client requirements into development projects.Day to day support activities, resolve system bugs, assist business staff with questions, investigate issues.Research, relate and recommend technical solutions and relevant software application tools, utilities, environments and languages.Fully document all processes that are being created. Qualifications & Requirements: 5-8 years SQL server experience working with SQL Server 2008 R2 through 2016Excellent T-SQL coding skills using advanced techniquesStrong written, verbal, and graphical communications skills with the ability to express complex technical concepts effectivelyAbility to work well with people from different disciplines with varying degrees of technical experienceAbility to work both independently and with minimal guidance, as well as with a team Contact: This job and many more are available through The Judge Group. Find us on the web at