face to face required. need on our W2. Mid level guy.SQL Developer w/SSRS, SSISDoylestown, PA 18902
6 months' contract
Key technical skill sets are TSQL, SSIS/ETL and SSRS
POSITION SUMMARYDevelop custom applications (business analytics product for healthcare industry) for legacy clients. Create full-cycle enhancements to existing products working with a matrixed team in a fast-paced, Agile/Waterfall hybrid environment.
RESPONSIBILITIES- Develop software features and solutions by studying information needs; conferring with users; studying systems flow, data usage and work processes; investigating problem areas and following all phases of the software development lifecycle: requirements definition, program design, coding, unit and integration testing, deployment and maintenance
- Understand the structure and operation of our applications, as well as the business needs and application use of our customers.
- Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
- Provide information by collecting, analyzing and summarizing development and service issues
- Provide engineering support when building, deploying, configuring and supporting systems for clients
- Support and mentor mid-level software engineers by providing advice, coaching and educational opportunities
- Collaborate with the team to achieve goals, and brainstorm to create new features and products
- Participate with engineering and operations teams to define plans for standardizing, scaling and enhancing products and the services utilized to deploy/install/release those products
- Participate in design and code reviews
- Make informed decisions quickly and take ownership of services and applications
- Be a persistent, creative problem solver
- Manage multiple projects and changing priorities in a fast environment
- Update job knowledge by studying state-of-the-art development tools, programming techniques and practices; and computing equipment; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations
QUALIFICATIONS- 5 years in database development.
- 3-4 years in developing & implementing SQL Server databases in a professional software engineering role.
- 1+ years of designing, developing & testing reports in SSRS, using a Visual Studio development environment and TFS. In-depth knowledge & experience in SSRS is REQUIRED.
- Ability to work with all levels (Database Administrators, Engineers & Developers) to analyze performance and identify problems in areas such as: execution plans, index coverage, SQL server statistics, query optimization
- Ability to implement physical database objects, managing data, extensive knowledge of Transact-SQL, transactions, error handling, etc.
- Demonstrate intermediate (to advanced) understanding of data modeling, schema design, performance tuning and ETL processes that support those models
- Experience in building web-based software systems
- Proficiency with functional, imperative and object-oriented languages; working knowledge of Java
- Experience coding, testing and documenting Drupal themes – including all front end functionality and templates – and modules – using contributed modules and developing custom modules as needed
- Ability to take a project from scoping requirements through actual launch of the project
- Experience in communicating with users, other technical teams and management to collect requirements, identify tasks, provide estimates and meet production deadlines
- Experience with professional software engineering best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing and operations.
- Bachelor's degree in Computer Science, Computer Engineering or similar technical discipline