Key Responsibilities:
Data Architecture:
- Lead the design, development, and implementation of comprehensive enterprise data architectures, primarily leveraging Azure and Snowflake platforms.
Data Transformation & ETL:
- Oversee and guide complex data transformation and ETL processes for large and diverse datasets, ensuring data integrity, quality, and performance.
Customer-Centric Data Design:
- Specialize in designing and optimizing customer-centric datasets from various sources, including CRM, Call Center, Marketing, Offline, and Point of Sale systems.
Data Modeling:
- Drive the creation and maintenance of advanced data models, including Relational, Dimensional, Columnar, and Big Data models to support analytical and operational needs.
Query Optimization:
- Develop, optimize, and troubleshoot complex SQL and NoSQL queries to ensure efficient data retrieval and manipulation.
Data Warehouse Management:
- Apply advanced data warehousing concepts to build and manage high-performing, scalable data warehouse solutions.
Tool Evaluation & Implementation:
- Evaluate, recommend, and implement industry-leading ETL tools such as Informatica and Unifi, ensuring best practices are followed.
Business Requirements & Analysis:
- Lead efforts in business requirements definition and management, structured analysis, process design, and use case documentation to translate business needs into technical specifications.
Reporting & Analytics Support:
- Collaborate with reporting teams, providing architectural guidance and support for reporting technologies like Tableau and PowerBI.
Software Development Practices:
- Apply professional software development principles and best practices to data solution delivery.
Stakeholder Collaboration:
- Interface effectively with sales teams and directly engage with customers to understand their data challenges and lead them to successful outcomes.
Project Management & Multi-tasking:
- Demonstrate exceptional organizational skills, with the ability to manage and prioritize multiple simultaneous customer projects effectively.
Strategic Thinking & Leadership:
- Act as a self-managed, proactive, and customer-focused leader, driving innovation and continuous improvement in data architecture.
Position Requirements:
- Strong experience with data transformation & ETL on large datasets.
- Experience with designing customer-centric datasets (e.g., CRM, Call Center, Marketing, Offline, Point of Sale).
- 5+ years of experience in Data Modeling (e.g., Relational, Dimensional, Columnar, Big Data).
- 5+ years of experience with complex SQL or NoSQL queries.
- Extensive experience in advanced Data Warehouse concepts.
- Proven experience with industry ETL tools (e.g., Informatica, Unifi).
- Solid experience in Business Requirements definition, structured analysis, process design, and use case documentation.
- Experience with Reporting Technologies (e.g., Tableau, PowerBI).
- Demonstrated experience in professional software development.
- Exceptional organizational skills with the ability to manage multiple simultaneous customer projects.
- Strong verbal & written communication skills to interface with sales teams and lead customers to successful outcomes.
- Must be self-managed, proactive, and customer-focused.
Technical Skills:
- Cloud Platforms: Microsoft Azure
- Data Warehousing: Snowflake
- ETL Methodologies: Extensive experience in ETL processes and tools
- Data Transformation: Large-scale data transformation
- Data Modeling: Relational, Dimensional, Columnar, Big Data
- Query Languages: Complex SQL, NoSQL
- ETL Tools: Informatica, Unifi (or similar enterprise-grade tools)
- Reporting & BI: Tableau, PowerBI
