Data Analytics & Data Warehouse Lead developer
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+13 more
Job description
Produce service metrics, analyze trends and identify opportunities to improve the level of service and reduce cost as appropriate.
-Responsible for design, development and maintenance of database schema and objects throughout the lifecycle of the applications.
-Responsible for evaluating BI tools and building BI reporting solutions.
-Supporting implemented solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
-Troubleshoot data issues and work with data providers for resolution
-Closely work with business and applications teams in implementing the right design and solution for the business applications.
-Build reporting solutions for Risk Management applications
Requirements
Data Analysis, Data Warehousing, Wealth Management, Data Analysis, Risk, Multiplatform/Cross-Platform, Finance Software, Communication Skills, Data Warehousing, Business Intelligence Software, We are looking for a highly motivated, hands-on Senior Database/Data Warehouse Data Analytics developer to work at our Alpharetta, GA location. Ideal candidate will have solid software technology background with capability in the making and supporting of robust, secure, and multi-platform financial applications to contribute to the evolution of Wealth Management Risk platform. The successful candidate will be a proficient and productive developer, have good communication skills, and demonstrate ownership.
The Successful Candidate Should Have or Offer
-5+ Years of strong DWH design, development and architecture experience.
-Experience with Reporting/BI Tools (preferably BO), Data Analytics.
-Strong Data Modeling skills - Enterprise Data Model (OLTP) and Dimensional modelling. Well versed with principles, techniques and best practices of data modelling.
-Strong Skills in MPP Database (preferably Teradata) including database design, performance tuning, writing complex DB programs etc.
-Demonstrate proficient skills in analysis and resolution of application performance problems.
-Very strong SQL skills in at least one DB technology i.e. Teradata or any other database like Oracle, UDB, Hadoop. Teradata skills are preferred
-Full understanding of the processes of data quality, data cleansing and data transformation and data modeling
-Ability to understand and analyze the data to find patterns and valuable Business Insights
-Ability to write complicated yet efficient SQL queries and stored procedures
-Experience in end-to-end implementation of Business Intelligence (BI) projects, especially in scorecards, KPIs, reports & dashboards
-Experience with Hadoop Ecosystem is a plus.
-Knowledge of different financial instruments like Equities, Options, Futures, etc. is a huge plus., Exposure to Hadoop ecosystem.
-Prior experience in financial firms is a huge plus
-Masters or Bachelorβs degree in Computer Science
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦