General Purpose

This position is responsible for the full life cycle of data solutions within the enterprise data ecosystem.  Deep technical skills in SQL, stored procedures, and SSIS (as shell) development are mandatory.  Experience with AWS leveraged technologies (S3, Redshift, Glue, Athena, Python, Talend) a plus.  Extensive experience in data and data warehouse best practices, standards and methodologies is required. This position will be tasked with activities that span both the SQL Server environment as well as expand in to the S3/Redshift environment.  Solid problem-solving skills are required. Thorough understanding of relational/dimensional models is required.  Familiarity with the Agile/Kanban development methodology and Team Foundation Server/Github (for source code management) is a plus.

Essential Duties/Responsibilities

• Design, develop, test, QA, implement and maintain data movement and transformation solutions using Microsoft SQL Server or other related technologies.
• Provide solutions that are scalable and reliable; solutions will span from easy to very complex
• Develop and maintain database objects, deployment scripts and documentation
• Be trainer, mentor, and evangelist of enterprise data ecosystem, tools, and processes
• Participates in code reviews, and the creation and ongoing refinement of data standards and best practices; aligns to standards / best practices
• Analyze and resolve database and data integration issues; ensure data quality; design/provide data profiling solutions
• Participate in off-hours support rotation
• Active participant in all of the appropriate Agile/Kanban ceremonies
• Document and share knowledge

Job Qualifications

• Required Knowledge, Skills and Attributes
• Extensive data movement/transformation experience with superior attention to detail.
• In-depth experience with formulating data solutions – source data extraction, data staging, data transformation, data maintenance
• Experience with quality assurance techniques and processes
• Proficient with data movement exception handling, self-healing, event triggering, and notifications.
• Solid experience with relational/dimensional data
• Comprehensive experience with stored procedures and query tools. Strong T-SQL skills required, PL/SQL a plus
• Experience with data quality and data profiling techniques
• Familiarity with Agile software development practices and working in an agile methodology
• PowerShell scripting and/or object-oriented programming experience with C# a plus
• Experience with source code management using Team Foundation Server (TFS) / Github is a plus
• Outstanding interpersonal communication and written skills, with the ability to work in a team environment.
• Strong analytical, troubleshooting and organizational skills
• Strong self-starter and results-driven individual
• Excellent written and verbal communication skills
• Required Education and/or Experience
• BS in Computer Science/Computer Engineering, or related discipline, or equivalent work experience
• 5+ years hands on experience within the Data Management and Information Management disciplines
• 5+ years hands on, in-depth experience with SQL and stored procedure development