Data Architect at Entellimetrix LLC
Atlanta, GA
About the Job
We are an Atlanta GA based Data Analytics and Cloud consulting services company supporting our clients with their Data management, Analytics, Reports/Dashboards requirements. You can find more information about our company at www.entellimetrix.com. We are currently seeking an experienced Data Architect for our client. Work can be performed 100% remotely.
Essential Functions
- Design and implement enterprise data architecture that includes data components needed to build and deliver business solutions to include: Data Pipelines, Real time analytics, Cloud Computing, Streaming Data, AI & ML, APIs, and Cloud storage (i.e. Data Lake and Cloud SQL.)
- Translate business requirements into technical specifications, including data flows, integrations, transformations, databases, data warehouses, and Data Lakes.
- Develop architectural design patterns for data processing that implement Utz business processes within the software eco-system.
- Develop diagrams representing key data entities and their relationships.
- Define the data architecture framework, standards, and principles, including modeling, metadata, security, and master data.
- Design, maintain, document, and govern enterprise data flows within the organization. Data flows include data creation, transformations, and hot, warn, and cold storage.
- Collaborating and coordinating with multiple departments, stakeholders, partners, and external vendors
- Ensure BI data, architecture, UI/UX designs meet the overall needs of the enterprise.
- Guide the development, testing and implementation of Data Warehouse/Data Lake assets to support BI reports, dashboards, and BI solutions.
- Ensure projects are executed within agile Software Development Lifecycle (SDLC.)
- Guide the implementation of data solutions for self-service analytics.
- Assist in the development of data structures, views, and database co
- Components in support of BI solution development.
- Work with IT management in the development of 3-5 year Enterprise Data roadmap.
- Participates in the formulation of development procedures, standards, deployment/retirement and archiving as related to the data architecture, tools and applications.
- Ability to listen to user requirements and convey messages in a clear, concise, and empathetic manner using the appropriate communication medium;
- Create professional presentations to small work groups on both technical and functional requirements
- Interacts professionally with a diverse group, including executives, managers, and subject matter experts
- May perform other duties as required.
KNOWLEDGE, SKILLS & ABILITIES
Technical Skills
o SQL Server
o Azure Analysis Services
o Azure Data Lake
o ETL Tools like SSIS, Informatica.
- Familiarity with developing BI solutions using an industry leading BI platform (Microsoft PowerBI preferred).
- Data modeling and design including SQL development and database administration.
- Data visualization and data migration.
o Structured/relational database design
o Structured Query Language
o ETL Development
- Established data management and reporting technologies, and have some knowledge of columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data.
- RDMS (relational database management systems) and foundational database skills.
- Database management system software, especially Microsoft SQL Server.
- Databases such as NoSQL and cloud computing.
o Object Oriented Programming Language(s).
- Understanding of business functional areas, business management issues and data analysis