The MSBI Developer provides solutions using the most appropriate Microsoft and SQL BI feature and should have a solid understanding of the architecture, features available and limitations of various SQL BI solutions. He/ She will also be playing DBA role and responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. Responsibilities: Work with a SQL Server\Microsoft stack-based Business Intelligence System Develop SSIS ETL packages based on business requirements Develop Business Intelligence solutions using Multidimensional and Tabular Cube technologies Assist in DBA responsibilities, backups, performance tuning, troubleshooting Identifying opportunities for Automation and implement them through required approval Complex query tuning and schema refinement. Responsible for reviewing requirements, contributing to design components of ongoing and upcoming projects, and effectively estimating development effort Responsible for developing and documenting the systems, processes and logic required to build system to system integrations Responsible for contributing to data modelling/database design efforts Responsible for delivering quality data integration projects Responsible for hands on development using SSIS and ETL tools and processes Lead and recommend viable solution for Azure implementation methodology (as required) Stay up-to-date on techniques and components being used in the industry through research and applies this knowledge to systems being developed Pro-actively identifying changes needed in the environment lifecycle and make recommendations for improvements with the subsequent implementation Monitor ETL applications for performance and improvement opportunities Ensure the quality, consistency and security of company data and data warehouse systems Requirements: 4 - 7 years SQL Server Development experience required (SQL Server 2014 onwards) Deep understanding of SQL Server Integration Services Knowledge of optimisation techniques for both SSIS and SQL Familiar with Data Warehouse concepts and experience with Star Schema a plus Knowledge of data modelling and designing databases XML, JSON, PowerShell, Rest API experience Good knowledge in Azure implementation Good knowledge in Dashboarding through Power BI or any other equivalent tools. Good knowledge of metadata, and using/managing metadata Experience with SQL Server Analysis services, Tabular and Multidimensional Experience with Performance Tuning and Optimisation (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models. Experience with Redgate Backup tools a plus Excellent written and verbal communication Flexible, team player, get-it-done personality Ability to organise and plan work independently Ability to work within an Agile and ITIL framework Ability to multi-task and context-switch effectively between different activities Microsoft certifications a plus Experience with API based integrations a plus (we use various cloud applications as data sources)
Rorko is looking for a Data Visualization Engineer experienced with up to 1 year of experience in relevant fields. The candidate should have the ability to represent data in a manner that non-technical people can understand. They should be able to create dynamic data visualizations to help our clients make meaningful decisions in an interactive, web-based format.
- Prior experience in Business Analytics and knowledge of related analysis or visualization tools- Expecting a minimum of 2-4 years of relevant experience- You will be managing a team of 3 currently- Take up the ownership of developing and managing one of the largest and richest food (recipe, menu, and CPG) databases- Interactions with cross-functional teams (Business, Food Science, Product, and Tech) on a regular basis to pan the future of client and internal food data management- Should have a natural flair for playing with numbers and data and have a keen eye for detail and quality- Will spearhead the Ops team in achieving the targets while maintaining a staunch attentiveness to Coverage, Completeness, and Quality of the data- Shall program and manage projects while identifying opportunities to optimize costs and processes.- Good business acumen, in creating logic & process flows, quick and smart decision-making skills are expected- Will also be responsible for the recruitment, induction and training new members as well- Setting competitive team targets. Guide and support the team members to go the extra mile and achieve set targetsAdded Advantages :- Experience in a Food Sector / Insights company- Has a passion for exploring different cuisines- Understands industry-related jargons and has a natural flair towards learning more about anything related to food
Hi All Greetings from CareerNet Technologies ! Its pleasure talking to you. Please find below the details: Please find below the details: Role: Power BI Developer Company: KOCH (https://www.kochind.com) Type: Permanent (Direct payroll) Edu: Any Full time Graduates Exp : 4+ YrsJob Location: Kundalahalli,Near Brookefield Hospital, Bangalore -560037 And as discussed, PFA the JDs and company details and it's principles. Job Description: 3+ years’ experience developing and implementing enterprise-scale reports and dashboards. Proficiency with MS Power BI / SSRS. Knowledge of logical and physical data modeling concepts (relational and dimensional). Understanding of structured query language (SQL).
Power BI Experience: 2-3 years Skills: Power BI Start date : Looking out for Immediate Joiners Contract position for 3 months Location Bangalore Job Designation Power BI Developer : 1. To Develop Power BI reports & effective dashboards after gathering and translating end user requirements. 2. To have Ability to turn large amounts of raw data into actionable information. 3. Be responsible for the performance and usability of the system 4. To Perform optimization of MS SQL Queries and SSIS packages 5. To Provide solutions using SSAS cubes (Tabular/Multidimensional Models) 6. Must have excellent experience in MS SQL Server - writing queries, joints, stored procedures, functions etc Candidate should have the knowledge of: Power BI with DAX query, Multiple Data Sources and Relationships of data Power BI Architecture Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop Hands-on professional with thorough knowledge of scripting, data source integration and advanced GUI development in Power BI. Familiar with Power BI custom add-on development & deployment. Connecting Power BI with on-premise and cloud computing platforms. To provide optimized SQL Scripts for complex scenarios Business Intelligence Systems & Tools (Microsoft Power BI, SQL Server Reporting Services) Good understanding of the processes of data quality, data cleansing and data transformation
Critical Tasks and Expected Contributions/Results : The role will be primarily focused on the design, development and testing of ETL workflows (using Talend) as well as the batch management and error handling processes. Build Business Intelligence Applications using tools like Power BI. Additional responsibilities include the documentation of technical specifications and related project artefacts. - Gather requirement and propose possible ETL solutions for in-house designed Data Warehouse - Analyze & translate functional specifications & change requests into technical specifications. - Design and Creating star schema data models - Design, Build and Implement Business Intelligence Solutions using Power BI - Develop, implement & test ETL program logic. - Deployment and support any related issues Key Competency : - A good understanding of the concepts and best practices of data warehouse ETL design and be able to apply these suitably to solve specific business needs. - Expert knowledge of ETL tool like Talend - Have more than 8 years experience in designing and developing ETL work packages, and be able to demonstrate expertise in ETL tool- Talend - Knowledge of BI tools like Power BI is required - Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively. - Exposure to Performance tuning is essential - Good organisational skills. - Methodical and structured approach to design and development. - Good interpersonal skills.