Lead Data Software Engineer

We are seeking a dedicated and experienced **Lead Data Software Engineer** to join our team and contribute to developing advanced technology solutions for Investment operations, including trade processes, accounting, reconciliation, reporting, and related activities.**Responsibilities**- Define technical requirements for data-driven solutions in collaboration with Product Owners, Scrum Masters, and Subject Matter Experts- Ensure seamless capturing, transformation, and delivery of financial data through integration processes- Demonstrate business value and solution outcomes to stakeholders during sprint showcases- Drive iterative product delivery within Agile scrum team environments- Program views, stored procedures, and functions using SQL to address complex data workflows- Develop and manage CI/CD pipelines using tools like BitBucket/GitHub and Bamboo- Incorporate reporting tools such as Power BI or Tableau to elevate business intelligence capabilities- Improve and support data warehousing and Dimensional Modeling methods such as Kimball- Utilize cloud platform technologies, preferably AWS, for efficient data processing and orchestration- Design scalable ETL workflows using Python and relevant libraries like Pandas and NumPy**Requirements**:- Bachelor’s degree in a technical discipline or equivalent professional experience- Minimum 5 years of professional experience as a Data Engineer- Skills in SQL for creating views, stored procedures, and managing data workflows- Background in working with cloud platforms like AWS, including S3, Glue, Athena, and Lambda services- Proficiency in Python for developing ETL workflows and testing with libraries like Pandas/NumPy and unit testing frameworks- Familiarity with business intelligence tools such as Power BI or Tableau- Understanding of CI/CD pipelines implemented through tools like BitBucket/GitHub and Bamboo- Competency in data warehousing, Dimensional Modeling, and Data Extraction Utilities- Background in Agile software development practices, including story sizing, sprint planning, and retrospectives**Nice to have**- Knowledge of financial systems and reporting, particularly in investment accounting or general ledger contexts- Proficiency in integrating large-scale financial investment/ERP systems like SimCorp Dimension or related platforms- Skills in agile development and implementation of data solutions using AWS resources, Snowflake, and orchestration tools- Familiarity with advanced data integration technologies such as SnapLogic, Rest APIs, and pipeline orchestration methods- Expertise in creating interactive dashboards and producing advanced reporting using Power BI**We offer**- Career plan and real growth opportunities- Unlimited access to LinkedIn learning solutions- International Mobility Plan within 25 countries- Constant training, mentoring, online corporate courses, eLearning and more- English classes with a certified teacher- Support for employee’s initiatives (Algorithms club, toastmasters, agile club and more)- Enjoyable working environment (Gaming room, napping area, amenities, events, sport teams and more)- Flexible work schedule and dress code- Collaborate in a multicultural environment and share best practices from around the globe- Hired directly by EPAM & 100% under payroll- Law benefits (IMSS, INFONAVIT, 25% vacation bonus)- Major medical expenses insurance: Life, Major medical expenses with dental & visual coverage (for the employee and direct family members)- 13 % employee savings fund, capped to the law limit- Grocery coupons- 30 days December bonus- Employee Stock Purchase Plan- 12 vacations days plus 4 floating days- Official Mexican holidays, plus 5 extra holidays (Maundry Thursday and Friday, November 2nd, December 24th & 31st)- Monthly non-taxable amount for the electricity and internet billsEPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our customers, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.