Database Developer with Cognos & SSIS, SSRS experience

Company Description

Atria Group LLC

Job Description

Summary

The Database Developer / Administrator is responsible for database development and technical knowledge in multiple database development efforts. As a member of the Data Governance team, this position will work closely with Product Management and Development to build and maintain a cohesive data strategy for LeasingDesk Screening and Insurance. This position will perform data analysis and create reports for Screening and Insurance data for customers as well as management.

PRIMARY RESPONSIBILITIES

Responsibilities include, but are not limited to:

• Work collaboratively in a distributed international development environment.

• Work with development team to meet technical expectations and goals.

• Automate and regulate all inbound and outbound data processes and data flows in the LeasingDesk Screening and Insurance domain.

• Establish process performance baselines to enable improvement efforts.

• Decrease the risk of regulatory fines through data security, monitoring, and logging.

• Contribute to the design and development of data models and database architecture.

• Understand business requirements and translate them into technical specifications.

• Construct, install, and test databases and stored procedures.

• Modify existing Screening and Insurance databases and stored procedures as needed. • Design and develop reports from SQL as needed.

REQUIRED KNOWLEDGE/SKILLS/ABILITIES

• Bachelor’s degree in Computer Science or related required; equivalent related experience may be considered in lieu of degree

• 4+ years in the IT industry and an understanding of the full life cycle of development

• 4+ years’ experience in database development in MS SQL Server environments. (SQL 2005 and 2008)

• Experience in Crystal, Cognos and SQL Reporting Services skills strongly preferred

• Experience and knowledge with SQL Server Integration Services

• Experience with statistical analysis of data is a significant plus

• SharePoint skills are a plus.

• Must have good database programming skills covering development of stored procedures and functions, and tuning SQL queries for optimal performance.

• Strong problem-solving, analytical and innovation skills

• Strong written and verbal communication skills

• Must have a thorough understanding of database fundamentals including design, implementation, maintenance, recovery, back-up, and performance tuning.

• Proficiency in writing SQL queries and stored procedures.

• Ability to work effectively with others in a collaborative team environment

• Manage work assignments to meet deadlines under an aggressive schedule; overtime may be required to meet departmental deadlines.

Additional Information

Start date – ASAP.

1+ year contract