You are a strategic thinker passionate about driving solutions in Analytics. You have found the right team.
As a Analytics Solutions Associate in our Finance team, you will spend each day defining, refining and delivering set goals for our firm.
Job Responsibilities
• Design and implement comprehensive and efficient data mart schemas that consolidate key data categories from various source systems, tailored to the needs of the Marketing Finance & Business Management functions.
• Collaborate with Business stakeholders to understand requirement and accordingly map source & calculation logic
• Collaborate with cross-functional teams, including data engineers, data analysts, and technical specialists, to gather and analyze business requirements.
• Develop, implement, and optimize data workflows, Extract Transform Load (ETL) processes, and data pipelines using Databricks.
• Utilizing Databricks and ThoughtSpot tools, create a robust and efficient reporting environment for PXT Finance data analytics and reporting.
• Work closely with your business domain Product teams and business stakeholders to: 1) design and develop insightful reporting and analytics solutions that drive informed decision-making; 2) apply design led thinking to meet their needs, including making data discoverable and accessible for analytical needs.
• Maintain up-to-date documentation on data mart architecture, data models, ETL processes, and data governance policies.
Required qualifications, capabilities and skills
• Overall 6+ years of experience in Data Management, data Engineering, data lineage, data dictionaries, and making data discoverable
• Strong knowledge and experience with data Engineering, data lineage, data dictionaries, and making data discoverable
• Famliarity with data architecture, data warehousing, and data integration, with a focus on the retail banking or financial services industry.
• Expertise in designing and implementing scalable and efficient data mart architectures, including star schema, snowflake schema, and other data modeling techniques.
• Bachelor’s degree in Computer Science, Information System, or related discipline
• Experience with Python, Databricks, Snowflake, or other Cloud Data Warehouse, Data Engineering, Data Modeling, ERWIN
• Proven track record of successfully managing and delivering complex data projects in a fast-paced, dynamic environment.
• ThoughtSpot, Tableau, Alteryx, or Essbase experience