Developer (IT)

Title: Developer (IT)

Duration: 12 Months contract with possible extension/conversion

Location: Malvern, PA, 19355 (Remote)

Duties:

Responsible for interpreting requirements provided by a team of Business Analysts, Query Development, Testing and Quality Assurance. Develop and maintain SQL queries, database views to permit timely and efficient measurement and analysis of business processes for the IT department. These include standards ITIL processes such as Incident Management, as well as Software Development Life Cycle (SDLC) and other IT processes performed by the department. Maintain and enhance a dimensional Data Warehouse and an Operational Data Store. Create data dashboards and visualizations using Tableau and Excel to perform report development. Responsible for data management and assisting in defining and maintaining metadata and data dictionaries to support Data Governance across the department. Develop SQL queries, views, stored procedures and functions to support data analysts throughout the department. Read and understand execution plans to optimize queries and related index. Deliver digestible information through various means (SQL Server Integration Service Development, Tableau, PowerPoint, and create and maintain artifacts supporting Data Governance, Management, and Delivery.

Technical Skills:

• Advanced SQL/T-SQL
• SQL Server Integration Services (SSIS)
• ETL Development
• Data Warehouse Development
• Dimensional Modeling
• Data Visualization (Tableau)
• Microsoft Excel (Advanced)
• Stored Procedures & Functions
• Query Optimization & Execution Plans
• Metadata Management
• Data Governance
• Data Dictionary Creation & Maintenance

Soft Skills:

• Communication
• Problem-Solving
• Collaboration & Teamwork
• Documentation Skills
• Stakeholder Management

Education:

The position requires a minimum of a bachelor s degree or foreign degree equivalent in engineering (information technology), computer science, information technology, or closely related field of study.