TITLE: D365 Senior System Analyst
LOCATION: Houston Texas
TYPE: Direct Hire
SALARY: $130,000 - $135,000
SUMMARY:
Our client is looking for a D365 Senior System Analyst for their team. The D365 Senior System Analyst provides technical 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.
The D365 Senior System Analyst will have 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.).
DUTIES:
- 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
- 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
REQUIREMENTS:
- 6 years of D365 System Analyst 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)
EDUCATION:
Post secondary education with a Computer Sciences Degree or Business Diploma