SSIS/SSAS Developer - ETL/Data Warehousing AKIRA Insights

3.0 - 7.0 years

0 Lacs

pune, maharashtra

On-site

You will join our data engineering and business intelligence team as an SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services) Developer. Your primary responsibilities will include designing, developing, deploying, and maintaining SSIS packages for ETL processes and managing SSAS cubes for advanced analytics and reporting. Collaboration with business analysts, data architects, and stakeholders to grasp data requirements will be essential. You will need to optimize existing ETL processes for improved performance, scalability, and reliability. Additionally, creating and maintaining technical documentation, monitoring ETL workflows, troubleshooting issues, implementing data quality checks, and performing data validation and unit testing are crucial tasks. Integration of SSIS/SSAS with reporting tools like Power BI, Excel, and participation in code reviews, sprint planning, and agile development are part of your responsibilities. A Bachelor's degree in Computer Science, Information Systems, or a related field, along with at least 3 years of hands-on experience with SSIS and SSAS is required. Strong proficiency in SQL Server, T-SQL, and building both Multidimensional and Tabular SSAS models is necessary. A deep understanding of data warehousing concepts, star/snowflake schema, ETL best practices, and performance tuning in SSIS and SSAS is expected. Proficiency in data visualization tools such as Power BI or Excel (PivotTables) is preferred. Experience with Azure Data Factory, Synapse, or other cloud-based data services, exposure to DevOps CI/CD pipelines for SSIS/SSAS deployments, familiarity with MDX and DAX query languages, and certification in Microsoft SQL Server BI Stack will be advantageous. Strong analytical and problem-solving skills, effective communication, collaboration abilities, and the capacity to work independently while managing multiple tasks are qualities we are looking for in the ideal candidate.,

Posted 2 days ago

Apply

BI Developer (SSAS Tabular Model Cubes) VidPro Consultancy Services

3.0 - 8.0 years

0 Lacs

pune, maharashtra

On-site

As a Business Intelligence Developer, your responsibilities will include designing and implementing SSAS Tabular Models to support reporting and analytics needs. You will be developing complex DAX queries to enhance data models and improve performance. Collaboration with stakeholders to gather requirements and translate them into technical specifications will be a key aspect of your role. It is essential to ensure data integrity and accuracy through rigorous testing and validation processes. Additionally, providing ongoing support and maintenance for existing BI solutions and staying updated with the latest BI trends and technologies to continuously improve solutions will be part of your daily tasks. To qualify for this position, you should hold a Bachelor's degree in Computer Science, Information Technology, or a related field. You must have 3-8 years of experience in business intelligence development. Proficiency in SSAS Tabular Model and DAX is required. A strong understanding of data warehousing concepts and ETL processes is crucial for success in this role. Experience with BI tools and reporting solutions will be beneficial. Key Skills: - Reporting solutions - Data warehousing - ETL processes - SSAS - SSAS Tabular Models - Tabular Models - BI tools - Reporting and analytics - DAX,

Posted 4 days ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.