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)
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).
Analysis, Design, and hands-on development skills in .NET, SQL Server, Angular.JA, Node.JA, MongoDB, etc.Facilitation and Business Analysis skills.Estimation and Project Planning skills for enterprise level applications.Excellent communication and technical leadership skills.
About AvisoAviso is the AI Compass that guides Sales and Go-to-Market teams to close more deals, accelerate revenue growth, and find their True North. We are a global company with offices in Redwood City, San Francisco, Hyderabad, and Bangalore. Our customers are innovative leaders in their market. We are proud to count Dell, Honeywell, MongoDB, Glassdoor, Splunk, FireEye, and RingCentral as our customers, helping them drive revenue, achieve goals faster, and win in bold new frontiers. Aviso is backed by Storm Ventures, Shasta Ventures, Scale Venture Partners and leading Silicon Valley technology investorsWhat you will be doing:● Manage the scope, execution, and quality of product features from ideation toProduction.● Specify functional requirements for current and future products by conductingmarket research supported by on-going visits to customers and prospects.● Drive a solution set across development teams (primarily Engineering, Machine Learning and the Go-to-Market teams) through business and functional requirements, product design, customer adoption and positioning.● Maintaining the feasibility of the product roadmap● Educate Engineering on the “why” features are being built and “what” they are aiming to accomplish.● Hold Engineering accountable for ensuring the product vision is being maintained.● Translate higher level requirements into Engineering ready specifications.● Experienced working onsite-offshore model.● Own the product vision and deliverables.What you bring:● Take pride in maintaining a unified product vision between Product, Design, andEngineering.● Understand execution is more impactful than ideation.● 3 - 4 years of customer-facing software product management experience● Successful track record of delivering enterprise software products to the market.● Demonstrated record of understanding and empathizing with your target user.● Ability to maintain the product feedback loop between Product, Customer Success, and Sales● Experience working on B2B enterprise applications targeting multiple personas● CRM, Business Intelligence, or SaaS product management experience highly Desirable● Knowledgeable in technology.● Computer Science/Engineering degree or entrepreneurial work experience a strong Plus.● You've been told you're scrappy, a progressive, a roll-up-the-sleeves get stuff done type of person.● You don't leave things to chance and rely on your ability to "wing it" rather you'recalculated, data-minded, prepared and take measured risks. You trust the data not your intuition.● You're resourceful, excellent with defining product user cases and user stories,intellectually curious and ready for new challenges.Aviso offers:● Dynamic, diverse, inclusive startup environment driven by transparency and velocity● Bright, open, sunny working environment and collaborative office space● Convenient office locations in Redwood City, Hyderabad and Bangalore tech hubs● Competitive salaries and company equity, and a focus on developing world-class talent operations● Comprehensive health insurance available (medical) for you and your family● Unlimited leaves with manager approval and a 3 month paid sabbatical after 3 years of service● CEO moonshots projects with cash awards every quarter● Upskilling and learning support including via paid conferences, online courses, and certifications● Every month Rupees 2,500 will be credited to Sodexo meal card
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
Do NOT apply if you are :- Want to be a Power Bi, Qlik, or Tableau only developer.- A machine learning aspirant- A data scientist- Wanting to write Python scripts- Want to do AI - Want to do 'BIG' data- Want to do HADOOP- Fresh GraduateApply if you :- Write SQL for complicated analytical queries . - Understand existing business problem of the client and map their needs to the schema that they have.-Can neatly disassemble the problem into components and solve the needs by using SQL. - Have worked on existing BI products.Develop solutions with our exciting new BI product for our clients.You should be very experienced and comfortable with writing SQL against very complicated schema to help answer business questions.Have an analytical thought process.
Lets discuss - email@example.com / +919972668335
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.
• Proactively assist customers with technical issues that may arise with their solution implementation. Troubleshoot and perform root cause analysis. Identify and provide timely workarounds and solutions when possible, to meet customer’s business needs. • Reproduce in house when possible and file engineering tickets. Work with engineering and product management to prioritize as customer advocate to get resolutions in next release. When possible, analyze code and participate in engineering processes to develop and deploy defect fixes as service packs/hot fixes. • Constantly stay ahead in communicating with customers. Manage expectations properly to avoid escalations. Be a strong voice of customers during engineering planning. • Assist through release cycles in testing new features, enhancements and defect fixes. • Work with client business areas to design, build, enhance, and deliver enterprise wide data analytic dashboards and reports supporting multiple business units. • Collaborate with key business users to identify needs and opportunities for improved data management and delivery. • Design and build ETL processes and scripts. • Provide technical knowledge and business support to the BI team. Candidate fitment: • 6-8 years experience in Cognos Business Analytics Reporting and Analytical roles; proficiency in SQL, Excel, Relational Databases, Oracle, SQL Server • Ability to manage multiple timelines and priorities. • Experience in manufacturing industry is a PLUS. • Highly developed analytical, problem-solving, and consulting skills, with a proven track record of using data to provide actionable business results. • Experience in validating an overall solution from the perspective of performance, scalability, security and capacity. • The ideal candidate is dedicated to making it easy for customers to use our product by leveraging business expertise and using rigorous logic and creative methods to solve difficult problems with effective solutions.
Required Skills :- Detailed understanding and experience with the SAP HANA technology Minimum of 2 full life cycle implementations in SAP HANA SAP HANA modeling and scripting experience which includes ability to write complex stored procedures and scripted HANA views using SQL. Implement data models with SAP HANA using analytical and calculation views. Monitor, investigate and optimize these models and reporting performance on SAP HANA. Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models. Evaluate the impact of different implementation options such as table joins, aggregation, or filters and understand the implication on performance of the various reporting tools and connection types. Apply advanced data modeling techniques, including currency conversion, variables and input parameters. Implement decision automation using business rules. Working knowledge of various data loading and replication methods so to load data into SAP HANA from different data sources (e.g. SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC)) is desirable. Apply SQL Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL Understand and implement HANA Security model. Refer the JD above. APPLY if you have min.1.5 yrs+ experience into SAP HANA Expertise - with end to end implementation handled for SAP HANA.
Sr BI Analyst / Lead BI Analyst Must Have: At least 3 to 6 years of techno functional / technical experience in delivering projects for Large Enterprises Strong background in data analysis, data sources, data warehouse and business intelligence Progressive experience in areas of ETL, Data Modelling, Data Visualization, Reporting and Analytics Familiarity with database concepts, SQL queries, joins and programming Experience in system administration, problem debugging, and solution design Formal education in technology, engineering and programming Ability to demonstrate strong technical aptitude Experience in handling customer communication Ability to manage individual contribution and workload, setting expectations and self-learning Familiarity with self-service BI products such as Tableau, Qlikview, Spotfire, Power BI, MSBI Additional Requirements (Nice to have): Understanding of data challenges encountered by business users Domain expertise to any of the following domains highly desired - Finance, Banking, Insurance, Healthcare, Pharmaceuticals