A Data Architect is responsible for designing, developing data and ETL work for the NX organization. The data engineer must ensure data is efficiently stored, accessed, and analyzed by leveraging advanced data modeling techniques, cloud technologies, and data governance practices while collaborating with cross‑functional teams to meet business needs and drive data‑driven decision‑making.
Responsibilities
- Design and implement data pipelines for data ingestion, transformation, and loading (ETL/ELT) across various data sources.
- Ensure seamless integration of data from disparate systems and applications.
- Optimize data flow for performance and scalability.
- Leverage cloud‑based data warehousing and data lake solutions (AWS, Azure, GCP) for data storage and processing.
- Design and implement cloud‑native data architectures for scalability and cost‑efficiency.
- Work closely with business stakeholders, data analysts, data scientists, and data engineers to understand data requirements and translate them into technical solutions.
- Monitor data quality and performance metrics to identify and address data issues.
- Continuously optimize data pipelines and database structures for improved efficiency.
Required Skills and Experience
- Deep understanding of data modeling concepts (dimensional, star schema, snowflake)
- Proficient in SQL (6+ years of experience)
- Experience with Oracle SQL, relational databases, stored procedures, materialized views
- Experience with Azure ADLS Blobs, Azure Data Factory
- Knowledge of Python and data visualization tools such as Power BI is a plus
- Experience with cloud databases like Redshift, Synapse, Snowflake, Firebolt
- Familiarity with data quality tools and techniques
- Strong communication and collaboration skills
- Analytical and problem‑solving abilities
Minimum Qualifications
- 15+ years of experience in data architecture principles, database technologies, and best practices to optimize data management and scalability
- 10 years in analytics and system development
- High proficiency in SQL and database management
- Experience in generating process documentation and reports
- Excellent communication skills and ability to translate data into actionable insights
- Knowledge of Azure SQL Database, Azure Data Factory, Oracle, and MySQL
- Strong time management skills
- Ability to deliver in a rapidly changing environment
Preferred Qualifications
- Knowledge of process modeling
- Knowledge of continuous improvements
Education & Certifications
- Bachelor’s degree in mathematics, statistics, economics, engineering, or related business/analytical discipline