Data Architect - Charlotte

Company: Syntelli Solutions
State/City: Charlotte
Job Description:

"Syntelli" means SYNchronizing inTELLIgence with data. We make companies smarter by unlocking the value of their data and orchestrating radical business strategies to enable better, faster business decisions. Syntelli has become a trusted leader in providing a full range of data science and Big Data services including enhanced data lake practices, data governance, and the latest data-shaping and data science practices.

Syntelli is looking to add a Data Architect to our IT Organization in Charlotte, NC. We are seeking a skilled Data Architect to participate in the building, optimization, and maintenance of conceptual and logical database models.

Responsibilities:

Must have a strong understanding of the full lifecycle surrounding Software Development, Deployment, and Data Pipeline Provide expertise in Cloud Technologies – Data Lakes, Factions, etc. Must be highly hands-on in the Architecture/Development space Develop database solutions to store and retrieve company information Improve system performance by conducting tests, troubleshooting and integrating new elements Must have strong skills in the areas of Data Integration, Security, and Modeling Design conceptual and logical data models and flowcharts Install and configure information systems to ensure functionality Define
security and backup procedures Analyze structural requirements for new software and applications Optimize new and current database systems Coordinate with the Data Science department to identify future needs and requirements Provide operational support for Management Information Systems (MIS)

Requirements:

Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role In-depth SQL programming knowledge - partitioning, indexing, performance tuning knowledge, stored procedure, views Skilled in Data modeling and DW concepts – star schema, snowflake schema, facts, dimensions, KPI, load strategies, surrogate keys, business keys, slowly changing dimensions, staging layer, information layer, analytic layer, data loading concepts Experience in Azure Cloud Technologies Strong understanding/experience with deep ETL concepts – complex transactions (folder traversing, transaction handling, logging, auditing, error handling, data versioning with the tool, deployment concepts) In-depth understanding of database structure principles Experience gathering and analyzing system requirements Knowledge of data mining and segmentation techniques Proficiency in MS Excel Familiarity with data visualization tools (e.g. Tableau, D3.js and R) Proven analytical skills


Salary: Negotiable

Age requirements:
Minimal experience: No experience


Jobs you may be interested in


Tips You May Be Interested In