Job Description
We are looking for a contractor, who is able to work 8 hours US (Washington) time. This position is long-term. Candidates need to be fluent in English.
Tasks and responsibilities:
- Responsible for creating, and maintaining, conceptual, logical, and physical data models defining business requirements for large scale applications and business intelligence purpose;
- Extensive experience in mapping data elements for ETL purposes;
- Optimize and update logical and physical data models to support new and existing projects;
- Experience in generating physical DDL to deploy to databases;
- Analyze data-related system integration challenges and propose appropriate solutions;
- Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces;
Profile:
- Bachelor or Master degree;
- +8 years of hands on experience in data analysis and modelling using ERWin for Structured data on relational database, such as Oracle, Postgres, SQL Server;
- Strong experience in wring SQL queries and scripts for data analysis and migration scripts;
- Strong experience in Azure Data Lake and migrating data from on-premise to cloud databases;
- Hands on experience in ETL, data cleansing, data dictionary, mapping and profiling;
- Experience in architecture & design of data models and modelling tools like Erwin;
- Experience with large datasets and analytics platforms as well as Cloud Technologies (Azure/AWS), AKS;
- Extensive experience as a Data Analyst and Data Programmer;
- Extensive experience with Postgres, Oracle and other database technologies;
- Extensive experience data visualizations tools such as PowerBi;
- Extensive experience with various system development lifecycle methodologies and tailoring theartifacts to those methodologies;
- Knowledge of Business Intelligence tools;
- Fluent in English;