Database Developer with Cognos & SSIS, SSRS experience

Atria Group LLC; Monroe (LA); On-site; USD 75,000 - 95,000; Full time

Job summary

A Data Solutions Company is seeking a Database Developer with strong SQL and reporting skills to collaborate on data strategy in Monroe, Louisiana. The role involves automating data processes and building robust database systems. Candidates should have a degree in Computer Science and at least 4 years of database development experience. Strong analytical and communication skills are essential for success in this collaborative position.

Qualifications

• 4+ years in the IT industry and understanding of the full life cycle of development.
• 4+ years’ experience in database development in MS SQL Server environments.
• Proficiency in writing SQL queries and stored procedures.

Responsibilities

• Work collaboratively in a distributed international development environment.
• Automate and regulate inbound and outbound data processes.
• Contribute to the design and development of data models.

Skills

Database programming skills

SQL query performance tuning

Analytical skills

Problem-solving skills

Verbal communication skills

Written communication skills

Education

Bachelor’s degree in Computer Science or related field

Tools

MS SQL Server

SQL Server Integration Services

Cognos

SQL Reporting Services

Crystal Reports

Job description

Database Developer with Cognos & SSIS, SSRS experience

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

• 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.