Data Analyst (Informatica MFT, DBT & Snowflake) at Scalence L.L.C. in Cary, NC

Job description

• Job Title: Data Analyst (Informatica MFT, DBT & Snowflake)
• Location: Cary NC (Local Only - Face to Face interview)
• Duration: 6 months (Extendable)
• Pay Range: $45-50/Hour on W2
• Request ID: 110253-1
• Position Summary:

Responsibilities

• • Work with business/data product team to translate given business problem into analytical solution with defined outcomes.
• • Analyze the data in depth, informatica MFT, using SQLs and other exploratory tools against various platforms such as Bigdata, Oracle, SQL Server and others.
• • Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role and mandatory to have Informatica MFT, DBT and snowflake
• • Work closely with the ETL and data science teams to review the requirements and data integrations.
• • Understand the requirements from Business and Data Science. Understand the business and business impact on use cases.
• • Write validation scripts to validate the data loaded by ETL team an assess using MFT / DBT.
• • Work with IT and business customers to develop and design requirements to formulate technical design.
• • Skills to understand the right functional domain knowledge of the business to be able to gather right requirements for the design.
• • Capture meta data, data lineage, reference data management and data quality rules as part of data governance.
• • Work with team spread across the globe in driving the delivery of projects.

Requirements

• • Bachelor’s degree in computer science, Engineering, or related discipline.
• • 8+ years of solutions development / analysis experience, including 5+ years in data management/engineering organization.
• • Proficient understanding of distributed computing principles and informatica Scripts / MFT
• • Extensive experience in data analysis and data modeling (table design).
• • Proficiency in SQLs and data exploratory tools.
• • Extensive experience writing functional requirements and high-level design documents.
• • Experience in writing validation scripts to validate the data, data integrations and ETL transformations.
• • Analytical skills to analyze situations and come to optimal and efficient solution based on requirements.
• • Strong data analysis and profiling skills.
• • Data warehouse concepts.
• • Strong analytical skills related to working with unstructured datasets.
• • SQL knowledge and data analysis skills for data anomaly detection and data quality assurance.
• • Excellent communication skills, both written and verbal
• • Experience working on MFT and DBT skills and should posses cloud knowledge.
• • Strong background or working experience in Insurance Industry as a Lead analyst.
• • Ability to interact with senior leadership teams in IT and business raise the required defect and track project end to using manual or automation design creation.
• • Should have good SQL knowledge/ AWS and snowflake.
• • Should be good in Agile methodologies and SDLC process.

Skills

Required

• Informatica MFT
• DBT
• Snowflake
• SQL
• Data analysis
• Data modeling
• Data profiling
• Data warehouse concepts
• Distributed computing principles
• Validation scripts
• Functional requirements writing
• High-level design documents

Preferred

• MFT
• Cloud knowledge
• AWS
• Agile methodologies
• SDLC process
• Insurance industry experience