> Markdown version of [/jobs/ext/560132-data-architect-and-modeler](https://www.wearedevelopers.com/jobs/ext/560132-data-architect-and-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect and Modeler - **Company:** CYNET SYSTEMS INC. - **Location:** Alpharetta, GA, United States - **Experience:** Expert - **Salary:** $135,200.0 - $145,600.0 - **Contract:** Temporary to permanent - **Skills:** Microsoft Excel, Data Analysis, Profiling, Data Architecture, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Sharing, Data Warehousing, Oracle Exadata, Excel Macros, Apache Hadoop, Python (Programming Language), Meta-Data Management, MongoDB, Operational Data Store, Performance Tuning, Power BI, SQL Stored Procedures, SQL Databases, Data Streaming, Enterprise Data Management, Scripting, Macros, Snowflake, Apache Spark, Informatica Cloud, Information Technology, Collibra, Real Time Data, Physical Data Models, Domain Driven Design, Splunk, Data Pipelines, Sql Tuning, Microservices - **Published:** June 5, 2026 - **Apply:** https://www.careerjet.com/jobad/us9e82b97b6eabadb5cfd934cf973d56c1 ## About the Role * 15+ years of experience in enterprise data architecture and data modeling. * Extensive hands-on experience with ER, Logical, Physical, and Conceptual data modeling. * Strong expertise using data modeling tools such as Erwin. * Experience designing highly performant Operational Data Stores and near real-time Data Warehouses. * Strong understanding of Kimball and Inmon data warehousing methodologies. * Experience in data governance, metadata management, and maintaining a single source of truth. * Strong SQL development, analysis, and performance tuning experience. * Hands-on experience with Snowflake including stored procedures, pipelines, and data sharing. * Strong experience with MongoDB, Oracle Exadata, Hadoop, and Spark. * Strong scripting skills using Python for automation, monitoring, and data integration. * Experience facilitating data modeling and business requirement sessions with stakeholders. * Experience with reverse and forward engineering analysis and source-to-target mappings. Experience: * 10+ years of data analysis and profiling experience in financial services. * Experience working with account, card, payment, or digital processing systems. * Experience with event streaming and event-driven data warehousing methodologies. * Experience with Domain Driven Design (DDD), Data Mesh, Microservices Architecture, and Bounded Contexts. * Experience designing and maintaining enterprise Data Catalog solutions. * Experience with Alation, Collibra, or similar metadata management tools preferred. * Experience with Matillion, SnapLogic, or DBT preferred. * Experience with Power BI dashboard design and reporting. * Strong Excel and Splunk experience including advanced macros and data analysis. * Experience with BIAN, IBM Banking & Financial Markets Model, or ISO20022 preferred., * Excellent analytical and problem-solving skills. * Strong interpersonal and communication abilities. * Ability to work in complex, fast-paced enterprise environments. * Strong organizational and stakeholder management skills. * Ability to handle multiple priorities and deliver within timelines. Skills: * Data Architecture. * Data Modeling. * Erwin. * Snowflake. * SQL., * Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related field preferred. * Equivalent practical experience in enterprise data architecture and modeling accepted. ## Description * Design and deliver enterprise data architecture solutions across cloud and on-premises environments. * Create ER, Logical, Physical, and Conceptual data models. * Develop scalable Operational Data Stores and near real-time Data Warehouses. * Establish and enforce enterprise data standards, governance policies, and best practices. * Drive data reuse and maintain a single version of truth across enterprise data platforms. * Facilitate and lead data modeling and architecture sessions with business and technical stakeholders. * Design event-driven and streaming-based data warehouse architectures. * Develop source-to-target mappings and reverse/forward engineering analysis. * Build and optimize Snowflake data pipelines, stored procedures, and data sharing solutions. * Perform SQL tuning and optimization for high-performance physical data models. * Create dashboards and visualizations using Power BI. * Develop Python scripts for alerts, automation, ingestion, and governance processes. * Build and maintain enterprise Data Catalog and metadata lineage solutions. * Support modern data architecture initiatives including Data Mesh and Domain Driven Design. * Mentor and coach junior team members on data architecture best practices., * MongoDB. * Oracle Exadata. * Hadoop. * Spark. * Power BI. * Splunk. * Excel Macros. * Data Governance. * Data Warehousing. * Kimball Methodology. * Inmon Methodology. * Event Streaming. * Domain Driven Design (DDD). * Data Mesh. * Microservices Architecture. * Source-to-Target Mapping. * Metadata Management. * Alation. * Collibra. * Matillion. * SnapLogic. * DBT. * ISO20022. * BIAN Framework., Title: Data Modeler/ Analyst with exposure of AEP/ CDP project Location: Alpharetta, GA(LOCAL) Job Description: STAFFXPERT is seeking a highly skilled and experienced Marketi… + 17 hours ago + Apply easily, Job Title: Data Modeler/ Analyst Location: Alpharetta, GA Position Type: Contract Duration: 6 / 12 Month Work Type: Onsite Rate: Pay range offered to a successful candida… + 17 hours ago + Apply easily ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [40 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs](https://www.wearedevelopers.com/videos/208-40-minutes-to-build-a-serverless-covid-19-rest-and-graphql-apis) - [Our journey with Spring Boot in a microservice architecture](https://www.wearedevelopers.com/videos/511-our-journey-with-spring-boot-in-a-microservice-architecture) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [NoSQL Data Modeling for Front-end Developers](https://www.wearedevelopers.com/videos/297-nosql-data-modeling-for-front-end-developers) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)