ETL Engineer (MS SQL Server)

Snapx
St Louis, Missouri, USA
Full-time

Job Description Summary Overview

Mastercard Business Intelligence and API Enablement Program supports various analytics and reporting platform that includes Domo, Power BI, Tableau, SSRS and WebFOCUS.

The ecosystem also includes Microsoft BI stack involving SSAS & SSIS and Alteryx ETL tool. These tools are used to deliver insights and reporting capabilities to wide group of users across the organization in order to support business decisioning and growth drivers of various products / solutions.

Ideal candidates will answer yes to all of the following questions :

  • Have you worked in an agile development team?
  • Have you worked in Data Warehouse and / or Business Intelligence projects in different domains?
  • Are you proficient in any BI reporting tool, ETL too or Analytics model tool (example SSAS)
  • Are you passionate about building technology to deliver quality solutions providing superior customer experience?
  • Do you thrive in a fast-paced environment and have the ability to learn new skills and applications quickly?

Role

  • Design and develop high quality, securable software solutions based on technical requirements specifications and design artefacts within expected time and budget
  • Collaborate on cross-functional agile teams that include Front-end Developers, Report / BI Developers and Product Owners to implement full scale enterprise BI solutions
  • Work closely with Product Owners to develop beautiful, usable UIs and creative visualizations as an Individual contributor
  • Stay abreast of Analytics technology trends and industry best practices to hone and maintain your talent
  • Participate in architectural discussions , iteration planning, and feature sizing meetings
  • Develop reports and data models using various BI tools (Tableau / Domo / Power BI / SSRS)
  • Provide support during System and User Acceptance Testing
  • Adhere to Agile processes and participate actively in agile ceremonies

All About You

Ideal candidates will have experience developing and supporting BI reporting solutions, ETL solutions and other analytics solutions in a Data Warehouse ecosystem.

Specific experience should optimally include :

  • Experience in any reporting tool - (Tableau / Domo / Power BI / SSRS)
  • Experience in BI dimensional modelling using tools like SSAS , Power BI.
  • In-depth understanding of designing and developing Microsoft SSAS tabular cubes - facts, dimensions, partitions, cube refresh strategy, automated cube data load
  • Experience in writing DAX and MDX queries against SSAS cubes
  • Strong SQL programming skills
  • Experience in one or more ETL tools - SSIS / Alteryx / Informatica / any open source tool
  • Understanding of Exadata / Oracle / Netezza / SQL server databases
  • Report and dashboard development in Data Warehouse environment
  • In-depth understanding of designing and developing Business Intelligence solutions for different personas (analysts, sales, marketing, research etc.)
  • Exposure and understanding of complete SDLC
  • Experience in AGILE methodology
  • Experience in working with global teams
  • Exposure to big data platforms like Hadoop will be added advantage
  • Exposure to Cloud based BI solutions (e.g. DataBricks or Snowfake) in AWS or Azure
  • Exposure to languages like R, Python and similar technology is added advantage
  • 30+ days ago
Related jobs
Snapx
St. Louis, Missouri

In-depth understanding of designing and developing Microsoft SSAS tabular cubes - facts, dimensions, partitions, cube refresh strategy, automated cube data load</li> <li>Experience in writing DAX and MDX queries against SSAS cubes</li> <li>Strong SQL programming skills</li...

Promoted
TechnoSmarts, Inc.
St. Louis, Missouri

Proficiency in database technologies such as SQL Server. Proficiency in SQL and experience developing complex SQL queries. Design, develop, and maintain complex database systems to support various applications and services. Create and maintain comprehensive database documentation, including data dic...

Promoted
VirtualVocations
Florissant, Missouri

A company is looking for a Lead Power BI Developer. ...

Promoted
DataFactZ, LLC
St. Louis, Missouri

Deep knowledge of data extraction, transformation & loading (ETL) methods using Teradata. Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code. ...

Promoted
Innovative Data Solutions LLC
St. Louis, Missouri

Innovative Data Solutions (IDS) is a small business specializing in engineering and supporting mission critical IT infrastructure for the US Government Intelligence, Defense and Homeland Security communities. We are seeking an experienced Linux Engineer to support an IC customer/contract in&nbs...

Promoted
Swank Motion Pictures
St. Louis, Missouri

Mentor developers and product owners on OLTP database patterns. Responsible for backup and recovery of databases, database migrations, SQL Server patching, upgrades and other operational tasks. Continue to develop your skills in database optimization, reporting, data analysis, and other database dut...

Promoted
neteffects
St. Louis, Missouri

Experience data modeling for large scale databases, either relational or NoSQL. Bioinformatics experience, especially large scale storage and data mining of variant data, variant annotation, and genotype to phenotype correlation. At least 7 years experience in software engineering. Proven experience...

Promoted
Deloitte
St. Louis, Missouri

Operations & Technology Transformation Senior Consultant, Guidewire Data Migration - ETL Developer. ETL experience with Informatica and/or Microsoft SSIS. ...

Promoted
Amerit Consulting
St. Louis, Missouri
Remote

SQL DBA / Data Warehouse Analyst. Must be able to work with multiple RDBMS environments such as Oracle, SQL Server, MySQL, and so on. Provisions users in Microsoft SQL Server. Creates new databases in SQL Server. ...

Promoted
Infosys
St. Louis, Missouri

This position will interface with key stakeholders and apply your technical proficiency across different stages including leading multiple infrastructure planning and implementation including instance strategy, technical platform selection, architecture design, backup and recovery strategy ;install,...