Key Responsibilities : · Develop and optimize database schemas, including table design, indexing, and relationships to ensure efficient data retrieval and storage. · Maintain high data quality standards, developing scalable database structures for reporting and analysis. · Develop complex stored procedures and functions that align with business requirements and optimize database performance. · Troubleshoot and refine existing SPs, ensuring efficient query performance and minimal resource usage. · Design, create, and manage SQL Server Integration Services (SSIS) packages to support ETL processes and data migrations. · Set up, monitor, and troubleshoot scheduled SSIS jobs for data flow automation and reporting requirements. · Perform database health checks, backups, and recovery tasks to ensure data availability and integrity. · Implement and monitor security measures to safeguard sensitive data and ensure compliance. · Establish and enforce standards for data integrity and quality across all database operations. · Collaborate with teams to develop policies and procedures for managing data compliance and security · Diagnose and resolve performance issues using tools like indexing, query optimization, and partitioning. · Conduct query analysis and tuning to reduce load times and increase system efficiency. · Document database structures, stored procedures, and SSIS workflows for knowledge sharing and future reference. · Work closely with cross-functional teams, gathering requirements and providing technical support. Requirements: Experience: 3-5 years in SQL development, specifically with Microsoft SQL Server (MSSQL) or similar relational databases. Technical Skills: · Proficiency in T-SQL, table design, stored procedure creation, and SSIS package management. · Familiarity with other database management practices, including indexing, partitioning, and security protocols. · Strong troubleshooting skills for identifying and resolving database performance issues. · Knowledge of database backup, recovery, and maintenance best practices. What We Offer : · Supportive and collaborative team environment · Work on exciting and challenging projects · Flexible work setup · Competitive salary and career growth opportunities Interested? Send your resume to recruiting@answergen.com! Job Type: Full-time Benefits: Provident Fund Work Location: In person
Role Overview: As a Power BI Developer based in Kochi, your role involves transforming data into actionable insights and creating visually appealing dashboards. You will be responsible for data analysis, reporting, dashboard development, collaboration with stakeholders, maintenance, and improvements of Power BI solutions. Key Responsibilities: - Gather and analyse business requirements to design and develop Power BI reports and dashboards. - Extract, transform, and load (ETL) data from various sources into Power BI. - Create data models and perform data analysis to identify trends and insights. - Develop complex DAX queries and calculations to support reporting needs. - Design, develop, and deploy interactive dashboards and reports that provide actionable insights. - Ensure data accuracy and integrity in all reports and dashboards. - Optimize Power BI solutions for performance and usability. - Work closely with business stakeholders to understand their reporting needs and provide effective solutions. - Collaborate with data engineers and IT teams to ensure seamless data integration. - Provide training and support to end-users on Power BI functionalities. - Monitor and maintain existing Power BI solutions, making updates and improvements as needed. - Stay up to date with the latest Power BI features and best practices. - Implement and maintain data security and governance policies within Power BI. Qualification Required: - Education: Bachelors degree in computer science/Information Technology/Data Science or a related field. - Experience: Proven experience as a Power BI Developer or in a similar role. Strong background in data analysis, business intelligence, and data visualization. Experience with ETL processes and data modelling. - Technical Skills: Proficiency in Microsoft Power BI, including Power BI Desktop, Power BI Service, and Power BI Report Server. Strong understanding of DAX (Data Analysis Expressions) and Power Query (M language). Experience with SQL and database management systems (e.g., SQL Server, Oracle, etc.). Familiarity with data warehousing concepts and tools. If you are passionate about leveraging data to drive insights and have the required skills and experience, please send your resume to recruiting@answergen.com.,