Job Title: ETL Analyst/Developer
Location: Baltimore, MD
Duration: 6+ Months.
Rate: DOE
Job Description:
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.
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.
· 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:
· 3+ years of SSIS experience.
· 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.