• Review Business Requirements to create databases with efficient structures
• Create stored procedures, triggers and views
• Identify ETL requirements and design, develop and test complex SSIS solutions
• Monitor and optimize database objects and SQL Server databases (2008 R2, 2014, 2016) using industry-standard tools and practices (SQL Profiler, Analyzer, Query Plans)
• Reverse engineer and understand complex integrations
• Develop and maintain data mappings between source and destination data stores
• Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure
• Must demonstrate strong problem-solving ability, logic and analytical skills
• Participate in data modelling initiatives
• Perform quality assurance and testing at the unit level
• Ability to manage multiple projects in a fast-paced environment
• Ability to work independently and collaborative with other team members
• Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner

Experience

• 3 to 5 years of relevant experience
• Experience in writing optimized queries, stored procedures, views and triggers
• Experience databases backups and restore
• Experience in SSIS and SSRS
• Experience in PowerBI is a plus

Skills

Technical/Domain

• MS Office
• Hands on experience with SQL Server SSIS and ETL processes
• Demonstrable SQL development skills – packages, triggers, views, queries, etc
• Familiarity with designing and implementing ETL in large databases and data warehouses utilizing both relational and dimensional design concepts
• Familiarity with agile development techniques and objectives

Bachelor’s degree in Computer Science/IT

All your information will be kept confidential according to EEO guidelines.