Role : Senior Data Analyst / Data Warehouse Consultant
Location : Santa Clara, CA
Duration : 12 Months
Required Skills & Abilities :
- Creation of IT data models (., conceptual, logical, physical, canonical);
- Implementation of data design and transformation procedures;
- Creation of frameworks for representing data elements;
- Resolution of conflicts between data models;
- Design, creation, and maintenance of relational and dimensional databases and data systems;
- Recommendation and implementation of data reliability, efficiency, and quality improvements.
- Enhancements to existing database systems to increase operating efficiency or adapt newer requirements;
- Recommendation and implementation of data reliability, efficiency and quality improvements;
- Adherence and contribution to work plan timelines, managing workflows to meet project timeframes;
- Design and creation of data processing systems that combine core data sources into data repositories
- Map documentation of data elements from UI screens to database, mapping between 2 databases.
- Data conversions, imports, and exports of data within and between internal and external systems;
- Develop data migration scripts for loading data from old system to new target system(s).
- Develop data transformation and automation processes supporting business systems and data flows;
- Maintain data repositories quality by adding, modifying, and deleting data as needed and as requested;
- Troubleshoot data issues and data processing tools, systems, and software;
- Identify and resolve problems related to database management systems;
- Develop and maintain a query library to support recurring data requests;
- Maintain data dictionaries and other related data processing metadata;
- Implement statistical models to identify trends, correlations, and patterns in data sets;
- Catalog data sources;
- Perform data cleansing and filtering;
- Design analytical dashboards and reports;
- Mine and analyze multiple data sets (Dimensional) for trends, insights, problems, etc;
- Document models, solutions, data mapping, technical specifications, data dictionaries, test cases, etc.;
- Relational Database Modeling (conceptual, logical, and physical) : 3+ years’ experience;
- Tools : Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS : 6-7 years’ experience;
- Tools : Quest Erwin or similar data modeling tool 1 year experience
Desired Qualifications :
- Dimensional Database Modeling
- Data Vault 2.0 Methodology and architecture
- Tools : Microsoft Azure Storage, ADLS GEN 2, Power Automate, Azure Logic Apps, Azure AI Document Intelligence
- Tools : Oracle RDBMS
Education :
- Bachelor’s degree higher in a quantitative field (. Computer Science, Statistics, Engineering) or equivalent work experience
Data Analyst JOB Training Program
Year Up United is a one-year or less, intensive job training program that provides young adults with in-classroom skill development, access to internships and/or job placement services, and personalized coaching and mentorship.Year Up United participants also receive an educational stipend.The progr...
data analyst
Perform data modeling, data analysis, and development of key performance indicators Create, maintain, define reporting processes for overall revenue vertical Work with end users of information to research reported data anomalies, identify root causes, and determine remediation steps Must see the sto...
Sr Fair Lending Compliance Data Analyst
LendingClub Bank’s Compliance Department is seeking an experienced and qualified compliance professional to fill the role of Sr Data Analyst. The Sr Data Analyst will partner with the credit risk teams and compliance leadership to ensure compliance with all fair lending laws and regulations. This ro...
Data Analyst
Merit Services is currently seeking an exceptional and driven Data Analyst to join our esteemed client’s vibrant team in Vaughan. As a Data Analyst, you will play a pivotal role in helping our client achieve their commercial objectives through your robust analytical acumen. Proven experience as a Da...
Data Analyst 3
Capture, synthesize, and interpret disparate quantitative data within the context of business objectives, identify trends, and explore data through segments and cohorts. Partner with Finance, Product & Marketing teams to build quarterly and annual plans using data science modeling. Ability to in...
Gcp Data Engineer/ Sme/ Consultant
Exposure to GCP Services and Tools like: Google Cloud Pub Sub, Google Cloud Dataflow, Google Cloud Dataproc, Google Cloud Big Query, Google Cloud BigTable, Google Cloud SQL, Google Cloud Datastore. JOB ROLE: GCP DATA ENGINEER/ SME/ CONSULTANT. Strong experience in Data Services. Strong experience in...
Technical Data Analyst
Advanced SQL skills to get the data you need from a data warehouse and perform data segmentation and aggregation from scratch. Data query and data processing tools/systems (e. Ability to grasp quickly and get up to speed on instrumentation, clickstream data, data architecture, and complex business s...
Senior Data Quality Analyst - Registration and Coding, FT (J0824-0076)
Job Number: J0824-0076 Job Title: Senior Data Quality Analyst - Registration and Coding, FT (J0824-0076) Job Type: Full-Time Permanent Location: General Site, 4001 Leslie Street Job Category: Data Analyst Date Posted: September 12, 2024 Closing Date: October 14, 2024 Salary: $42. Senior Data Quality...
Data Analyst V - 24-00923
Primary Skills: SQL, R/Python, Tableau, Statistics, Data Analysis. Analyze extensive data sets to understand product changes' impact on customer journeys and traffic/revenue goals. Communicate business performance clearly to product teams, facilitating informed decision-making through meticulous dat...
Associate Provider Network Data Analyst (Remote in TN)
The Associate Provider Network Data Analyst plays a critical role in supporting cross-departmental communication and collaboration through data analysis and reporting. Data Interpretation and Reporting:. Analyze and interpret large datasets, and create visual reports to effectively communicate findi...