Data Warehouse Architect
Florida, Tampa-St. Petersburg-Cl
Data Warehouse Architect
The Data Warehouse Architect will help transform our team into a best-in-class business intelligence unit. He/she will help lead efforts to develop and maintain our corporate data warehouse including the ETL processes that load data into the data warehouse and will be responsible forbuilding and structuring the data warehouse to support the needs of the business. In addition, he/she will properly translate source target systems data into a dimensional data warehouse. The Senior Data Warehouse Architect will evaluate the company s current architecture and implement changes where necessary to adhere to industry standards and best practices for data warehouse design and will be responsible for working with our IT development staff to ensure that changes to the source system are architected and tested in the data warehouse in parallel with systems development to ensure timely and accurate reporting of new data elements.
What You ll Do
Design, implement, document, monitor and maintain the Data Warehouse ETL processes including timeliness, accuracy completeness and metadata.
Collaborate with business intelligence administrators/ architects and business units to deliver an overall integrated reporting architecture within the Data Warehouse platform.
Perform data analysis, design, implement, document and maintain relational (normalized and de-normalized) and multi-dimensional data stores.
Evaluate Data Warehouse processes for poorly performing, unnecessarily complex, difficult to maintain, or unstable processes or jobs and re-work, re-factor and simplify where possible.
Maintain and publish architecture documents including data model diagrams, data integration coding standards, data dictionary and data mapping documents.
Maintain and enhance the Enterprise Data Model to support business initiatives through careful and planned design while balancing model extensibility with performance.
Define and implement data modeling standards and best practices for Data Warehouse object names, logical data models and physical object design.
Support the processes to identify, capture and store data in the various Data Warehouse structures.
Support applications used to operate the Data Warehouse.
Ability to suggest best practices and work with developers to ensure best practices are performed for development of applications.
Open, track and resolve problem issues with vendors. Develop, maintain, and review data processes and architecture.
Demonstrate ability to learn and research advanced data technologies and concepts, learning new skills and emerging technology as necessary.
Assess all risks and offer mitigation strategies, communicating impacts to projects across multiple channels.
Interpret client functional and informational needs and turn them into data requirements, process models, and active systems.
Proficiency in data warehousing, data mining, data lake design and implementation.
Experience with conceptual and logical data modeling activities and good understanding of logical functional/data decomposition activities.
Experience with cloud storage solutions and Proficiency with RDBMS s like MySQL, TSQL Etc.
Proficiency with ETL solutions/tools and unstructured NoSQL data.
What You ll Need to be a Top Candidate
Required: Bachelor s Degree in Computer Science or similiar.
Minimum of 5 years experience in data warehousing and business intelligence reporting
Minimum of five (5) years of hands-on experience using SQL Server Integration Services SSIS.
Experience in developing a semantic data layer for easy access of business users.
Demonstrated experience in business intelligence and data warehousing principles, approaches, technologies and architectures.
Experience with ETL tools required.
Strong SQL database background, with SQL, TSQL and SQL tuning. Experience as an SQL DBA strongly preferred.
Good analytical & problem-solving skills and interest in learning and applying new technologies.
Understanding of data warehouse and relational database concepts such as Kimball and Inman.
Demonstrated ability to solve problems of diverse scope and working in complex environments.
Proficient in data modeling tools.
Advanced SQL optimization and skills required.
Ability to work in cross functional teams and communicate with colleagues in both business and technical terms.
Performance tuning experience.