Job Description
Job Title: Sr Data Engineer
Location: Remote
Position Type: Full-time (Permanent)
Primary Responsibilities:
- Partner with internal product stakeholders to help define requirements and outcomes for data-focused initiatives
- Decompose large problems and execute smaller, manageable bodies of work to demonstrate continuous architecture delivery
- 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, Power BI)
- 5+ years leveraging AWS and its associated array of offerings (Glue, Redshift, Athena, S3, Spectrum, PySpark)
- Deep expertise in Python and C#
- Collaboration with a development team with established source control (GIT).
- Data modeling (conceptual, logical and physical model design, Operation Data Stores, Enterprise Data Warehouses and Data Marts).
- 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)