Primary Responsibilities:

• Architect and manage scalable data pipelines across on-premise and cloud data repositories
• Create data flow diagrams, and document source to target mapping
• Extract business requirements and translate them into actionable tasks
• Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations etc.
• Create user-facing dashboards that provide key insights at a glance for its specific audience
• Recognize and adopt best practices and cost-effective solutions in developing analytical insights on-prem and in the cloud
• Provide guidance and mentor junior team members
• Keep current with Business Intelligence data trends and technological innovations
• Execute on POC’s with new technologies, drive innovation, and new ideas

Job Requirements:

• 7 years leveraging Microsoft and its associated array of offerings (SQL, PL/SQL, SSIS, SSRS, SSAS, PowerBI)
• 5 years leveraging AWS and its associated array of offerings (Glue, Redshift, Athena, S3, Spectrum, PySpark)
• Deep expertise in Python and C#
• Collaboration with development teams with established source control (git).
• Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
• Strong experience with business intelligence and data warehousing design principles and industry best practices including multi-dimensional modelling (star schemas, snowflakes, de-normalized models, handling “slow-changing” dimensions)
• Ability to work with stakeholders and changing priorities
• Ability to learn and apply new technologies to business problems