TekStream Solutions
Mid-Level Data Architect (Hybrid in Atlanta) - Permanent
TekStream Solutions, Atlanta, Georgia, United States, 30383
Mid-Level Data Architect (Hybrid in Atlanta) - Permanent
Mid-Level Data Architect (Hybrid in Atlanta) - Permanent
Get AI-powered advice on this job and more exclusive features. Direct message the job poster from TekStream Solutions TekStream is partnering with an enterprise Insurance firm for a Mid-Level Permanent Data Architect in Atlanta (Brookhaven) onsite 4 days per week. You will be collaborating with other teams in their new Ontology AI division. Conduct data analysis and generate insights to inform architectural decisions and improve existing pipelines from end to end. Support implementation of the Medallion Architecture (Bronze, Silver, Gold) with structured design and clean data flow across layers. Collaborate with cross-functional teams (e.g., Analytics Delivery, back office, data engineering, data science, strategy, and operations) to understand business needs and translate them into actionable data solutions. Develop and maintain complex SQL queries, data pipelines, diagrams, and models. Design, document, and maintain dimensional models using Kimball methodology to support self-service and reporting use cases. Build and maintain interactive dashboards and reports using Tableau and other visualization tools. Mentor junior data analysts and contribute to the professional development of the team. Conduct in-depth data analysis to identify data quality issues, usage patterns, root causes, and business impacts. Build and maintain data catalogs, metadata definitions, and lineage documentation Assist with data ingestion and transformation using Databricks, Python, and Informatica IICS. Develop semantic models and visualizations in Power BI, with a focus on enabling business-driven analysis. Work with Oracle databases to support both operational and analytical data needs. Ensure all data artifacts align to governance standards, quality expectations, and performance benchmarks. What You Bring: Bachelor's degree in related field or equivalent experience preferred. Minimum of 4+ years of experience in a related field. 5+ years of experience in an analytical or reporting role. 2-5 years of experience in data analyst, data engineering, or advanced analytics. 5+ years expertise with SQL, Data Blending and/or ELT tools such as Informatica or Alteryx. 5+ years of experience with BI tools such as Tableau or Power BI 5+ years of experience in designing database structures and relationships with data modeling techniques and creating Entity-Relationship Diagrams (ERDs) using tools such as Erwin, Lucid Chart 3+ years of cloud experience such as AWS or OCI Proven ability to perform deep data analysis using SQL, Python, or BI tools, identifying patterns, anomalies, and business drivers. Working knowledge of: Oracle and relational data modeling Databricks (notebooks, Lakehouse architecture) Python for scripting and analysis Informatica IICS or other ETL tools Familiarity with data governance, cataloging, and metadata practices. Strong organizational skills, attention to detail, and the ability to document and explain data decisions clearly. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Insurance Referrals increase your chances of interviewing at TekStream Solutions by 2x Sign in to set job alerts for Data Architect roles.
Atlanta, GA $120,000.00-$150,000.00 2 days ago Portfolio Architect, AWS and Big Data Solutions
Solutions Architect, Retail, Google Cloud
Atlanta, GA $147,000.00-$216,000.00 1 week ago Senior Consultant Data Governance & Strategy/Data Architect
Alpharetta, GA $140,000.00-$160,000.00 2 weeks ago Atlanta, GA $140,000.00-$165,000.00 1 week ago Atlanta, GA $145,500.00-$280,000.00 1 week ago Data Management Architect - Atlanta, Georgia
Partner Solutions Architect, AI/ML, GTM, Google Cloud
Atlanta, GA $218,000.00-$306,000.00 2 weeks ago AI and Data Business Architect, Business Solutions Commercialization
Atlanta, GA $140,000.00-$150,000.00 2 months ago Alpharetta, GA $172,000.00-$196,500.00 2 weeks ago Atlanta, GA $120,000.00-$175,000.00 19 hours ago Atlanta, GA $150,000.00-$180,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Mid-Level Data Architect (Hybrid in Atlanta) - Permanent
Get AI-powered advice on this job and more exclusive features. Direct message the job poster from TekStream Solutions TekStream is partnering with an enterprise Insurance firm for a Mid-Level Permanent Data Architect in Atlanta (Brookhaven) onsite 4 days per week. You will be collaborating with other teams in their new Ontology AI division. Conduct data analysis and generate insights to inform architectural decisions and improve existing pipelines from end to end. Support implementation of the Medallion Architecture (Bronze, Silver, Gold) with structured design and clean data flow across layers. Collaborate with cross-functional teams (e.g., Analytics Delivery, back office, data engineering, data science, strategy, and operations) to understand business needs and translate them into actionable data solutions. Develop and maintain complex SQL queries, data pipelines, diagrams, and models. Design, document, and maintain dimensional models using Kimball methodology to support self-service and reporting use cases. Build and maintain interactive dashboards and reports using Tableau and other visualization tools. Mentor junior data analysts and contribute to the professional development of the team. Conduct in-depth data analysis to identify data quality issues, usage patterns, root causes, and business impacts. Build and maintain data catalogs, metadata definitions, and lineage documentation Assist with data ingestion and transformation using Databricks, Python, and Informatica IICS. Develop semantic models and visualizations in Power BI, with a focus on enabling business-driven analysis. Work with Oracle databases to support both operational and analytical data needs. Ensure all data artifacts align to governance standards, quality expectations, and performance benchmarks. What You Bring: Bachelor's degree in related field or equivalent experience preferred. Minimum of 4+ years of experience in a related field. 5+ years of experience in an analytical or reporting role. 2-5 years of experience in data analyst, data engineering, or advanced analytics. 5+ years expertise with SQL, Data Blending and/or ELT tools such as Informatica or Alteryx. 5+ years of experience with BI tools such as Tableau or Power BI 5+ years of experience in designing database structures and relationships with data modeling techniques and creating Entity-Relationship Diagrams (ERDs) using tools such as Erwin, Lucid Chart 3+ years of cloud experience such as AWS or OCI Proven ability to perform deep data analysis using SQL, Python, or BI tools, identifying patterns, anomalies, and business drivers. Working knowledge of: Oracle and relational data modeling Databricks (notebooks, Lakehouse architecture) Python for scripting and analysis Informatica IICS or other ETL tools Familiarity with data governance, cataloging, and metadata practices. Strong organizational skills, attention to detail, and the ability to document and explain data decisions clearly. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Insurance Referrals increase your chances of interviewing at TekStream Solutions by 2x Sign in to set job alerts for Data Architect roles.
Atlanta, GA $120,000.00-$150,000.00 2 days ago Portfolio Architect, AWS and Big Data Solutions
Solutions Architect, Retail, Google Cloud
Atlanta, GA $147,000.00-$216,000.00 1 week ago Senior Consultant Data Governance & Strategy/Data Architect
Alpharetta, GA $140,000.00-$160,000.00 2 weeks ago Atlanta, GA $140,000.00-$165,000.00 1 week ago Atlanta, GA $145,500.00-$280,000.00 1 week ago Data Management Architect - Atlanta, Georgia
Partner Solutions Architect, AI/ML, GTM, Google Cloud
Atlanta, GA $218,000.00-$306,000.00 2 weeks ago AI and Data Business Architect, Business Solutions Commercialization
Atlanta, GA $140,000.00-$150,000.00 2 months ago Alpharetta, GA $172,000.00-$196,500.00 2 weeks ago Atlanta, GA $120,000.00-$175,000.00 19 hours ago Atlanta, GA $150,000.00-$180,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr