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
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...

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
CACI
St. Louis, Missouri

Serve as a Database Administrator supporting the client’s Corporate Business Information Systems. Provides Oracle database support for Oracle RDBMS, Oracle Enterprise Manager Cloud Control, and PeopleSoft applications. The successful DBA will also administer MSSQL, PostgreSQL, MySQL, and NoSQL datab...

Promoted
Buildertrend
St. Louis, Missouri
Remote

The Database Administrator will keep our database up and running smoothly 24/7. Proven working experience as a SQL Server Database administrator, preferably with high volume enterprise applications. Build, manage, and performance tune SQL Server database systems of high performance, availability, an...

Promoted
Vaco
St. Louis, Missouri
Remote

Vaco Technology has an immediate need for a Senior PL/SQL Developer for a permanent remote position with a company basedin St. Min 5-8 yrs PL/SQL development and solid understanding of RDBMS. Must have T/SQL experience as well. ...

Promoted
VirtualVocations
St. Louis, Missouri

Key Responsibilities:Translate high-level business requirements into data model designs, processes, and data assetsMentor technical developers in data architecture practices and assist in the design and implementation of data solutionsArchitect and develop semantic data models, dataflow packages, an...

Promoted
Studio Network Solutions
Maryland Heights, Missouri

In this role you will be building a lot of large servers, helping to test hardware and software that we create, shipping/receiving orders, and other various duties in our lab and assembly area. Building and configuring servers and workstations. Ability to routinely lift, carry, and rack a 3U server....

Promoted
Cartney
St. Louis, Missouri

Data Frames and Resilient Distributed Datasets (RDDs). Big Data or Hadoop tools such as Spark, Hive. ...

Promoted
Beacon Hill
St. Louis, Missouri
Remote

One of our clients in San Deigo, California is looking for an Oracle PL/SQL Developer with the following skills and experience:. PL/SQL, Informatica, SQL, ETL, Performance Tuning. Proficient in developing complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL...

Promoted
Deloitte
St. Louis, Missouri

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