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.