Database Architect - Expert
Database Architect - Expert
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Lead Data Engineer
30 Months
Albany NY
HBITS/ ITS
1. Develop and execute complex queries and procedures.
2. Manage and maintain scripts and code in source control repository.
3. Interact with the development team and business users to understand business process flow and business rules.
4. Document data models data migration and data quality requirements and solutions.
5. Guide and coordinate cross-functional teams (developers DBAs business analysts) to ensure successful project execution.
6. Monitor project progress identify and resolve roadblocks and escalate issues as needed.
7. Write complex SQL queries stored procedures and functions to retrieve manipulate and analyze data.
8. Utilize analytic functions and other advanced SQL techniques for data aggregation and transformation.
9. Optimize SQL queries for performance.
10. Use SQL to extract data for data analysis reporting and business intelligence.
11. Develop and maintain reports and dashboards to track key performance indicators (KPIs).
12. Analyze existing systems and data flows to identify areas for improvement.
13. Communicate technical concepts to both technical and non- technical audiences.
14. Provide technical guidance and mentorship to junior team members.
15. Document data flows system integrations and data governance processes.
16. Provide knowledge transfer to other data management team members.
17. Data Modeling:
* Design develop and implement conceptual logical and physical data models for OLTP systems.
* Maintain and update existing data models to reflect changing business requirements.
**Maintain Entity Relationship Diagrams for each model.
**Maintain a complete data dictionary for all new models
***Each table and column should be fully described.
* Generate and publish data definition language (DDL) from physical data model to target databases.
* Manage the promotion of database changes throughout the environments.
* Ensure data models are aligned with data governance principles and standards.
* Manage monitor and troubleshoot issues.
18. Data Migration
* Design develop and implement data migration strategies including data extraction transformation and loading (ETL) processes for the migration of data.
** Perform all stages of data migration from data analysis to pre go-live validations user acceptance testing user sign-off cut-over planning and post go-live validations.
* Interact with business users to understand business process flow business logics and to assess major data objects data volume for data migration.
* Document data migration processes and procedures.
* Test and validate data.
* Select and implement appropriate integration patterns and technologies for data migration (e.g. APIs message queues bulk data transfer).
* Develop and maintain data migration scripts and tools.
* Ensure data quality and integrity throughout the migration process.
* Develop data quality reports for the business to identify and drive data cleansing and remediation efforts.
* Ensure data migration activities comply with industry standards best practices and organizational guidelines (e.g. data security privacy regulations).
* Manage monitor and troubleshoot issues.
Title : Location : Duration : Client : Requirements :
Employment Type
Full-time
