Data Analytics Engineer - Pune - Xplor Tech1
- Xplor Tech1 Systems
- 3 - 8 years
- Pune
- 2 months ago
- Email to a friend
- Report this job
Job Description
Overview
As a member of the global data engineering team, reporting to the Data and Analytics Manager, this role has a primary focus on contributing to our enterprise data warehousing and reporting deliverables.
Responsibilities include designing, creating, and maintaining business intelligence assets and reports that drive innovation, client value and business efficiency.
This position will be working across our largest business units and experience with multi-terabyte database systems is required.
Key Responsibilities
The primary tasks, duties, and responsibilities are:
- Maintaining and enhancing reporting and Power BI solutions.
- Producing reporting stored procedures via T-SQL scripting and DAX.
- Data Modelling and Transformation design.
- ELT development for data warehouse ingestion.
- Contribute to cloud migration and ensure system uptime for data warehouse products.
- Participate in Agile work planning, testing, and quality assurance.
Technical Skills
- Experienced level knowledge - Business Intelligence/reporting tools including Microsoft SQL, SRSS, SSIS, SSAS, Power BI, DAX.
- Adept at designing and implementing effective data models and Extract, Transform, Load (ETL) processes slowly changing dimensions for transforming and loading data into the data warehouse.
- Experience incorporating data from varied relational systems (e.g. MySQL, Postgres etc), flat-file, API, and No-SQL sources.
- Understanding of data governance practices, data lineage, and data quality management to ensure accurate, consistent, and reliable data.
- Familiarity with cloud base tooling Snowflake, DBT or Coalesce, Fivetran.
Education/Qualifications
- BA/BS degree in Computer Science, Computer Engineering, or related field, or equivalent practical experience.
- Preferred Qualifications include:
- Expertise in parallel processing warehouses (Snowflake/Redshift),
- high-frequency differential ETL processes,
- and Agile development methodology.
Job Classification
Industry: IT Services & ConsultingFunctional Area: IT Services & Consulting
Role Category: Data Science & Analytics - Other
Role: Data Science & Analytics - Other
Employement Type: Full time
Contact Details:
Company: Xplor Tech1 SystemsLocation(s): Pune
Keyskills: data amazon redshift bi data warehousing business intelligence sql analytics postgresql data modeling dax mysql etl sr snowflake data analytics ssas power bi warehouse data engineering sql server sql scripting agile development methodology t processing ssis etl process
Similar positions
Xplor Tech1 Systems
About companyAt Xplor, we believe that helping people make the most of each day is the most rewarding way to spend ours.We give small and medium-sized businesses cloud-based, intuitive technology solutions that enable them to manage all the hassles of running and growing a business, so business owne...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in
