Senior BI & ETL Developer

Responsibilities include:  

• Develop and maintain data validation logic in our proprietary Control Framework tool 
• Actively participate in business requirement elaboration and functional design sessions to develop an understanding of our Operational teams’ analytical needs, key data flows and sources 
• Assist Operational teams in the buildout of Checklists and event monitoring workflows within our Enterprise Control Framework platform 
• Build effective working relationships with Operational users, Reporting and IT development teams and business partners across the organization 
• Conduct interviews, generate user stories, develop scenarios and workflow analyses  
• Contribute to the definition of reporting solutions that empower Operational teams to make immediate decisions as to the best course of action 
• Perform some business user acceptance testing 
• Provide production support and troubleshooting for existing operational dashboards  
• Conduct regular demos and training of new features for the stakeholder community 

Qualifications  

• Bachelor’s degree or equivalent in Business, Accounting, Finance, MIS, Information Technology or related field of study 
• Minimum 5 years’ of SQL required 
• Experience querying data on cloud platforms (AWS/ Azure/ Snowflake) required 
• Exceptional problem solving and analytical skills, attention to detail and organization 
• Able to independently troubleshoot and gather supporting evidence  
• Prior experience developing within a BI reporting tool (e.g. Spotfire, Tableau, Looker, Information Builders) a plus  
• Database Management and ETL development experience a plus 
• Self-motivated, self-assured, and self-managed  
• Able to multi-task to meet time-driven goals  
• Asset management experience, including investment operation a plus 

Job Role - Power BI Lead

9 to 12 Years Experience Required. 

Location - Pune Baner/ Vimaan Nagar 

Work Model - Hybrid (Wednesday and Thursday WFO) 12 PM to 9 PM 

Experience with Banking or GRC Domain is preferred. 

• JOB SUMMARY
• Role Overview: We are seeking a highly skilled Power BI Expert to design, develop, implement and governance of Power BI solutions. Ideal candidate will have in-depth knowledge of Power BI architecture, data modeling, governance, embedded analytics and database management. The role requires expertise Power BI Data Gateways, report deployment, and governance frameworks ensuring scalable and secure data solutions.
• PRIMARY RESPONSIBILITIES                                             
• Power BI Lead & Implementation:
•  Design, develop, and deploy interactive Power BI reports and dashboards.
•  Create efficient data models to optimize performance and scalability.
•  Develop complex DAX expressions for business logic and calculations.
•  Optimize report performance by using best practices in Power BI and SQL
• Power BI Architecture & Configuration:
•  Configure and manage Power BI Data Gateways for secure and seamless data access
•  Define and enforce Power BI workspace, dataset, and security policies.
•  Implement row-level security (RLS) and data governance best practices.
•  Establish data refresh schedules and ensure efficient data ingestion pipelines.
•  Maintain and enhance Power BI Premium and Embedded solutions.
• Embedded Analytics & Integration:
•  Integrate Power BI reports with external applications using Power BI Embedded.
•  Work with Power BI REST APIs to automate workflows.
•  Integrate Power BI with Oracle, SQL Server, MySQL, Microsoft Share point, Excel, Cloud data source etc.,
•  Database & Performance Optimization:
•  Write optimized SQL queries and stored procedures for report development.
•  Ensure high-performance data refreshes and query execution.
•  Work with ETL team to improve data integration with PowerBI
•  Governance & Security:
•  Define Power BI governance framework and best practices for standardization.
•  Monitor user access, performance, and usage analytics to drive efficiency.
•  Manage user roles, access controls, and data security.
•  PowerApps & Power Automate (Nice to Have):
•  Build PowerApps applications to extend Power BI functionality and create
• interactive business solutions
•  Automate data flows and reporting updates using Power Automate (Flows,
• Triggers, Approvals, Notifications, etc.).
•  Integrate Power BI, PowerApps, and Power Automate to create end-to-end
• business process automation.
•  Stakeholder Collaboration 
• Training:
•  Work closely with business users, data engineers, and leadership teams to understand and document reporting requirements.
•  Provide training and best practice guidance to Power BI users across the organization.
•  Develop self-service Power BI frameworks to empower business teams for reporting.
•  Troubleshoot Power BI performance and user issues.

Responsibilities and Duties

Develop high-quality software design and architecture.

Achieve the timeline with quality delivery of assigned tasks.

Able to do technical analysis and code review.

Able to troubleshoot internal & production bugs.

Coordinate and support to project co-ordinator/project manager.

Development coding standards are achieved.

Work with internal teams to understand and analyse their needs and to ensure that proposed solution caters to same.

Adopt new technology in quick time.

Implement Unit tests and Functional tests to ascertain highest quality of deliverables.

Identify, prioritize and execute tasks in the software development life cycle.

Understand business needs and know how to implement needs in system to meet business needs.

Able to create the technical documents.

Able to leading team members and planning of team’s task.

Design, develop, modify, implement, and support software components anywhere in the software stack.

Work in close partnership with cross-functional teams and management.

Requirements

Having knowledge of ASP .Net / .net core, Web API, Micro Services, JavaScript, jQuery, Bootstrap, Flutter.

Having good Release management, Cloud Management & Data base management knowledge

Having fluency in Agile methodology

Having knowledge of Power BI / Tablue will be added advantage

Soft skills – Manager level skill

Critical thinker and creative mindset and the ability to approach a problem creatively.

Ability to provide in-depth evaluation and analysis of unique complex technological issues.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

CRM Technical Developer

Country: Malaysia

Cities: Kuala Lumpur

Area of expertise: Customer Relationship Management (CRM)

Job Description

You're a problem solver, knowing the systems, applications, and processes that will make a client happy, no matter how complex the IT solution and integrating architecture. You bring expertise and creativity to designing activities and building system prototypes.

About the job

Business and IT don't always speak the same language. It can be difficult for companies to know how IT can help tackle their problems and increase profitability. They need you to understand their business and translate their needs into a software solution that will realize results. 

As a CRM Technical Developer, you will be familiar with at least one leading commercial CRM system. You will assist delivery teams with CRM solution planning, analysis, designing, building, and testing. You will be considered a product specialist that is also responsible for providing support in CRM issue, customer concern, and resolution. This role is typically focused on more complex assignments, often requiring diverse inputs, processes, and/or outcomes with room for discretion within established parameters.

Day-to-day you will:

• Assist across all phases of projects (e.g. Plan, Analyze, Design, Build, and Test)
• Demonstrate technical knowledge to design and implement CRM solutions
• Research customer issues that may be non-standard in order to offer solutions
• Support design of conceptual architecture and technical solutions
• Ensure project quality meets standards through critical metric identification and testing plan
• Identify process gaps and work cross-functionally to formulate improvement plans
• Travel as needed

Key Role Skill & Capability Requirements:

You are passionate about working with a global technology leader to solve business-critical problems for some of the top companies in the world. You are a fast learner, a self-starter, and a creative problem solver. You are passionate about software and its potential to move organizations forward through innovation.

Your technical skills may include:

• Design, develop, deploy, customize and integrate Microsoft Dynamics CRM with other systems
• Configure and customize on standard workflows, dashboards, forms, views and develop standard or custom reports
• Develop reports or dashboards using PowerBI and integrate with D365CS
• Develop web application, web API, console application, window services to integrate with D365CS
• Develop a script to migrate existing CRM to D365CS
• Complete the documentation required including the source codes, technical specification, and unit test result
• Support SIT, UAT, and production and fix the defect within the agreed SLA
• Strong understanding of Microsoft Dynamic365 CRM, with domain knowledge in Customer Service and Telco industry - this would be a plus point
• Develop Power BI reports and integration to Microsoft Dynamic 365 CRM

Your non-technical skills may include:

• Client management skills and the ability to work with customers to develop and manage an action plan
• Some consulting experience working with external clients
• Experience working with global/offshore teams
• Excellent communication skills

Preferred Education Background:

Bachelor's degree in a relevant field preferred.

Preferred Years of Work Experience:

• Minimum 3 year of Microsoft Dynamic 365 CRM and Power BI development experiences
• Minimum 3 year of experience in ASP.NET C# development, JavaScript, HTML 5, CSS and other web base technology and tools
• Experience with Microsoft Dynamics 365 Field Service is essential

• Creating, designing and developing data models
• Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
• Validating results and creating business reports
• Monitoring and tuning data loads and queries
• Develop and prepare a schedule for a new data warehouse
• Analyze large databases and recommend appropriate optimization for the same
• Administer all requirements and design various functional specifications for data
• Provide support to the Software Development Life cycle
• Prepare various code designs and ensure efficient implementation of the same
• Evaluate all codes and ensure the quality of all project deliverables
• Monitor data warehouse work and provide subject matter expertise
• Hands-on BI practices, data structures, data modeling, SQL skills

Hard Skills for a Data Warehouse Developer:

• Hands-on experience with ETL tools e.g., DataStage, Informatica, Pentaho, Talend
• Sound knowledge of https://www.freelancermap.com/it-projects/sql-1084" target="_blank">SQL
• Experience with SQL databases such as Oracle, DB2, and SQL
• Experience using Data Warehouse platforms e.g., SAP, Birst
• Experience designing, developing, and implementing Data Warehouse solutions
• Project management and system development methodology
• Ability to proactively research solutions and best practices

Soft Skills for Data Warehouse Developers:

• Excellent Analytical skills
• Excellent verbal and written communications
• Strong organization skills
• Ability to work on a team, as well as independently

We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.

Requirements:

• Qualification: Engineering Graduate.
• Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
• Strong understanding of ETL/ELT concepts.
• Hands on experience on Azure Data Factory.
• Exposure of Cloud technologies, standards, and platforms.
• Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
• Strong Experience on SSIS.
• Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
• Azure Data Warehouse.
• Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
• Azure Data Migration tool.
• Well versed with RDBMS systems like Sql server, DDL, DML scripts.
• Sound knowledge of T-SQL and stored procedures.
• Strong Query writing skills, Scheduling tools.
• Ensure quality deliverable and ability to extend work hours if required.
• Azure Certification: Preferred.
• Ability to understand Customer requirements and convert the requirements into technical specifications.
• Ability to understand the overall solution and design components to fit the overall solution.
• Ability to take technical decisions and support the decisions with justifications.
• Ability to work in Agile manner.
• Ability to work independently without much guidance.
• Self-Motivated, team player, results oriented, strong Time Management skills.
• Excellent written and verbal communication skills.
• Willing to travel to outside India (Short term as well as long term)