ONLY W2
Location: Rutherford NJ (3 days onsite - Hybrid)
Duration: 12 months
Senior Developer - Data Analyst
This is a Hands-on Senior Data modeler / Database developer position. Candidate will be leading a team of data modelers, data analysts and database developers to design, build and maintain relational and dimensional databases supporting multiple business initiatives / work streams.
Key Responsibilities include.
- Design, build and maintain the transactional / operational and analytical data stores
- Maintain the existing data warehouses and Design subject area wise data marts / cubes to facilitate aggregation, slicing and dicing of data by reporting tools such as Tableau and Micro Strategy
- Undertake extraction, transformation and population of the data warehouse and data mart.
- Evaluate new data sources for adherence to the organization's quality standards and ease of integration.
- Interface with Data governance teams to leverage central data repositories
- Interface with Business and technical teams on Requirements and functional analysis
- Providing expertise in technical analysis and solving technical issues during project delivery
- Provide Technical Leadership to a team of developers, modelers and analysts
- Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks
- Support the Quality Assurance team during Product Test phase
- Provide bug fixes and level-3 support to troubleshoot Production problems whenever needed
- Application Database Performance tuning
Job Skills/Qualifications
- 10+ Years of project experience as database modeler / Data warehouse architect within a distributed, service-based enterprise environment for financial institutions
- Demonstrated experience creating conceptual, logical and physical models. (ERD, normalized and dimensional models)
- Previous experience w/Metadata management strategies and implementation
- Demonstrates expertise in a variety of data warehousing and business intelligence concepts, practices, and procedures.
- Hands-on experience with ETL design and development best practices.
- Experience with Tools like ERwin Data Modeler tools/Power Designer
- Hands-on experience with implementing Big Data storage Technologies
- Experience with systems / applications in Risk and Controls technology for financial institutions is preferred
- Previous experience conducting requirements gathering and design sessions with customers.
- Previous experience producing written deliverables for technical designs.
- Understanding of indexing, partitioning and data design performance considerations for industry standard DBMS
- Strong understanding of software development life cycle and Release Management
- Ability to design, organize, and implement module, perform system testing, plan and automate tasks to maintain existing system
- Ability to research and trouble-shoot application problems
- Highly motivated team player, Excellent communication and interpersonal skills
- Excellent analytical and troubleshooting skills
- Ability to balance multiple demands and work both independently and as part of a team to develop solutions
- Excellent analytical and troubleshooting skills
Pay Range: $70- $75