Data Architect (Data Modeling, ETL Pipelines and Data Warehouse)

TheData Architect plays a key role in designing, implementing, and managing scalable data architectures that support our customer’s business objectives. The ideal candidate will have a strong background in data modeling, database design, cloud-based data solutions, and data governance. You will collaborate with stakeholders across the organization to ensure data integrity, security, and accessibility.

Key Responsibilities:

• Design, develop, and maintain scalable and efficient data architectures.
• Design and develop the overall logical and physical data architecture for the customer’s data warehouse and/or data lake.
• Define data models, including star schema and 3NF, to support business intelligence and analytics needs.
• Optimize data models for performance, scalability, and cost-effectiveness, considering factors like query performance, data volume, and storage costs.
• Develop and implement data management strategies, including data governance, data quality, and metadata management.
• Work closely with business and IT teams to understand data requirements and translate them into technical solutions.
• Collaborate with data engineers, data scientists, business intelligence SMEs, and AI SMEs to ensure data integration and ETL processes align with the defined data architecture.
• Review and provide feedback on data mapping documents, data quality rules, and data profiling results.
• Develop and maintain data lineage and metadata documentation.
• Stay abreast of emerging data architecture trends and technologies.
• Optimize data storage, retrieval, and processing performance.
• Ensure data security, privacy, and compliance with relevant regulations (e.g., GDPR, HIPAA).
• Design and maintain ETL (Extract, Transform, Load) processes and data pipelines.
• Select appropriate data technologies and tools to meet business needs.
• Provide guidance and best practices on data modeling and database design.
• Work with cloud-based and on-premises data solutions, including relational and NoSQL databases.
• Collaborate with data engineers, analysts, and developers to enhance data accessibility and usability.
• Conduct workshops and training sessions to educate teams on data architecture principles.
• Document data architecture solutions and processes for future reference.

Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Data Architect, Data Engineer, or similar role.
• Strong proficiency in database management systems (SQL, NoSQL, PostgreSQL, MySQL, etc.).
• Experience with cloud platforms (AWS, Azure, Google Cloud) and their data services.
• Knowledge of big data technologies such as Hadoop, Spark, or Kafka is a plus.
• Familiarity with data governance and regulatory compliance.
• Proficiency in data modeling tools (Erwin, Lucidchart, etc.).
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.

Preferred Skills:

• Data Modeling (Star Schema, 3NF, Dimensional Modeling)
• Data Warehousing & Data Lake Architecture
• Data Integration, ETL/ELT Processes
• Cloud Platforms (Snowflake, AWS, Azure, GCP)
• Data Governance, Metadata Management
• SQL, Data Profiling & Quality
• Communication & Collaboration
• Knowledge of machine learning and AI-driven data processing techniques.
• Knowledge of data visualization tools like Power BI, Tableau, or Looker (nice-to-have but not mandatory).

DATA PRIVACY:

Novare values your privacy. By submitting your application, you hereby authorize Novare and its Affiliates to collect and process your Personal Information and Sensitive Personal Information (as defined under R.A. No. 10173 or the Data Privacy Act) contained in your resume and other documents and information provided to the Company for the processing of your job application. Your data is stored in Novare’s secure databases and retained until the expiration of the retention limit provided by law or when you revoke your consent.