Position Title Sr. Data Engineer

Location Headquarters-Troy, MI

Job Summary Responsible for the design, development, and execution of automated and manual data Extract, Transform, and Load (ETL), integration, and exchange processes across the enterprise. Will recommend, implement, develop and utilize innovative tools and processes to efficiently, rapidly, and securely acquire, integrate, and provision large sets of data from and to thousands of sources. Responsible for the efficient, compliant, timely, and secure acquisition, integration, provision, and exchange of the enterprise data.

Job Responsibilities: Provide data integration architecture leadership across the enterprise. Develop and document technical best practices for ETL-related activities including data movement, data aggregation, data quality, and data cleansing. Work with the Data Warehousing and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations. Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions. Create, execute, and document unit test plans for ETL and data integration processes and programs. Document ETL processes, programs and solutions as per established standards. Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance. Work with internal staff, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues. Assess and document the structure, quality, and compliance of data source data and coordinate with business and technology staff to identify and resolve issues. Mentor other Data Management team members in the ETL tools, programs, processes, and best practices. Ensures compliance with applicable federal, state and local laws and regulations. Completes all required compliance training. Maintains knowledge of and adhere to Flagstar's internal compliance policies and procedures. Takes responsibility to keep up to date with changing regulations and policies.

Job Requirements : Bachelor's in Computer Science, Mathematics or related field 7 years of development experience preferred, or 10 years comparable work experience required. 7 year's experience designing, developing, testing, and implementing Extract, Transform and Load (ETL) solutions using enterprise ETL tools or 10 years of comparable work experience reuired. 6 year's experience developing and implementing data integration and data warehouse solutions in an Oracle 11g/12c database environment 2 year's experience working with Business Intelligence tools (IBM Cognos is preferred) 2 year's experience working in a Service- Oriented Architecture (SOA) environment 1 year experience in 10 TB data environment. Expertise in Relational Database Management System, Data Mart and Data Warehouse design. Expert-level SQL and PL/SQL development skills in a multi-tier environment. Expertise in flat file formats, XML within PL/SQL, and file format conversion. Strong understanding of SDLC and Agile Methodologies. Strong understanding of model driven development. Strong understanding of ETL best practices. Proven strength in interpreting customer business needs and translating them into application and operational requirements. Strong problem-solving skills and analytic skills with proven strength in applying root cause analysis. Expertise and hands-on experience in designing and building technical solutions using best practices and applicable technologies; an ability to demonstrate strong coding skills Expertise in working with technical and business teams to extract and document data