Principal Data Solutions Architect

Job Title: Senior Data Engineer

Role Description:

The Senior Data Engineer will work with business stakeholders to understand processes. This individual will design and implement data solutions, identify and address data transformation and cleansing requirements, and develop a scalable, reliable, and high-performance data processing pipeline.

Key Responsibilities:

• ">
• Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions.">
• Design, develop, and maintain ETL workflows and mappings using appropriate data load techniques.">
• Provide research, high-level design, and estimates for data transformation and integration from source applications to end-user analytics solutions.">
• Analyze and resolve problems and provide technical assistance as necessary. Partner with the analytics team to evaluate, design, develop, and deploy analytics reports and dashboards according to functional specifications while maintaining data integrity and quality.">
• Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement analytics solutions.">
• Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract, and transform into reporting and analytics.">
• Define and document the use of analytics through user experience/use cases, prototypes, testing, and deployment of analytics solutions.">
• Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate analytics reports and suggest improvements.">
• Train business end-users, IT analysts, and developers.">

Required Skills and Qualifications:

• ">
• Bachelor's degree in Computer Science or similar field or equivalent work experience.">
• 3+ years of experience on data warehousing, data engineering, or data integration projects.">
• Expert with data warehousing concepts, strategies, and tools.">
• Strong SQL background.">
• Strong knowledge of relational databases like SQL Server, PostgreSQL, MySQL.">
• Strong experience in GCP & Google BigQuery, Cloud SQL, Composer (Airflow), Dataflow, Dataproc, Cloud Function, and GCS.">
• Good to have knowledge on SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).">
• Knowledge of AWS and Azure Cloud is a plus.">
• Experience in Informatica Power exchange for Mainframe, Salesforce, and other new-age data sources.">
• Experience in integration using APIs, XML, JSONs etc.">
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework, data-warehousing, and Data Lakes.">
• Good understanding of SDLC, Agile, and Scrum processes.">
• Strong problem-solving, multi-tasking, and organizational skills.">
• Highly proficient in working with large volumes of business data and strong understanding of database design and implementation.">
• Good written and verbal communication skills.">
• Demonstrated experience of leading a team spread across multiple locations.">

Desirable Skills:

• ">
• SQL Server Reporting Services (SSRS)">
• SQL Server Integration Services (SSIS)">
• AWS and Azure Cloud">
• Informatica Power exchange">