SSIS and Database Developer ClickSquared
General Purpose: Demonstrates broad based technical experience and a thorough understanding of software design principles and methodologies. Builds innovative, scalable, maintainable, and secure web solutions. Strategically designs and implements databases across the organization, while ensuring high levels of data availability. Implements standards and models for database architectures.
Key Roles and Responsibilities:
Completes complex programming tasks consistently within assigned schedule and estimated effort while leading other junior consultants on the project team
Designs, develops, codes, tests and debugs software for applications which require a significant level of technical expertise
Works with technical staff to understand and analyze complex software problems and develops solutions to resolve them
Works as an individual contributor or with a team of software developers to create database and web applications to support clients? marketing initiatives
Analyzes user requirements and designs functional specifications for databases and database applications
Plans, designs and executes system/integration test. Leads unit and system/integration testing efforts. Evaluates testing efforts and alternative solutions, and selects the appropriate solutions for testing issues
Reviews the design documents created by other project team members and is able to identify key processing issues and risks associated with the design
Develops written materials that are clear, concise and contain the appropriate content for the targeted audience
Actively assists other project team members, helping them to better understand their assigned tasks and deliverables
Identifies project issues and risks that may affect the project team and/or project tasks and communicates them up to the appropriate level
Provides input and estimates for detailed project plan
Experience:
BS degree in an Information Systems related or technical area with 3 to 5 years of relevant experience or the equivalent of education and experience
Strong oral and written presentation skills
Works primarily independently following project plan
Additional Skills:
Demonstrates ability to build automated database solutions
Demonstrates mastery of SQL, SSIS and SSRS technologies
Demonstrates a strong understanding of building SQL Server SSIS packages
Demonstrates proficiency in building ETL solutions in a SQL Server environment
Demonstrates a strong understanding of SQL queries, stored procedures, and design
Demonstrated ability in data modeling and database design techniques, in marketing databases and/or data warehouses
Ability to develop, installs, configure and support multi-terabyte database environments
Demonstrates ability to identify data entry, retrieval, change, and delete issues
Ability to identify inefficiencies in databases and leverage solutions
Demonstrates knowledge and practical experience using .NET framework, Windows Forms, ASP, HTML, DHTML and C#
Demonstrates strong understanding of relational database structures, theories, principles, and practices
Knowledge of SQL performance
Knowledge of current database software, protocols, and standards
Experience with data processing flowcharting techniques
Communicates project status, areas of concern and actual plans to re-establish and meet target dates
Demonstrates ability to perform and participate in code and design reviews
Demonstrates ability to lead small to medium sized technical efforts.
Demonstrates ability to make effective presentations in group settings
Develop effective time utilization and take control of your workload planning
| Location: |
Boston, MA
United States
|