Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Cary, NC, United States
Posted
2 days ago
OracleSQLSQL ServerAWSETLSnowflakeAgiledbt
Job Description
Job Title : Lead Data Analyst / Data Solutions Analyst
Location : Cary NC
JD :
Local to Cary NC only! Must be able to do face to face interview.
Key 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.
Required Skills/Knowledge:
• 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
Preferred:
• 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.
Key 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.
Required Skills/Knowledge:
• 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
Preferred:
• 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.
Similar jobs
- CS
Journeyman Data Manager with Security Clearance
NewCIS Secure
Arlington, VA🇺🇸$120k - $150k/yrOn-site21 hours agoSQLMicrosoft OfficePower BI+1Technology - KE
Sr. Data Analyst- Reading PA, Onsite. Must attend F2F Interview. Need strong experience with database management, programming, and data visualization, SQL, Data Cleaning & ETL
NewKeylent
Reading, PA🇺🇸On-site21 hours agoSQLETLTechnology - PC
Product Analytics
Pyramid Consulting, Inc.
Santa Clara, CA🇺🇸$60 - $64/hrOn-site7 weeks agoSQLLookerMachine Learning+4 - BY
Data Analyst - Need local to New York
NewByteware Inc.
New York, NY🇺🇸Hybrid21 hours agoSQLAWSTableau+1Technology - NS
Sr Data Analyst
NewNava Software Solutions
Dallas, TX🇺🇸On-site21 hours agoMongoDBSQLSQL Server+3Technology - NO
DATA QUALITY ANALYST
NewNodeLogix
Columbus, OH🇺🇸On-site21 hours agoSQLSQL ServerT-SQL+8
