SQL/BI Data Developer/Analyst

AR# 207263

SQL/BI Data Developer/Analyst (Need onsite from Day 1)

Location: Austin, TX / Scottsdale, AZ

Client: PayPal

JD:

• Must have understanding of data processing and data warehousing concepts. Experience with gathering requirements for BI/Data warehouse project is must
• Experience with ETL/BI tools is must
• Experience in Data Analysis, Data profiling, Data Validation using complex SQL queries on top of RDBMS/Hadoop- HiveQL, SparkSQL / GCP Big Query etc. for validation of ETL data pipelines
• Performing Fit GAP assessments of current/future state data platforms and creating an appropriate transition path/roadmap
• Ability to understand code developed using python, pyspark etc
• Preferred/Basic understanding of Payments/Finance/Accounting Industry Background
• Understanding of Apache Spark/Hadoop ecosystem and the Data Analytics ecosystem
• Should be a fast learner and must be able to work with minimal supervision in a fast paced environment
• Experience or understanding of designing data pipelines, data models in a cloud environment like GCP BigQuery or any other Cloud is a plus
• Creating source to target mapping documents, data flow diagrams, data models to document data pipelines
• Experience with databases, systems integration, application development and reporting
• Must have demonstrably strong interpersonal and communication skills (both written and verbal), to include speaking clearly and persuasively in positive or negative situations
• Works in an Agile environment and continuously reviews the business needs, refines priorities, outlines milestones and deliverables, and identifies opportunities and risks
• Maintain, track, and collaborate with dev teams to ensure project estimation for delivery
• Highlight the bugs and blockers and coordinate with the development and operations team to come up with the best solutions/fixes and document them
• Work across internal team in various geo-locations across the world
• Weekly and Monthly status reporting to leadership
• Having GCP certification or Cloud experience is a plus
• Having scripting & coding experience is a plus

AR# 206661

Role: SQL Data Analyst (Need to be onsite after 2-3 weeks)

Location: Stamford, CT

Client: Franklin Templeton Companies,LLC

• 10+ years of experience with back-office systems and data
• Ability to analyse complex business problems and recommend technical and non-technical solutions
• A thorough understanding of back-office and middle office data (trades, corporate actions, holdings, etc.) and the underlying systems and business processes used to create the data. Then how that information is used across a financial organisation in both systems and business processes
• Ability to assess new/changed data's impact to downstream users of that data
• Financial industry/Capital Market experience is important
• Strong SQL development skills
• Thorough understanding of conceptual and logical data models for complex data centric projects, applications, and data management platforms
• Experience with integration requirements related to company acquisitions and complex product launches
• Outstanding analytical, innovation, and problem-solving skills