IT Sr. Data Warehousing Programmer | Full Time

GENERAL SUMMARY:

Under the general direction of the Enterprise Data Architect, Data Architecture Manager, or EDW Program Manager: this role is responsible for designing, developing, and maintaining enterprise-level data warehouse solutions using Microsoft SQL Server and Microsoft Fabric. The ideal candidate will have a deep understanding of data architecture, ETL processes, performance optimization, and cloud-based data solutions to support the organization's analytics and reporting needs, with a focus on custom SSIS package development and the creation of reusable Fabric data pipelines. Responsibilities will include troubleshooting application and data issues and providing production support (including on-call duties in a 24x7 environment) in addition to executing on new projects. The ideal candidate will have experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality, efficient business processes and solutions that promote efficiency and enterprise-wide standardization.

PRINCIPLE DUTIES AND RESPONSIBILITIES:

• Participates in requirements definition sessions to gain a general perspective on the business objective(s) or business problem that is to be addressed by the system.
• Works with Business Analysts to gain an understanding of functional requirements.
• Works with Business Analysts to develop implementable technical designs. Research and recommend alternative design solutions where appropriate.
• Analyzes requirements, design and develop prototype and work with the users/business analyst to fine tune the data warehouse and make
  recommendations.
• Participates in peer/code/design reviews to verify that quality standards and functional/technical requirements are met.
• Design, code, test and implement moderately complex programs; Develops appropriate programs and systems documentation according to established IT standards.
• Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated into the system design.
• Assists in analyzing testing results throughout the project.
• Enhances existing systems; participates in structured walkthroughs and technical reviews.
• Supports production systems by helping resolve problems, providing timely follow-up on problem report, optimizing performance and streamlining processes
• Assists in coordinating developments tasks on projects, problem tickets and provide support to other team members.
• Provides support, escalation response to production problem issues/errors. Performs root cause analysis and application resolution.
• Provides on call second-level escalation response for client issues and application problem tickets.
• Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions.
• Ensures proper documentation and on-time delivery of all technical artifacts and deliverables.
• Keeps abreast of new Tools & Technology and functionalities across the application.
• Promotes teamwork and leads by example.
• Initiates a personal training plan, continue acquiring skills and knowledge, and pursue an understanding of the organization's business plans and strategies.