Sr. Data Architect

• Expertise in full project life cycle development for implementation and integration of software solution with polished leadership skills and the ability to motivate teams to increase productivity.
• 12 years of Experience Microsoft SQL Server 2014, 2016, SQL Query Analyzer, T-SQL, stored procedures, database design and implementation.
• Provide expert guidance in design development and implementation of database solutions.
• Data architect, capable of designing, defining and implementing data model and schema for operation data store and data warehouse.
• Provide direction and coordination for the development team by identifying best practices in database implementation and mentoring team.
• Ability to identify and put in place methodologies and best practices for team members to improve database and etl process development.
• Experience and knowledge with various Agile project management priciples, Scrum, Kanban, stories, estimation techniques and lean software development.
• Responsible of managing and guiding ETL development through a test-driven approach.
• 10+ of experience providing deep understanding and analysis of requirements and defining strategies and architecture plans for implementation.
• Highly skilled data analyst capable of understanding and designing complex data driven domain systems.
• Senior ETL developer with 7+ years demonstrable experience using ETL tools with SQL Server 2008, SQL Server Integration Services 2008, Altova MapForce experience preferred.
• Strong knowledge of and experience with  Data Warehousing methodologies and architectures, including and not limited to: ETL design, staging, transformations, delta/change data capture, star-schemas, snowflakes, cubes, history loading, dimensional modeling and reporting tools.
• Should have good understanding of SSIS architecture and SQL Server data base artifacts
• Experience in analysis, design and construction of data marts and data warehouses from functional and system requirements as well as existing data structures.
• Experience creating and administering databases.  Hands on experience in MS SQL db a must.  Must be able to dive into database and recommend strategies to improve performance, scalability, and security of application.
• Strong in T-SQL, Stored Procedures and other database related artifacts.  Strong SQL architecting experience.
• Must demonstrate the ability to analyze, research or query existing relational and dimensional databases using SQL.
• Experience in performance tuning of database execution.
• Demonstrated understanding of Test Driven Development (TDD) and an understanding of the principles of Lean Software Development is a desired.
• Ability and willingness to follow established development and testing practices.
• Strong .Net application knowledge preferred.
• Bachelor’s degree or higher in computer technology discipline is desired.