Data Analytics & Data Warehouse developer

26 Nov 2024

Vacancy expired!

Software Guidance & Assistance, Inc., (SGA), is searching for a Data Analytics & Data Warehouse developer for a Contract assignment with one of our premier F inancial Services clients in Alpharetta, GA. Responsibilities :

  • 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.
  • 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.
  • Helping the team by taking care of production releases.
  • 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
Required Skills :
  • 5+ Years of strong ETL (Informatica)/DWH design, design, and development experience.
  • Bachelor's Degree
  • 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. 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 with Hadoop Ecosystem is a plus.
  • Knowledge of different financial instruments like Equities, Options, Futures, etc. is a huge plus.
Preferred Skills :
  • Exposure to Hadoop ecosystem.
  • Prior experience in financial firms is a huge plus
  • Masters or Bachelor's degree in Computer Science
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com . EEO Employer: Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status.

  • ID: #23502487
  • State: Georgia Alpharetta 30004 Alpharetta USA
  • City: Alpharetta
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2021-11-26
  • Deadline: 2022-01-24
  • Category: Software/QA/DBA/etc