Senior ETL Developer

Expiring today

Employer
Blue Health Intelligence
Location
Pikesville, MD
Posted
May 19, 2017
Closes
May 26, 2017
Hours
Full Time
Position Summary Designs architects and implements data warehouse ETL solutions for BHI data systems Works with business teams BI Team DBAs ETL developers and report developers to deliver comprehensive ETL processes across products and solutions Develop test and package ETL processes using standard SQL and other enterprise ETL tools This position will be closely involved in all aspects of the software development life cycle as part of a team of software developers This individual will primarily support BHI projects by developing and executing ETL tasks implementing data quality analysis data migration and data cleansing This position will work closely with the BHI Consultants and Business Analysts acquiring clear business requirements outlining and designing robust solutions and developing code that is high quality error free and on time meeting milestones as defined and agreed upon Responsibilities Translate business and functional requirements to technical specifications in the context of BHIa s claims data warehouse and implement efficient and repeatable technical solutions using highly optimized and standards compliant SQL queries and Linux shell scripts Understand and evaluate existing SQL scripts and Data Models Design and develop queries and data models for a high performance projects and deliverables Develop manage and maintain data dictionaries metadata and process flow documentation Design develop and implement complete solutions throughout the project product life cycles Maintain and manage revisions of code in production testing and development environments Work with project teams to refine business requirements that produce well designed and developed solutions Follow Company and industry defined best practices to ensure smooth and continuous product development operations Develop process improvements that ensure product quality and productivity Maintain product requirements technical and functional documentations for release management Working with development project teams and business data stewards to research and identify quality issues Using data quality tools to profile source data define and validate metadata and verify staged data Implements test strategies and procedures established by team which includes peer review unit testing functional testing and user acceptance testing Must demonstrate clear and professional communication style verbal and written Must possess keen decision making and analytical abilities Must have ability to prioritize tasks Must possess a highly developed sense of integrity Must be committed to customer and project team success and continuous improvement Must be self motivated thorough and reliable and possess above average attention to detail and organizational skill Must have desire to learn new technologies and business concepts Must have ability to work in a structured environment as well as performing in high pressure ad hoc mode to address urgent needs Must be able to multitask prioritize and manage time effectively Job Requirements Bachelora s degree in Computer Science or comparable experience years of SQL programming experience Expert in writing complex SQL queries and stored procedures years of experience with large health care related databases Experience with database development software tools like DBVisualizer TOAD etc Familiar with Unix operating system shell scripting and standard Unix productivity tools Solid understanding of relational database concepts data warehousing OLAP and database architecture and design Demonstrated ability to communicate technical recommendations to a non technical audience in a clear and concise manner Demonstrated ability to understand logical relationships and to ensure that programming faithfully replicates these relationships Demonstrated ability to test and validate programming steps Demonstrated ability to evaluate and interpret complex data sets Demonstrated analysis programming and problem solving skills Ability to work both independently and as part of a project team Demonstrated understanding of data modeling schema design and ETL processes Capable of troubleshooting common database issues Preferred Qualifications Experience with Vertica Experience with SAS Experience with Microsoft SSIS OLAP MDX Equal Employment Opportunity It is the policy of BHI to provide equal employment opportunity and advancement opportunities to all colleagues and qualified applicants for employment without regard to race color religion national origin sex age disability sexual orientation gender identity or any other classification protected by the federal state or local laws