Job Description :
Position: Data Warehouse ETL Developer
Location: Middle River, MD
Duration: 12 Months
Interview: In-Person

FYI: Background check will be conducted before on-boarding.

The ideal candidate must possess the following:
Thorough knowledge of the principles and practices of software development best practices.
At least five years of experience in ETL methodologies and development.
Degree from an accredited college with a bachelor’s degree in Computer Science, Information Technology, Management Information Services, Business Management, Engineering, Project Management, Business or Public Administration, Communications or a related field. May be substituted with relevant software development experience of 5 or more years.
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.
Plan and coordinate data migrations between systems.
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.

Required Skills:
Experience working with SQL Server 2016+
Skill in SQL Server scripting.
Skill in data modeling.
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.
Ability to visualize complex issues.
Knowledge of personal computers, Microsoft Office suite of tools including; Word, Excel, PowerPoint, Visio and MS Project.
Knowledge of programming concepts and the Software Development Lifecycle (SDLC
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 and departments.
Effective verbal and written communication skills
Ability to effectively communicate with all levels of users and team members.