Motion Recruitment - Charlotte, NC
posted 3 months ago
We are seeking a Senior Data Integration Developer to be part of a team that provides reporting data warehouse solutions for Risk and Compliance across all levels of the organization. This position will utilize a strong understanding of data management, focusing on the design and construction of dimensional data models, and the overall delivery of data integration solutions. The successful candidate will collaborate with Data Modelers, report developers, and Business Intelligence Analysts to design, develop, and deploy information solutions within the enterprise risk domain. In this role, you will work closely with Data Modelers to structure data requirements into a data warehouse model suitable for reporting and analytics. You will be responsible for designing, developing, and debugging ETL integration code to meet defined source-to-target mappings, handling complex ETL requirements, and collaborating with Business Stakeholders to build database objects that meet desired outputs. Additionally, you will build, maintain, and govern the Hadoop data layer to ensure data consistency and a single version of the truth. Your responsibilities will also include completing unit testing to ensure a low probability of defects and that data matches with back-end systems. You will ensure that solutions are highly usable, scalable, and maintainable, while understanding the impacts of data layer performance factors and collaborating with the Data Architect to implement mitigating physical modeling solutions. Furthermore, you will perform code and design reviews to ensure performance, maintainability, and adherence to standards, while working with the Data Architect to define data security roles, groups, and policies. You will enforce Hadoop design standards, reusable objects, tools, best practices, and related development methodologies for the organization, partnering with Business Stakeholders and developers to ensure deliverables meet business expectations. Lastly, you will suggest solutions for development or process improvement and tune dataset designs for optimal performance, while developing, executing, and troubleshooting complex report SQL. This position requires comfort in managing multiple complex issues and projects simultaneously.