Our Company
Changing the world through digital experiences is what Adobe’s all about. We give everyone—from emerging artists to global brands—everything they need to design and deliver exceptional digital experiences! We’re passionate about empowering people to create beautiful and powerful images, videos, and apps, and transform how companies interact with customers across every screen.
We’re on a mission to hire the very best and are committed to creating exceptional employee experiences where everyone is respected and has access to equal opportunity. We realize that new ideas can come from everywhere in the organization, and we know the next big idea could be yours!
Job Description:
The Strategy & Solution team at Adobe, Bangalore is seeking a passionate and skilled Data & Insight Analyst with around 10 years of experience. In this role, you will be responsible for designing, developing, and maintaining reports within the Microsoft Dynamics 365 environment. This role demands a deep understanding of Dynamics 365 modules, data structures, and reporting tools to ensure the creation of accurate and efficient reports that will be utilized to make business decisions and accelerate the sales flow. You will collaborate closely with global sales teams, understanding their data and reporting needs, and providing actionable insights that drive strategic decision-making.
Key Responsibilities:
- Collect, analyze, and interpret large datasets from various sources.
- Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
- Develop T-SQL Stored procedures, Dynamic-SQL, Joins, Cursors, Functions, Triggers, Constraints, Views, Variables, and Indexes.
- Design SSIS Packages for integrating data from heterogeneous sources
- Expert in Power BI to create various analytical dashboards that depict critical KPIs.
This role mandates the possession of the following technical skills and expertise in specific tools to effectively design, develop, and maintain reports within the Dynamics 365 environment.
Data Modeling, Analysis, ETL:
- Understanding of data modeling concepts to design efficient and scalable database structures
- Experience in designing and implementing data warehouses and data marts.
- Create and maintain comprehensive documentation for all reports, including data sources, data transformations, and report generation processes.
- Expertise in optimizing database queries and performance tuning
Dynamics 365 Business Intelligence (BI) Tools:
Familiarity with the built-in Business Intelligence features within Dynamics 365, including data visualization and reporting capabilities.
T-SQL (Transact-SQL):
Solid understanding and proficiency in T-SQL, the extension of SQL used in Microsoft SQL Server, for querying and manipulating data within the Dynamics 365 database.
SQL Server Reporting Services (SSRS):
Strong skills in SSRS, for designing and deploying traditional paginated reports within Dynamics 365.
Microsoft Power BI:
Proficiency in Power BI, for creating interactive and visually appealing reports and dashboards.
Power Query:
Proficiency in Power Query to transform data for Power BI and other reporting tools.
Dynamics 365 Data Export Service:
Knowledge of the Dynamics 365 Data Export Service for replicating Dynamics 365 data to Azure SQL Database for reporting and analytics purposes.
Data Integration and Migration Tools:
Understanding of tools like Microsoft Data Migration Framework (DMF) for integrating and migrating data within the Dynamics 365 environment.
Adobe is proud to be an Equal Employment Opportunity and affirmative action employer. We do not discriminate based on gender, race or color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. Learn more.
Adobe aims to make Adobe.com accessible to any and all users. If you have a disability or special need that requires accommodation to navigate our website or complete the application process, email accommodations@adobe.com or call (408) 536-3015.
Adobe values a free and open marketplace for all employees and has policies in place to ensure that we do not enter into illegal agreements with other companies to not recruit or hire each other’s employees.