Job Summary:
Connective Business Solution is seeking a Data Warehouse Analyst to gather and assess business information needs and prepare system requirements. The role involves performing analyses, development, and evaluation of data mining in a data warehouse environment, ensuring data accuracy, and providing technical consulting to users.
Responsibilities:
• Responsible for gathering and assessing business information needs and preparing system requirements.
• Performs analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation.
• Uses data mining and data analysis tools.
• Reviews and validates data loaded into the data warehouse for accuracy.
• Interacts with user community to produce reporting requirements.
• Provides technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage.
• Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments.
• Possesses working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools.
• Must have an extensive knowledge of data warehouse and data mart concepts.
Qualifications:
Required:
• Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
• A minimum of 3 years of IT work experience in business intelligence tools and systems.
• Responsible for gathering and assessing business information needs and preparing system requirements.
• Performs analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation.
• Uses data mining and data analysis tools.
• Reviews and validates data loaded into the data warehouse for accuracy.
• Interacts with user community to produce reporting requirements.
• Provides technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage.
• Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments.
• Possesses working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools.
• Must have an extensive knowledge of data warehouse and data mart concepts.
• Intermediate professional level role.
• Provides data warehouse architectural design, development and support in multi-platform environments.
• Works on multiple projects as a team member and may lead projects of moderate complexity.
• May coach more junior technical staff.
Company:
Welcome to Connective Business Solution – your trusted partner in driving business success for small and medium-sized enterprises (SMBs) as well as large-scale and government projects. Founded in 2022, the company is headquartered in Orlando, US, , with a team of 11-50 employees. The company is currently Early Stage.