Implementdata structures, workflows, and integrations between enterprise platforms toensure the accurate and timely execution of business processes
Work witharchitect and client leads, technology teams to understand requirements tocreate data pipelines
Develop andmaintain scalable data pipelines and build new API integrations to supportincreasing data volume and complexity
Help withsource data analysis and develop data mappings
Manage andimprove the performance of database queries and solutions
Create and maintaindata warehouse, databases, tables, SQL queries, and ingestion pipelines topower reports (Tableau), dashboards, predictive models, and downstream analysis
Write complexand efficient queries to transform raw data sources into easily accessiblemodels for our teams and reporting platforms
Work withanalytics, data science, and wider engineering teams to help with automatingdata analysis and visualization needs, advise on transformation processes topopulate data models, and explore ways to design and develop datainfrastructure
Strongexperience in data curation / aggregation / preparation using Azure Data lake,Azure Data Factory, DBT and distilling data into meaningful insights
Guidejunior team members with technical direction, client liaison, task allocationand status reporting
Should have experience in SQL, DWH, Azure, ADL, ADF,Snowflake, ETL tools such as SSIS or DataStage
Desired Skills
Big Data using Hive, Impala, Spark will be a plus
Job Classification
Industry: IT Services & Consulting Functional Area / Department: Engineering - Software & QA, Role Category: DBA / Data warehousing Role: Database Architect / Designer Employement Type: Full time