Senior SQL/BI Engineer (12+ years Exp Mandatory)

Job Description: Senior SQL/BI Engineer

Location: Remote

Duration: Long-term Contract

Experience Required: 12 years

Must have Skills: Amazon Redshift, SQL Server, and ETL development

Job Summary:

We are seeking a Senior SQL/BI Engineer with extensive experience in Amazon Redshift, SQL Server, and ETL development to design and maintain scalable data warehouse solutions. The ideal candidate should be proficient in developing and optimizing ETL pipelines, designing complex SQL queries, and creating interactive reports using SSRS, Tableau, and Power BI.

The candidate will be responsible for building end-to-end data solutions, automating operational processes, and ensuring data integrity while working closely with cross-functional teams to meet business goals.

Key Responsibilities:

Data Warehouse Design & Implementation:

• Design and develop multi-terabyte Data Warehouse solutions using Amazon Redshift.
• Migrate on-premise database structures to Amazon Redshift and SQL Azure.
• Define and implement best practices for data storage, partitioning, and performance tuning.

ETL & Data Integration:

• Develop, implement, and manage ETL solutions using SQL Server Integration Services (SSIS).
• Build ETL pipelines for data ingestion, transformation, and load processes.
• Automate operational processes and optimize ETL workflows for performance and scalability.

SQL Development & Performance Tuning:

• Write complex T-SQL queries, stored procedures, triggers, and functions.
• Optimize SQL queries, analyze query performance, and fine-tune workloads.
• Implement Workload Management (WLM) for query prioritization in Redshift.

Reporting & Business Intelligence:

• Develop and deploy SSRS reports, Tableau dashboards, and Power BI visualizations.
• Create parameterized and drill-through reports, ensuring high data accuracy.
• Design and maintain OLAP cubes with SQL Server Analysis Services (SSAS).

Data Modeling & Governance:

• Design and maintain Star and Snowflake Schema models for OLAP and OLTP environments.
• Implement and maintain referential integrity, constraints, and indexing strategies.
• Collaborate with business analysts and stakeholders to ensure data integrity and security.

Cloud & Automation:

• Implement cloud-based data pipelines using AWS Redshift, RDS, and S3.
• Define and deploy monitoring, metrics, and logging systems on AWS.
• Automate data ingestion processes and ensure high availability and disaster recovery.

Required Skills & Experience:

Education:

• Bachelor’s Degree in Computer Science, Information Technology, or a related field.

Technical Expertise:

• Strong experience with Amazon Redshift, SQL Azure, SQL Server (2016/2012/2008 R2), and DB2.
• Hands-on experience in designing and implementing ETL pipelines using SSIS.
• Expertise in developing reports using SSRS, Tableau, and Power BI.
• Proficiency in T-SQL, C#, Python, XML, and JavaScript.

Data Modeling & BI:

• Strong knowledge of data modeling (Star and Snowflake Schema) and referential integrity concepts.
• Hands-on experience in building and maintaining OLAP cubes using SSAS.

Cloud & Automation:

• Experience with AWS Cloud Services including Redshift, RDS, and S3.
• Implementing data pipelines, workload management, and monitoring on AWS.

Tools & Utilities:

• SQL Server Management Studio, SQL Profiler, Visual Studio, BIDS, GitHub, and Team Foundation Server (TFS).

Preferred Qualifications:

• Experience in performance tuning, query optimization, and workload management.
• Working knowledge of Azure Synapse and Snowflake.

Certification in AWS or Microsoft SQL Server is a plus