Description

You will design and develop business intelligence database solutions to support Tableau and Power BI analytics while managing SQL Server environments.

Responsibilities

• Design new database structures, including tables, relationships, and data integrity constraints, using normalization and denormalization techniques.
• Develop complex SQL queries, stored procedures, views, and functions to support data requirements.
• Manage and maintain SQL Server databases, including server management, patching, and regular backups.
• Monitor and troubleshoot agent jobs, SSIIS package runs, and query performance.
• Provision database access roles and conduct periodic audits to ensure compliance.
• Partner with upstream application teams to ensure data accuracy, availability, and timeliness.

Required Skills

• 5+ years of experience as a BI SQL Developer or Database Administrator.
• Expertise in SQL Server administration, including management, monitoring, and performance tuning.
• Strong proficiency with SQL and SSIS for data modeling, ETL, and package maintenance.
• Experience managing both OLAP and OLTP databases.
• Ability to analyze query plans and implement schema, query, and index optimizations.
• Experience working with large, complex data sets and dimensional modeling.
• Knowledge of data warehousing, data blending, and ELT processes.
• Experience gathering functional requirements and writing design specifications.
• Ability to work within Agile SCRUM methodologies.
• 4-year degree in MIS, Information Technology, Computer Science, or a related field.

Key Skills

Education

Any Gradute