Job Scope:
Design, develop, test, deploy and support cloud-based Data Warehouse, Data models and Enterprise wide analytics. Build trusted single source of truth that can further be used to develop, maintain and administer data marts, OLAP cubes, visualizations and other data analysis and presentation tools. Upgrades legacy analytic applications for compatibility with the corporate data warehouse architecture and standards. Ensures BI applications comply with applicable corporate, statutory, and quality standards. Builds and maintains ad-hoc intranet tools and website needed to support, secure and scalable data engineering solutions and pipelines.
Works directly with enterprise business analysts and the user community to elicit requirements and deliver actionable information to corporate decision makers.
Strategize, Own and Lead Enterprise-wide data projects and work collaboratively with Management Leaders and Stakeholders to drive towards operational excellence. Develop roadmaps and implement best practices for a smooth Agile environment in conjunction with fair DevOps practices for faster and efficient turnaround.
Job Qualifications:
8+ years of experience in data modeling, data warehouse design, development, maintenance, and support using Microsoft Business Intelligence technology stack (2008/2012/2014/2016) including Integration Services, Reporting Services, Analysis Services, SharePoint and SQL Server. 5+ years of experience in analyzing data and create data visualizations that can drive strategic decisions. Experience in data visualization tools like Tableau, MicroStrategy or PowerBI is preferred. Experience in cloud-based ELT/ETL tools like Matillion, Data Factory is preferred. Experience with NoSQL Databases like MongoDB, Cassandra, CouchDB or Traditional Cloud Databases like Azure SQL Server or columnar-stored complete relational database like Snowflake is preferred. Automate, Optimize and maintain ETL flows in a repeatable, scalable manner. Ability to handle and respond to ad-hoc data support/analytical requests. Experience in building Self-Serve ad-hoc environment. Experience with cloud Data technologies like AWS (Redshift, S3, Glue and Kinesis) or similar Google Cloud or Microsoft Azure and familiarity with any scripting language like Python/R is a plus. Experience in Data Science toolkits using Python or R is a plus. Experience in handling Big Data/Stream data in distributed environment is a plus. Data Modelling experience using ER Studio is a plus. Experience in Retail business intelligence is preferred. Essential Functions:
Work with enterprise wide business users from Finance, Marketing, Sales, Merchandising, Supply Chain, Service, IT and other domains along with corresponding stakeholders to understand business processes, gather requirements, prepare technical specification documents and translate them into analytical solutions. Contribute to the design, development, maintenance, and support of our Enterprise Data Warehouse on cloud platform. Design and maintain ETL/ELT and the supporting data objects for our growing BI infrastructure while also contributing to the ad hoc data report requests to support the business needs. Participate in testing of new BI tools and technology to advance initiatives impacting customer decisions Provide support as required, to ensure the availability and optimized performance of developed applications and visualizations for corporate and field users. Follow established best practices by the team to ensure quality and timely delivery. Monitors and supports daily BI production activities, schedules and alerts. Marginal Functions:
- Promotes best practices, data quality standards, and user's BI skills throughout the organization.
- Maintains acceptable documentation for work performed
- Follows Leslie's policies for attendance, security, and professionalism
- Takes ownership and pride in the quality of our work
- Focuses on excellence in serving the needs of our users and business
- Contributes to team and company morale with a positive attitude
- Executes other related tasks as directed by IT management
