DWH Architect

Mid / Senior

Remote

As a Data Architect, focused on modern DW, your role will involve a combination of hands-on contribution, customer engagement and technical team management. You will architect and build end-to-end modern DW solutions, which will include:

Understanding business requirements and translate them to data products
Driving the strategy for better data quality for customer needs across business lines
Making tech stack decisions
Collaborating with business consultants, engineers, and data scientists to build data solutions
Explore new technologies for creative business & technical problem solving

More specifically from a tech perspective, you will design & build:

DWs on RDBMS/MPP DWs/Cloud-based DWs
ELT / ETL pipelines, ingesting batch and streaming data,
Dimensional and data vault models
Optimize new and current database systems
Build summary layers to provision data for descriptive analytics

Required Experience, Skills & Competencies:

Hands-on experience with:

SQL
ETL tools (e.g. Informatica, Talend, Pentaho, SSIS)
RDBMS (e.g. Oracle, DB2, SQL Server)
DW on cloud (e.g. Snowflake, Redshift, Azure Synapse)
Cloud environments (e.g. AWS, Azure, GCP)
Unix shell scripting
Scheduling tools (e.g. Control-M, Autosys, Cron)

Experience with:

Data architecture layers, Data Modeling, Scheduling & automation, DBA, etc.
ETL/ELT pipelines, data ingestion frameworks, working across heterogenous data stores
Data Governance – Data Lineage, Data Quality, MDM, Metadata Management, Audit trails, etc.
Leading technical teams interacting with a variety of business audience

10+ years of experience

{"group":"Organization","title":"DWH Architect","zohoId":"557706000009873036","endDate":"2022-06-30T00:00:00.000Z","jobType":"Full Time","job_url":"195-tiger-analytics-dwh-architect","agencyId":1,"location":[{"lat":13.0833,"lon":80.2833,"city":"Chennai","text":"Chennai, Tamil Nadu 600096, India","state":"Tamil Nadu","country":"","zipCode":"600096","is_state":false,"is_country":false,"state_code":"TN","countryCode":"","isLocationSet":true,"loc_h3_hex_res4":"84618c5ffffffff","isLocationResolved":false,"is_address_available_from_parser":true}],"maxSalary":null,"minSalary":null,"startDate":"2022-05-05T00:00:00.000Z","onBehalfOf":"59","description":"As a Data Architect, focused on modern DW, your role will involve a combination of hands-on contribution, customer engagement and technical team management. You will architect and build end-to-end modern DW solutions, which will include:  <ul><li class=\"align-justify\" style=\"text-align: justify\">Understanding business requirements and translate them to data products </li><li class=\"align-justify\" style=\"text-align: justify\">Driving the strategy for better data quality for customer needs across business lines </li><li class=\"align-justify\" style=\"text-align: justify\">Making tech stack decisions  </li><li class=\"align-justify\" style=\"text-align: justify\">Collaborating with business consultants, engineers, and data scientists to build data solutions </li><li class=\"align-justify\" style=\"text-align: justify\">Explore new technologies for creative business & technical problem solving </li></ul>More specifically from a tech perspective, you will design & build: <ul><li class=\"align-justify\" style=\"text-align: justify\">DWs on RDBMS/MPP DWs/Cloud-based DWs </li><li class=\"align-justify\" style=\"text-align: justify\">ELT / ETL pipelines, ingesting batch and streaming data,  </li><li class=\"align-justify\" style=\"text-align: justify\">Dimensional and data vault models </li><li class=\"align-justify\" style=\"text-align: justify\">Optimize new and current database systems </li><li class=\"align-justify\" style=\"text-align: justify\">Build summary layers to provision data for descriptive analytics </li></ul>Required Experience, Skills & Competencies:  <ul><li class=\"align-justify\" style=\"text-align: justify\">Hands-on experience with: </li><ul><li class=\"align-justify\" style=\"text-align: justify\">SQL </li><li class=\"align-justify\" style=\"text-align: justify\">ETL tools (e.g. Informatica, Talend, Pentaho, SSIS) </li><li class=\"align-justify\" style=\"text-align: justify\">RDBMS (e.g. Oracle, DB2, SQL Server) </li><li class=\"align-justify\" style=\"text-align: justify\">DW on cloud (e.g. Snowflake, Redshift, Azure Synapse) </li><li class=\"align-justify\" style=\"text-align: justify\">Cloud environments (e.g. AWS, Azure, GCP) </li><li class=\"align-justify\" style=\"text-align: justify\">Unix shell scripting </li><li class=\"align-justify\" style=\"text-align: justify\">Scheduling tools (e.g. Control-M, Autosys, Cron) </li></ul><li class=\"align-justify\" style=\"text-align: justify\">Experience with: </li><ul><li class=\"align-justify\" style=\"text-align: justify\">Data architecture layers, Data Modeling, Scheduling & automation, DBA, etc. </li><li class=\"align-justify\" style=\"text-align: justify\">ETL/ELT pipelines, data ingestion frameworks, working across heterogenous data stores </li><li class=\"align-justify\" style=\"text-align: justify\">Data Governance – Data Lineage, Data Quality, MDM, Metadata Management, Audit trails, etc. </li><li class=\"align-justify\" style=\"text-align: justify\">Leading technical teams interacting with a variety of business audience </li></ul><li class=\"align-justify\" style=\"text-align: justify\">10+ years of experience  </li></ul><div class=\"align-justify\" style=\"text-align: justify\"> </div> ","isHybridJob":false,"isRemoteJob":true,"noOfOpenings":1,"maxExperience":"12","minExperience":"10","isOnPremiseJob":false,"onBehalfOfName":"Tiger Analytics","otherlocations":[],"zohoCurrencyIn":"USD","experienceLevel":"Mid / Senior","zohoNoOfOpenings":{"noOfOpenings":1,"fulfillmentIds":["557706000009873036-1"]},"otherJobReference":null,"sharpenedJobTitle":"DWH Architect","job_category_group":3,"portalLocationDisplay":"Chennai TN","expertise_coreskill_or_product":["Other"],"job_id":"2454"}

DWH Architect

Thank you for your application!