Posted: Tuesday, September 5, 2017 8:01 PM
GENERAL SUMMARY:The primary responsibilities of the Sr. ETL Software Engineer include warehousing, design and development of logical and physical data models and databases, distributed data management and providing ongoing production support of existing solutions, along with designing, executing, and debugging manual test plans to ensure business requirements are met. The ideal candidate must be able to perform data analysis tracking data elements from the source, through transformation all the way to the target destination. The Sr. ETL Software Engineer delivers business intelligence solutions, including multi-dimensional database models (logical and physical), data marts, data warehousing, data transformations, data analytics, and supports reporting solutions while collaborating with business users to set requirements for solutions. Relies on experience and judgment to plan and accomplish goals. A certain degree of creativity and latitude is required. ESSENTIAL DUTIES AND RESPONSIBILITIES:Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective to derive software designs and performance solutions.Design, implement, execute and debug manual test cases and automated test scripts using a variety of testing techniques.Strong data analysis skills and the ability to track a data element from source to transformation to target.Designs and develops relational and multidimensional data models and optimizes the data-mining performance function including the use of data modeling tools, preferably Erwin.Creates and implements BI reporting solutions, Extract Transform Load (ETL) solutions and/or Hadoop data processing solutions using BI/data engineering best practices and methodologies; identifies root causes of issues with data quality and other related issues.Designs and codes new software or enhances existing software and integrates into new or modified systems and/or operational environments.Works with a reporting team optimizing the ETL/data pipeline process to ensure that business requirements are met.Secure sensitive content to align with regulatory and legal requirements.Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.Mentors junior staff.Provide on-call production support on a rotating basis.
• Location: Baltimore
• Post ID: 26557997 baltimore