Database Developer with SSAS

Job Description:

We are seeking a skilled and experienced Database Developer with expertise in SQL Server Analysis Services (SSAS) and Azure to join our team. As a Database Developer, you will play a critical role in designing, developing, and maintaining our data infrastructure and analytical solutions.
Responsibilities:

Database Development: Design, develop, and maintain relational databases using Microsoft SQL Server and Azure technologies. Create and optimize database schema, tables, views, and stored procedures to support data storage and retrieval.
SSAS Development: Design, develop, and maintain multidimensional and tabular models using SQL Server Analysis Services (SSAS). Build and optimize cubes, dimensions, measures, and calculations to enable efficient and accurate data analysis and reporting.
ETL Development: Develop and optimize Extract, Transform, Load (ETL) processes to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse. Utilize tools such as Azure Data Factory, SQL Server Integration Services (SSIS), or similar technologies for data integration.
Data Modeling: Collaborate with data architects and business analysts to understand data requirements and translate them into effective data models. Apply best practices for data modeling, normalization, and performance optimization.
Performance Tuning: Identify and resolve performance bottlenecks in database queries, SSAS cubes, and ETL processes. Optimize data access patterns, indexing strategies, and query execution plans to improve system performance.
Data Security: Implement and maintain data security measures, including role-based access control (RBAC), encryption, and data masking. Ensure compliance with data privacy regulations and company policies.
Monitoring and Troubleshooting: Monitor database and SSAS performance, proactively identify issues, and troubleshoot problems. Implement monitoring solutions and perform regular performance tuning activities to ensure optimal system performance.
Documentation and Collaboration: Document database designs, data flows, ETL processes, and other relevant technical documentation. Collaborate with cross-functional teams, including developers, data scientists, and business stakeholders, to understand their requirements and provide data solutions.
Continuous Learning: Stay updated with the latest industry trends, best practices, and emerging technologies related to database development, SSAS, and Azure. Share knowledge and provide mentorship to junior team members.
Qualifications:

Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
Strong experience in database development using Microsoft SQL Server.
Proficiency in SQL programming and query optimization.
In-depth knowledge of SQL Server Analysis Services (SSAS) and experience in developing multidimensional and tabular models.
Experience with Azure cloud platforms and services, such as Azure SQL Database, Azure Data Factory, Azure Analysis Services, etc.
Solid understanding of ETL concepts and hands-on experience with tools like SQL Server Integration Services (SSIS) or Azure Data Factory.
Familiarity with data modeling techniques and best practices.
Strong analytical and problem-solving skills with a focus on data quality and accuracy.
Excellent communication and collaboration skills to work effectively in a team environment.
Ability to handle multiple projects and prioritize tasks effectively.
Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Analyst Associate, are a plus.
Join our dynamic team and contribute to the development of scalable and efficient data solutions using SSAS and Azure technologies. Apply your expertise to drive data-driven insights and help shape the future of our organization