Temporary Data Architect & SQL Developer (ETL) (20-18315)
Job Description
Long Term Contract for a Data Architect & SQL Developer (ETL)
(No corp. to corp. or 3rd party)
o The Consumer Banking, Investments and Academy Reporting team under AMI organization develops, executes and enhances a suite of reports that allows our business partners to effectively manage and monitor performance within various LOBs. The team is focused on automation to efficiently deliver timely and accurate information.
• Day to day responsibilities of the role
o This position is responsible for developing and managing logical and physical data models of enterprise business data as well as the physical data architecture data stores and data marts as components of the data warehouse.
o Creates deliverables that include, but are not limited to: Logical Data Models, Physical Data Models, Dimensional Data Models, Data Flow Diagrams and other Data Management artifacts including database objects like tables, views, stored procedures, functions etc.
o Analyzes business and functional requirements of assigned projects and translate into technical specifications and data rules required for the construction of a data mart, data warehouse or operational data store.
o Create and manage all documentation (business and technical metadata, data models, guidelines and standards, etc., processes) current.
o Develops routines to ensure data quality & integrity.
o Troubleshoots issues and fix bugs as and when needed.
o Performs SQL performance tuning to make the code run efficient
o Participates in a team environment for the delivery and maintenance of data models in support of application system databases.
o Effectively applies software development methodology and adheres to standards, including change management.
o Provides training and knowledge transfer to the application support group.
o Provides project documents and deliverables in adherence to project plans.
o Fosters/maintains good relationships with customers and IT colleagues to meet expected customer service levels.
o Familiar with full life cycle software development processes, especially as they pertain to data movement and data integration.
o Strong written and oral communications skills coupled with active listening skills.
• Required Skills/Experience/Education
o BS in Computer/Information Science, Mathematics or equivalent is required.
o 10-15 years of relevant data warehousing/data modeling experience in a multi-platform environment, including but not limited to, application system administration/coordination, application development or database development.
o Demonstrated experience using in database development, modeling and ETL tools (SQL Server, Teradata, SSIS, SAS).
o Must be highly motivated, have a great work ethic and work effectively with other team members, while requiring minimum direction.
• Desired Skills/Experience/Education
o Report development experience working in Microstrategy/Tableau
o Some exposure to Alteryx, Trifacta, Python for ETL work
o Experience in unix/linux and shell scripts is desired
Top 3 MUST have
o SQL Server
o Teradata
o SAS (for ETL in Teradata)
How to Apply
Please send your updated resume to iris.chen@axelon.com283 total views, 0 today