Comerica Sr. Staff Engineer SQL Developer Auburn Hills in Auburn Hills, Michigan

SQL Developer The Developer is responsible for transferring data between applications, transforming data into a usable format for reporting, oversight of jobs. They are responsible for defining and implementing improvements to gain efficiencies and higher reliability. Position Competencies Successful incumbents have excellent customer service skills, have strong inter-personal and communication skills, strong attention to detail, drive for results, decision quality, dealing with ambiguity, and ability to multi-task and have strong organizational skills. Responsibilities: Design & Methodology * Investigate & propose a strategic fit solution technology. * Work closely with Business Units, Application teams, infrastructure areas & Vendors to identity, review & evaluate the solution requirements. * Investigate & propose strategic fits for Virtualization, Consolidation & Rationalization solution opportunities within the infrastructure or business. Propose changes to the technical design solutions as applicable. * Review & provide recommendation/input if/as applicable on new technologies/roadmap/presentations and Vendor product offerings specific to "System" Server, System Software technologies & Solutions & products. * Evaluate & align strategic fit solutions across platforms & solutions specific to "System" hardware & software technologies. * Understand, participate, review & influence long term capacity planning & technology investments. Technical Consulting * Provide Client consulting & planning guidance as applicable for moderate to complex projects/programs. * Provide consultation & works closely with other functional infrastructure areas/departments on multiple initiatives to meet common organizational / business goals & objectives. * Participate in and provides consulting & planning guidance on short term & long term planning in order to meet ongoing business & operational needs. * Participate in and provides consulting to project teams on architectural, design development, integration opportunities, planning of complex systems & assures it is aligned to our established strategies, guiding principles, rationales & practices. * Develop & provide estimates for projects/programs & initiatives during consulting, planning & implementation review if/as applicable for projects & initiatives. Planning & Organizing * Identify & evaluate projects/programs/initiatives & design processes that enhance & rationalize existing and upcoming solutions. * Map requirements into standard services solution, identity opportunities for integrating to existing or reuse technology & provide cost effective solutions for moderate to large highly complex project/programs/initiatives. * Review and propose alternate solutions to non-standard solutions if/as applicable to meet business & applications needs. * Review, identify & manage requirements for moderate to complex solutions and do a cost value, feasibility and risk analysis as appropriate. * Assist & provide guidance on complex/ large project/program planning phases & process. Direct and/or indirect management responsibility for large to enterprise size projects /programs/initiatives/services with high complexity across multiple functional area(s). Risk Management * Participate in CAB/ECAB and active assess risk of proposed changes. * Review, participate, develop (if/as applicable) & update architectural standards, guiding principles, rationales & strategies. * Evaluate, review & approve highly complex design solutions for business & Infrastructure project or programs or initiatives. Administration * Keep management informed of status of on activities through accurate, timely, and appropriate reporting. * Actively participates in committees representing the department and/or planning unit. * Keep abreast of leading edge technologies in engineering space. * Estimating cost saving targets. * Budget low cost hosting provider. Relocation Relocation assistance is not provided for this position. Travel Travel is not required for this position. * Bachelor's Degree from an accredited university or High School Diploma or GED and 8 years of technology experience * 7 years leading technology projects with large to complex sized projects * 7 years in identifying technical solutions for complex business problems, identifying the benefits and risks of the solutions and providing recommendations * 6 years design experience with 3 years advanced design experience * 3 years full life cycle development in an enterprise development environment * 3 years configuration management concepts and tools * 3 years design and modeling tools * 3 years working in a DevOps model * 4 years of experience with VBA, and advanced Excel functionality -- Pivot Tables, VLOOKUP, Macros, etc (required) * 4 years of experience with SQL Server Database Development, experience in SQL Server 2012/2008/2005 (required) * 4 years of experience creating reports and data visualizations, SQL queries, SQL Server procedures, functions (required) * 4 years of experience with SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled