Data Warehouse Developer

Responsibilities:

• Develop and maintain the Data Warehouse based on business and technology requirements and industry standard best practices.
• Ability to work with SQL Server DBAs, system architect, and application developers to design stable, reliable, effective, and optimized databases.
• Assists in the formulation of business and testing requirements.
• Develop high quality deliverables.
• Follows all required software development standards, change control procedures, and security requirements.
• Ensure that the databases meet organization and performance requirements.
• Follows all required software development standards, change control procedures, and security requirements.
• Ability to build relationships with project sponsors, stakeholders, other technical staff, vendors, and end users.
• Coordinates and performs required unit, system, and performance testing. Works with other team members on User Acceptance testing and issue resolution.
• Participates in continuous improvement activities by identifying and analyzing the effectiveness and efficiency of existing processes and develops strategies for improvements.
• Produces status reports and communications on a regular basis.

Requirement:

• 3 years of SSIS experience.
• Experience working with Azure SQL Instance.
• Skill in the operation of computers and peripheral equipment.
• Skill in creative and analytic problem solving.
• Understanding of Data Warehousing principals, concepts, and architecture.
• Ability to manage multiple priorities and meet project delivery dates.
• Ability to effectively analyze and manage requirements.
• Knowledge of personal computers, Microsoft Office suite of tools including Word, Excel, PowerPoint, and Visio.
• Knowledge of programming concepts and the Software Development Lifecycle.
• Ability to coordinate the work of a team with the work of other units within the Department of Research, Assessment, and Accountability and other BCPS offices, schools, and departments.

Key Skills:

• Data Marts.
• Cubes.
• ETL.
• Quality Assurance/Quality Control.
• Software Development Lifecycle Management.
• Unit Testing.
• Debugging.
• Data Flow Diagramming.