Data Architecture & Design Manager

  • Columbus, OH

Company Description

360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.

Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and JQuery mobile. 

Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one’s business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel’s through us.

We make sure that we deliver performance driven products that are optimally developed as per your organization’s needs. Take a shot at us for your IT requirements and experience a radical change.

Job Description

The DSW Data Architecture & Design Manager requires an excellent communicator that thrives in a fast-paced, dynamic atmosphere. The candidate must be a process-oriented individual, with strong organizational skills, who has the flexibility to excel in a collaborative environment.

Required Skills:

: Data Design & Modeling

o Clear understanding of key concepts of Data Architecture and Database management systems (DBMS).

o Expert skills in schema design, relational and dimensional modeling (conceptual, logical and physical data models).

o Expert knowledge of SQL.

o Expertise in Data Warehousing theory (both Kimball and Inmon approaches).

o Experience with high-scale or distributed RDBMS (Teradata, Netezza, Greenplum, Aster Data, Vertica) or other physical relational databases (Oracle, MySql, etc.).

o Exposure to one or more physical NoSQL databases, (MongoDB, DynamoDb, etc.).

o Fluent in relational database concepts and flat file processing concepts.

o Experience with a Metadata Repository and Business Glossary used to improve data standards and provide quick and easy access to data lineage.

o Tools: Erwin or similar (Oracle Sql Data Modeler, MySQL Workbench, etc.).

: Design & Development

o Experience in all phases of Software Development Lifecycles (SDLC) /methodologies i.e. waterfall, agile.

o Hands on experience ETL (Extract-Transform-Load) tools (e.g Informatica, Talend, Pentaho, SSIS, DataStage, Clover) & processes and complex data migration strategies.

o Experience with related/complementary open source software platforms and languages (e.g. .NET, Java, Linux, Apache, Perl/Python/PHP, Chef).

o Experience working with one or more programming languages (Python, PL/SQL, Shell Scripting, Java).

o Experience with developing capacity plans for new and existing systems

o Tools: MS Visio

: Communication: Must possess excellent verbal and written communication skills (including formal documentation) as well as strong presentation and collaboration skills. Documentation must resonate with appropriate audience. Expert in the use of the following tools: MS Excel, MS Word, MS PowerPoint.

: Leadership & Interpersonal Skills

o Maintain partnerships across the organization and influence senior management, peers and staff through collaboration

o Demonstrate excellent interpersonal skills

o Work effectively as part of a team

o Exemplify DSW core values (Collaboration, Humility, Accountability & Passion)

o Demonstrate strong proactive and analytical thinking and problem solving skills

o Be flexible and adaptable to changing business models and organization structures and still detail oriented

o Multi-task, manage time and priorities and be self-directed while maintaining high degree of organization

Preferred Skills:

: Business Intelligence & Emerging Technologies

o New technologies, platform and approaches in analytics including Big Data, unstructured data analysis, social network data analytics.

o Familiarity with broad range of emerging data related technologies - Cloud , Distributed Databases, Data Replication, Data Science , Machine Learning, Big Data etc.

o Experience with noSQL and big data technologies such as Hadoop, Cassandra, Redis, etc. (e.g. administration, configuration management, monitoring, debugging, and performance tuning).

o Time series analysis, clustering, decision trees and neural networks.

: Data Quality: Informatica Data Quality or other data quality toolsets.

: Design & Development: Experience working with REST APIs, Data Analysis, Data Mining.

: Industry Knowledge: Experience with retail industry, focus on analytics, architecture and/or BI

: Other Tools / Applications

o Experience with architecture tools such as Creately, Gliffy, Google Draw, etc

o Jesta, Yantra, ATG, EP as transactional sources

o Essbase, Hyperion, SAS


: Bachelors' degree in Computer Science Engineering, Computer Science, Engineering, Management Information Systems or related field from an accredited college/university

: Master in Computer Science (or related) or MBA a plus

: 8+ years of experience delivering (designing, developing, and implementing) business intelligence solutions as a programmer, system analyst, ETL developer, or similar position

: 8+ years of experience with OLTP and OLAP database models

: Professional certifications, related published works or related speaking engagements are a plus

o Experience of presenting on Data Quality at a major industry conference

o Recognized data quality certification e.g. IQCP, CIMP, ISO 8000

o Published papers or articles on Data Quality in a major media site, industry journal or trade magazine

Additional Information

Ankur Bhatia | Lead Talent & Client Acquisition Specialist - TAG US