Job: Dynamics 365 Systems Analyst
Location: Houston TX | 515 W Greens Road, 77067 - 4 days a week onsite and Friday is WFH.
Interview process: 2 virtual interviews and then one onsite interview
JOB SUMMARY
Provides technical and programming support, maintenance and trouble-shooting on Dynamics 365 Finance & Operations. The technical domain of the Developer includes understanding D365 Data management practices and Data Integration (DI) best practices, tools and technologies, security in the environment, understanding of different data Sources like SQLServer, Oracle, Salesforce, Microsoft Dynamics modules. DI development, performance tuning and support system testing.
DUTIES AND RESPONSIBILITIES
Microsoft Dynamics D365 for Operations programming skills with exposure to multiple AX/D365 modules is preferred. Minimum experience is required in D365 for Operations programming experience. Additional technical skills may vary. Must demonstrate thorough programming skills (including X++, C#, .NET, SQL, etc.).
- Data management package REST API
- Data management and integration by using data entities in D365
- Data integration by using Common Data Service in D365
- Batch processing and Data deduplication (dedupe) rules management
- Develop Integration layer for data integration considering new data and modified data in source and target systems
- Proficient in SQL Server Integration Services (SSIS) coding, debugging, and implementing
- Ability to develop SSIS Packages for data dumps, data migration, and data transformation
- ETL scripts for data replication from non-relational database to SQL database
- Experience in SQL Server Stored procedures, functions
- Experience in deploying reports to Report Server and performance tuning
- Experience in reporting toolsets, job scheduling, publishing and distribution of reports
- Communicate effectively with analysts, developers, testers, management, and clients.
- Produce detailed logical data models and designs required to support the integration between Dynamics 365 and Oracle systems, data warehouse and any other database applications.
- Support the design of any SQL Server data structures, optimizing for performance as necessary
- Ability to clearly document own work products and review/contribute to the documentation across complex assignments
- Develop and maintain a formal description of the data and data structures, architecture and framework—particularly for third party software add-ons
- Accountable for quality, completeness, and on-time delivery of an assigned project. Develop data strategy for complex assignments.
- Support the creation and maintenance of any corporate database, in production, development, and test/QA environments
- Copy D365 Finance and Operations/ Field Service database from Azure SQL Database to a SQL Server environment
- Copy a D365 Finance and Operations/ Field Service database from SQL Server to a production Azure SQL Database environment
Qualifications
MINIMUM QUALIFICATIONS
- Post secondary education with a Computer Sciences Degree or Business Diploma
- 6 plus years of related experience.
- Experience in the following: Data management in Dynamics 365 (Finance & Operations and Field Services), C#, SSRS
- Reporting, Crystal Reports, SQL Programming, Relational Database
- Experience working with SQL databases, including SSIS, SQL Tools, programming, triggers, and stored procedures.
- Experience in using SSIS third-party connectors (Ex. Kingsway Soft)
BEHAVIORAL COMPETENCIES
- Ability to analyze problems and recommend solutions
- Strong written and verbal communication skills
- Self -Starter, motivated to work as an individual and as part of a team
- Strong multi-tasking and organizational skills
- Ability to quickly learn new applications and tools
- Ability to think outside of the box for solutions
Friendly, positive and dedicated
Thanks and Regards…
Akhil
E: akhil@Clovity.com
W: www.clovity.com