Data Warehouse Developer ETL - Hybrid Middle River, MD

Job Description This position will: 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. Create documentation needed to support repeatability of testing metrics. 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 bachelors 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. Work with SQL Server DBAs, system architects, and application developers to design stable, reliable, effective, and optimized databases. Plan and coordinate data migrations between systems. Assist in the formulation of business and testing requirements. Develop high-quality deliverables. Follow all required software development standards, change control procedures, and security requirements. Ensure that the databases meet organizational and performance requirements. Build relationships with project sponsors, stakeholders, other technical staff, vendors, and end users. Coordinate and perform unit, system, and performance testing. Collaborate on User Acceptance testing and issue resolution. Participate in continuous improvement activities by analyzing existing processes and developing strategies for enhancements. Produce status reports and communications regularly. Requirements Required Skills: 3+ years of SSIS experience. Experience working with Azure SQL Instance. Proficiency in SQL Server scripting. Skill in data modeling. Skill in the operation of computers and peripheral equipment. Creative and analytical problem-solving skills. Understanding of Data Warehousing principles, concepts, and architecture. Ability to manage multiple priorities and meet project deadlines. Effective requirements analysis and management skills. Ability to visualize complex issues. Knowledge of Microsoft Office tools including Word, Excel, PowerPoint, and Visio. Understanding of programming concepts and the Software Development Lifecycle (SDLC). Ability to coordinate work across teams and departments. Effective verbal and written communication skills. Ability to communicate effectively with all levels of users and team members. #J-18808-Ljbffr