Description

Design, develop, and maintain reporting and analysis modules while optimizing database performance and data flows.

This role is on-site.

Responsibilities

• Design and maintain reporting and analysis modules using SQL Server, SSAS, and SSRS.
• Migrate existing SQL code to ETL pipelines using SSIS or Informatica.
• Optimize database performance through indexing, partitioning, and statistics management.
• Build and maintain CI/CD pipelines for database deployments using Ansible, Bitbucket, Jenkins, or Datical.
• Implement and manage automated job scheduling and execution via Autosys.

Required Skills

• 10+ years of experience in Microsoft SQL database programming and development.
• Extensive experience building reporting modules using Data Marts, SSAS Cubes, and SSRS.
• Strong proficiency with the Microsoft BI stack, including SSRS, SSIS, and SSAS (Star Schema).
• Expertise in data normalization, denormalization, and compression techniques.
• Experience designing and optimizing data flows across multiple ETL processes.
• Hands-on experience with CI/CD pipeline tools such as Ansible, Bitbucket, Jenkins, and Datical.
• Proven ability in database optimization using indexing, partitioning, and resource utilization analysis.
• Experience with job scheduling and triggering mechanisms like Autosys.

Preferred Skills

• Experience with database upgrades and regression testing.
• Exposure to Big Data technologies like Spark and Hadoop.
• Experience working within Agile methodologies.

Key Skills

Education

BS/MS in Computer Science