Job Title: Data Warehouse Developer ETL Duration: 12 Months Location: Baltimore, MD 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. • Support the Data Analytics Team in retrieving data from multiple data systems for use in data extracts, reports, and dashboards to ensure data quality before release. • Create, execute, and monitor ETL processes including tracking and documenting findings. • Create test scripts using SQL programming to validate data points against transactional systems and the data warehouse. • Creating documentation needed to support repeatability of testing metrics. Required Skills • 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. • 3+ years of SSIS experience. • Experience working with Azure SQL Instance. • 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 principles, 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, and Visio. • 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, schools, and departments. • Effective verbal and written communication skills. • Ability to effectively communicate with all levels of users and team members.