Keep the discussion going--join our JobWatch Group on LinkedIn!

Sign In
 [New User? Sign Up]
Mobile Version

Data Warehouse Architect

Kelly Services

Tampa, FL
Job Code:
Kelly Services
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

Job Title Data Warehouse Architect

Jobid US57L8BM_BH1435336

Location: Tampa, FL, 33603, USA

Description Kelly Services is looking for a Senior Data Warehouse Architect to join a growing company in the Insurance industry here in Tampa. If you are interested please apply below or send resumes directly to

**Job description**

The Senior 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.


+ 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, SQL Etc.
+ Proficiency with ETL solutions/tools and unstructured NoSQL data.
**Education** :

+ Required: Bachelor’s Degree in Computer Science or similiar.
**Experience** :

+ Minimum of 5 years’ experience in data warehousing and business intelligence reporting
+ Minimum of five (5) to ten (10) 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 Oracle database background, with SQL, PL/SQL and SQL tuning. Experience as an Oracle DBA strongly preferred.
+ Good analytical & problem-solving skills and interest in learning and applying new technologies.
**Why Kelly** **®** **?**

With Kelly, you’ll have direct connections to leading IT organizations in the best companies aroundthe globe—offering you the chance to work on some of today’s most intriguing, innovative and high-visibility projects. In a field where change is the only constant, our connections and opportunitieswill help you take your career exactly where you want to go. We work with 95 of the Fortune 100™companies, and more than 3,000 IT hiring managers turn to us each year to access the best talent:people like you.

Last year we found 8,000 opportunities for IT professionals. Let us help advance your careertoday.

**AboutKelly Services** **®**

As a workforce advocate for over 70 years, we are proud to directly employ nearly 500,000 people around the world and have a role in connecting thousands more with work through our global network of talent suppliers and partners. Revenue in 2017 was $5.4 billion. Visit and connect with us on Facebook, LinkedIn and Twitter .

Kelly Services is an equal opportunity employer including, but not limited to, Minorities, Females,Individuals with Disabilities, Protected Veterans, Sexual Orientation, Gender Identity and iscommitted to employing a diverse workforce. Equal Employment Opportunityis The Law.

Powered ByLogo