We are currently seeking a talented business systems analyst to join our Information Technology organization. This person will join a team that supports many critical business systems, including SQL Server, SQL Integration Services, SQL Reporting Services, BizTalk, and ERP platforms. This position will regularly interface with business analysts and customers to gather requirements, provide estimates, execute work, and provide quality testing.
ESSENTIAL DUTIES & RESPONSIBILITIES:
Participate in all phases of development of database and system projects from definition and design through implementation, debugging, testing and deployment, ensuring application schemas and development are optimal and consistent across the solution
• Identify user needs to create and administer databases; ensure that the database operates efficiently and without error. Make and test modifications to the database structure when needed. • Backup and restore data to prevent data loss, merge old databases into new ones. • Manage, monitor and validate regular data downloads from the company’ s back office systems. • Ensure that all data are up-to-date and take appropriate actions when discrepancies are found. • Independently identify and solve data problems, informing all parties concerned. • Collaborate with all parties concerned to design and develop a centralized, validated and structured data warehouse for all departments’ utilization. • Provide analytical insight regarding all reports. • Evaluate and automate database and reporting systems regularly to improve and maintain efficiency and reliability. • Maintain data integrity when manipulating data files for the purpose of analysis, validate data thoroughly by using multiple data sources or criteria when necessary to ensure accuracy of results. • Collaborate on design and implementation of transactional data models, development of T-SQL and maintenance of existing T-SQL in conjunction with .Net. • Design and implementation of dimensional data models along with analysis of requirements and production of specifications for business intelligence functionality with ETL and reporting components • Database operational maintenance, capacity planning and implementation of enhancements, including associated documentation of data models and configurations
• Participate in T-SQL code reviews and technical quality standards reviews • Document all essential duties and processes in a manual format for training purposes.
• 5+ years SQL Server DBA experience • 5+ years T-SQL development experience, with good working knowledge of best practices • ETL and BI solution development and maintenance experience using SQL Server 2012/2016, SSIS, SSRS, SSAS • Oracle EPM/OBI Experience a plus • Experience with T-SQL development/analysis in an environment using ORM tools • Experience with VMware/Hyper V • Experience with SharePoint and/or SharePoint Online • Experience with Windows Server and Active Directory • Experience with Microsoft Visual Studio - TFS an advantage. • Possess excellent communication skills, the drive to succeed and work independently and on a team, with the ability to multi task, and deliver quality results • Experienced engineer with broad understanding of all the components of large service-oriented architecture solutions • Practical knowledge of Source Control Management, specifically branching, tagging and merging of different code streams • Experience of interfacing with project management • Possess excellent communication skills, the drive to succeed and work independently and on a team, with the ability to multi task, and deliver quality results • Required: 5-7 years of experience of progressive experience in an Information Technology environment. • Familiarity with DM2, PDI, Sage or Trinium ERP systems.
TECHNOLOGY TO BE USED:
• Hardware – PC’ s/laptops/terminals/tablets • Operating Systems – Windows 7/8/10 • Tools – MS Office Suite: Office 365, Project, Visio • Collaboration: Slack, Skype, Zoom, Ring Central