Exusia Hiring for Senior Data Analyst/Modeler – Data Engineering at Chennai Full Time

Department: Sales and Delivery Team – Empower

Industry: Information Technology & Services, Computer Software, Management Consulting

Location: India

Experience Range: 5 – 12 years

Basic Qualification: Master/Bachelor of Engineering or Equivalent

Travel Requirements: Not required

Website: www.exusia.com

What’s the Role?

Full-time job to work with Exusia’s global (Americas, Europe, Africa, Asia) clients to deliver on bleeding-edge data-driven solutions by performing business analysis, data analysis, data modeling, data mapping and translating business and functional requirements into technical specifications by working with Client Product Owners & Business SMEs, Exusia Solution Architects and Senior Application Designers/Developers.

This role will require critical thinking and analysis skills to support client delivery on strategic enterprise data and analytics projects. This will include working directly with the client business teams and Exusia technical teams on critical tasks including data requirements, data analysis, data modeling as well as high-level designs, technical designs, technical source-to-target mapping, data analysis reports as well as Development/QA/UAT support.

Experience with ETL, data processing, Business Intelligence Reports and Dashboards is required. Manage software product development lifecycle of one or more core application development streams for one or more business units is a big plus. Experience working with on-shore/off-shore delivery model is a big plus.

Responsibilities

• Document, discuss and resolved business, data and analytics/reporting new project requirements and issues within the team, across functional teams, and with business stakeholders.
• Gather and analyze business requirements to create technical specifications like source-to-target mapping, data modeling diagrams, etc.
• Mining, filtering, and cleaning data in preparation of but limited to data analysis. Interpret data, analyze results, prepare data analysis reports.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Adept at SQL queries, Report creation/writing and presenting findings.
• Ability to perform Data Modeling (Dimensional, Star, Normalized, etc) a strong plus
• Own and Lead Data Analysis throughout the phases of the software development lifecycle (SDLC)
• Understanding and experience to setup Metadata management like Data Dictionary, Data Glossary, Data Lineage for Data Governance aspects of project.
• Able to write pseudo-code, algorithms for requirements.
• Present written and verbal data analysis findings, to both the project team and business stakeholders.
• Manage changing priorities and work on multiple projects concurrently.
• Self-motivated and proactive in a fast-paced environment.
• Work with business stakeholders to gather requirements and complete artifacts, including solution design, detailed technical design and data/API modeling.
• Support all phases of the software development lifecycle (SDLC).

REQUIREMENTS

• Criteria for the Role!
• Have a minimum of 5 years of experience working as a Data Analyst and Data Modeler performing Data Profiling using SQL
• Experience with one or more Cloud platforms – Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform GCP is a big plus
• Data experience working with complex large datasets / big data performing data analysis, data profiling, data mapping and data modeling is required
• Source-to-target mapping experience (including complex business rules) while transforming business/functional requirements to technical specifications.
• Data Modeling experience including Dimensional (Star Schema) and Relational Normalized modeling including 3NF
• Knowledge of data processing / ETL architecture using one or more leading technologies such as Ab Initio / SAS / SSIS / Informatica / R / Java / Scala / Apache Spark / Databricks is required
• Experience with BI/Reporting such as Cognos / BOBJ / MicroStrategy / SSRS and Data Visualizations Tools like Power BI, Tableau, Qlick, is a plus
• Understanding and experience of ETL, Data Warehousing, Data Quality and Data Governance projects
• Hands-on with navigating in both a relational and non-relational SQL skillset is required.
• Experience and knowledge of one or more domains – Banking, Healthcare, Supply Chain/Inventory Management, Consumer Goods, Telecom, Hospitality, Energy
• Excellent communication, creative problem solver, flexible, proactive, attitude to learn newer tools/technologies and have demonstrated experience in effectively working within a fast paced, ever changing environment.
• Demonstrated experience in effectively managing multiple projects and activities in a timely, organized manner
• Demonstrated experience in organizing and prioritizing work, meeting deadlines and working independently as well as collaboratively with others.
• Education Qualification – Master of Science (preferably in Computer and Information Sciences or Business Information Technology) or an Engineering degree in the above areas.
• Experience working in an agile software delivery model is required.
• Validate requirements with stakeholders and the project team, provide suggestions and recommendations based on previous experience and industry best practices.

Job Types: Full-time, Regular / Permanent

Pay: ₹1,255,575.00 – ₹2,840,135.00 per year

Benefits:

• Flexible schedule
• Health insurance
• Life insurance
• Paid sick time
• Paid time off
• Provident Fund
• Work from home

Schedule:

• Day shift
• Monday to Friday

Supplemental pay types:

• Joining bonus
• Performance bonus
• Quarterly bonus
• Shift allowance
• Yearly bonus

COVID-19 considerations:
All employees are working from home.

Experience:

• total work: 4 years (Preferred)
• SQL: 4 years (Preferred)
• Data modeling: 4 years (Preferred)
• ETL: 3 years (Preferred)
• Source to Target Mapping: 3 years (Preferred)
• Data Analysis/Profiling: 3 years (Preferred)