Job Title: Data Engineer - Large Scale Digital Transformation We are looking for an experienced data engineer to join our team and lead the design and implementation of large-scale digital transformation projects. The ideal candidate will have a solid understanding of data modeling concepts, including dimensional modeling and star/snowflake schema design. About the Role This is a remote role that requires effective communication skills and the ability to collaborate with cross-functional teams. - Work hands-on with clients to understand complex business challenges and architect data solutions that create real business value. - Translate business and technical requirements into system designs and implement scalable data pipelines and platforms. - Design, develop, and deliver end-to-end data solutions, including data ingestion, transformation, storage, and access layers. - Leverage expertise in cloud-based data architectures to build and manage modern data platforms. - Optimize and automate data platform operations and monitor system performance post-deployment. - Conduct feasibility assessments and support estimation of timelines and resources for project planning. Requirements The successful candidate will have: - Proven experience designing and implementing data pipelines in enterprise environments using Python for data transformation. - Proficiency with AWS dataservices: S3, Glue, Redshift, Kinesis, EMR, Athena, Lambda among others. - Experience with both structured and unstructured data, including columnar (BigQuery, Redshift, Vertica), NoSQL (Cosmos DB, DynamoDB), and relational databases (SQL Server, Oracle, MySQL). - Familiarity with ETL/ELT tools and frameworks such as PySpark, Databricks and Spark Streaming. - Solid understanding of data modeling concepts, including dimensional modeling and star/snowflake schema design. - Comfortable working in code-driven environments and using tools for version control and continuous integration (e.g., Git, Jenkins). Preferred Skills The following skills are highly desirable: - Experience in real-time streaming data integrations. - Background in performance tuning and optimization of data queries and processes. - Familiarity with DevOps practices in data engineering workflows. This role offers the opportunity to work on challenging projects and contribute to the growth and success of our organization.