Our client is seeking a SQL Developer with a strong grasp of the MS stack. You will be working with the application development teams, Business Analysts and the business to help integrated data from disparate sources into their existing systems as well as feed multiple internal applications including COTS, ERP and home-grown applications. You will also work to understand the needs of the business, create dashboards and other tools that they will use for better data-based decisions.
BACKGROUND
- Understand the data needs of the business
- Develop tools that streamline internal business processes
- Create dashboards and other tools to enhance data-oriented decision making.
- Troubleshoot and determine resolution for correcting defects
- Complete estimates as to level of effort involved for project tasks and perform analysis to determine how the solution can best be achieved.
- Work with users and Business Analysts to determine requirements and design tools for more informed data centric decisions.
- Design and develop interfaces for the import and export of data to and from disparate systems.
- Perform ETL on data from multiple sources.
BACKGROUND
- Solid experience with the MS SQL data tools including:
- Solid SQL development
- Working knowledge of SSRS
- Strong Excel experience
- Working knowledge of SSIS
- Working knowledge of SSMS
- Working knowledge of Microsoft Visual Studio
- Understanding of CDC mirroring and SQL replication
- Basic knowledge of SSAS
- Ability to design and implement conversion strategies to bring data from disparate databases into company databases
- Basic knowledge of Power BI
- Ability to work with end users to identify and troubleshoot problems