Data Engineer

Job SummaryThis role is responsible for developing relational database and related reporting solutions that support information systems by studying operations; designing, developing, and deploying solutions; supports and guides data modeling and data access strategies for the software development team.Duties And ResponsibilitiesDesigning and coding database tables to store application dataEnforce referential integrity and business constraintsWorking with application developers to create optimized stored proceduresIdentify and create indexes to improve database performanceTune existing T-SQL queries / stored procedures to improve performanceEnsure that new database code meets company standards for readability, reliability, naming conventions, and performanceQualificationsBachelor's degree in recognized program for information systems or computer science or equivalent experience required.2+ years of SQL Server database development experience.Strong experience with SQL Server queries for all CRUD operationsComfortable with complex joins, nested subqueries, etc.Strong experience with stored procedure creation.Performance tuning / query refactoring a strong plus.Ability to provide quality customer service and teamwork while managing multiple tasks and projects under competing deadlines a must.Excellent verbal and written communication skills.Understanding of IT principles and an ability to communicate technical concepts effectively to a varied audience.Working with Azure and RedGate ToolsUsing Git as source control for backend codeUnderstanding or working knowledge of DevOps processWorking on an Agile / Scrum teamGeneral DBA knowledge (backups, restores, AlwaysOn, Job Scheduling, Alerting, etc.)Extraction, Transformation and Loading (ETL) (Microsoft SSIS)Report Development (Microsoft SSRS)Analytics / OLAP Cube Development (Microsoft SSAS and MDX)