Previous Job
Data Architect II
Ref No.: 18-00027
Location: Columbia, South Carolina
Position Type:Right to Hire
Start Date: 02/09/2018
Data Architect Job Description
Our client is interested in hiring an experienced Data Architect to design and build out a financial DataMart integrating multiple and varied data sources. The successful candidate will be adept with SQL, dimensional data modeling techniques, ETL development, source to target mapping, data integrity best practices, and must have at least three years' hands-on experience with .NET, C#, python or similar programming language. Database administration skills are a plus.

Responsibilities and Duties

• Design virtual and physical data models for a new financial DataMart integrating multiple sources with industry standard features
• Assist and develop SQL views for forms and reports
• Develop database design and architecture documentation for the management and executive teams
• Help maintain the integrity and security of the company database
• Document existing Database(s)
• Clean and validate data
• Generate anomaly reports for others to act upon
• Develop ETL jobs that transform, load and cleanse source data into the DataMart
• Develop and maintain the data dictionary for the DataMart
• Analyze and develop software programs to automate manual processes and/or replace legacy solutions
• Work with business analysts and DBAs to integrate new sources and/or modify the DataMart design
Required Skills
• Accounting & Financial knowledge & experience in connection with data marts/data warehouses and application development
• Database experience with MS SQL Server and Oracle
• Database tool experience with Microsoft SQL Server Management Studio or equivalent tool
• Experience with Erwin on equivalent data modeling tool
• ETL development experience with one or more of the following
o Informatica
o Alteryx
• Strong knowledge and use of SQL; multi table JOINS, functions, procedures, triggers, etc.
• Experience creating SQL views for the foundation of reports and forms
• 5+ years' experience in a data analysis
• Proven ability to work in distributed systems
• Proficiency with Microsoft SQL and Oracle required
Other Skills
• Must be able to develop creative solutions to problems
• Experience communicating complex and actionable concepts to management
• Building and delivering presentations to senior leadership
• Task management, prioritization, and leadership skills
• Excellent listening and communication (written & verbal) skills; ability to discuss and present information logically and concisely
• Ability to work individually and as part of a team. Willing to share knowledge & experience with others
• Must be a self-starter
• Operations/Business Process Improvement and/or Transformation experience. (preferred)
• Experience working with BPO providers. (preferred)
• Familiarity with SharePoint collaboration tool
• Working knowledge of standard Microsoft Office software:
(Word, Excel, PowerPoint, Visio)
• Experience with continuous improvement in an Operations environment
• Experience partnering with vendors to deliver on project goals/objectives and expected benefits
• Experience working in a matrixed, highly collaborative environment
Education & Experience Requirements
• Bachelor's Degree in finance, economics, or analytical field (Science, Math, Engineering, Economics, Finance) (Master's degree preferred)
• 2-5 years of experience in a business analytics environment
Possible temp-to-hire?