What are the responsibilities and job description for the Database Architect position at Mejenta Systems, Inc.?
Senior Data Analyst
Worksite flexibility: Hybrid
Hybrid (3 days/week in Wilmington, DE) - Candidate must be local
Great communication skills are a must
Candidate cannot have additional vendor layers
Job Description
We are looking for a Senior Data Analyst to gather and validate requirements, validate designs, and develop database solutions. This position will be full-time and hybrid.
What You’ll Do
- Create, maintain, and tune complex SQL scripts
- Create and maintain existing SQL based custom reports
- Maintain complex data models
- Create and maintain data interfaces (scripted ETL) between our on-premise Oracle environment and MS SQL Server on the Azure based platform
- Build and maintain Oracle Data Marts and associated ETL processes
- Import / Export data from SQL Server/Oracle XML and CLOB Queries and convert data to standard Oracle tables
- Accurately develop database queries, reports, data loads/extracts in a logical manner from scratch
- Create new and maintain/tune existing SQL queries and procedures
- Create and maintain existing SQL based custom reports
What You'll Need
Required:
- 7 years of experience as a Senior Database Analyst/Architect
- BS/MS degree in Computer Science, Engineering, or a related subject
- Extensive experience in all aspects of Oracle SQL programming and query manipulation
- Experience working with MS SQL Server databases
- Extensive experience working with large sets of data and resolving data-oriented issues
- Extensive experience with data profiling and data quality assurance. This includes the understanding of creating an audit trail for peer review of work completed
- Extensive experience in tuning queries for optimal performance
- Ability to work directly with business users to quickly translate business reporting requests/requirements and produce a work product that has been vetted for quality and meets requirements as stated
- Strong communication skills, both written and oral
- Ability to investigate and identify query performance related issues
- Critical thinker and problem-solving skills