Job Description
Data Architect at TechnoGen, Inc. Data Architect at TechnoGen, Inc. in EDGEWATER, Maryland Posted in about 6 hours ago.
Type:
full-time Job Description:
Position:
Data Architect & Technical Lead Location:
Hybrid - 2-3 days at office in Annapolis MD Duration:
12 Months Job Description :
This role will serve as the primary technical and analytical expert for the COMStat program. This role is responsible for designing and maintaining core data structure, developing data pipelines, leading advanced analytical work, and supporting the creation of dashboards, reports, and open data products . Key Responsibiliti esData Architectu reDesign, implement, and maintain the data architecture that supports COMStat dashboards, performance management, and analytic product s.
Write complex and efficient SQL queries aligned with Teradata architecture and enterprise performance need s.
Build and manage ETL/ELT pipelines to ingest, transform, and structure internal and external dataset s.
Integrate data from multiple systems, APIs, cloud platforms, and external sources to create comprehensive, analysis-ready dataset s.
Analytical & Performance Management Suppo rtSupport team members in conducting advanced data analytics, including data modeling geospatial analysis, and trend identificatio n.
Contribute to the development and maintenance of dashboards, reports, and scorecards using Power BI, Tableau, or similar tool s.
Help translate complex analytical findings into clear, actionable insights using narratives, visualizations, and data storie s.
Support analytic projects in integrating equity considerations into methods, metrics, and interpretatio n. Required Qualificati onsBachelor's degree or relevant education, training or equivalent professional experience in data science, computer science, information systems, statistics, engineering, or a related fie ld.5+ years of experience in data architecture or data engineering, including designing and managing data pipelines, data models, and enterprise data environmen ts.
Strong proficiency in SQL, with experience optimizing complex queries in Teradata or comparable MPP databases (e.g., Snowflake, Redshift, BigQuer y).Hands-on experience building, maintaining, and troubleshooting ETL/ELT pipelines using modern data integration tools or workflow orchestration platfor ms.
Experience integrating data from APIs, cloud platforms, and enterprise systems into analysis-ready datase ts.
Proficiency in a scripting or analytical programming language such as Python or R.Experience supporting advanced analytical work, including preparing optimized datasets for statistical, geospatial, or trend analys es.
Familiarity with developing or supporting dashboards and reports using tools such as Tableau or Power BI.Demonstrated ability to diagnose and resolve data workflow issues, pipeline failures, and dashboard/reporting erro rs.
Strong verbal and written communication skills, including the ability to explain technical concepts to non-technical stakeholders at all leve ls. Preferred Qualificat ionsExperience with Teradata ecosystem tools such as BTEQ, TPT, or Viewpo int.
Experience architecting or managing data systems in cloud environments (e.g., Azure, AWS, G CP).Experience working with open data platforms or publishing public-facing datas ets.
Familiarity with Stat programs, performance management systems, or public-sector analyt ics.
Experience incorporating equity considerations into analytic and technical w ork.
Experience with geospatial data or tools such as ArcGIS or Q GIS.Familiarity with data modeling frameworks (e.g., dimensional modeling) and metadata documentation practi ces.
Experience with workflow orchestration tools (e.g., Airflow, Azure Data Factory) or CI/CD practices for data pipeli nes.