ETL Engineer (MS SQL Server)
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
ETL Engineer (MS SQL Server)
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...
Senior Engineer - Data Scientist
Develop data transformation processes to integrate data from various sources and prepare the data for analysis. Knowledgeable about data engineering concepts and methodologies. Ensure data processing meets business requirements and industry practices for data integrity, latency, and scalability. Bac...
SQL Server DBA
A company is looking for a SQL Server Database Administrator. ...
Database Developer - Hybrid in St. Louis, MO
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...
Sr. Healthcare Data Engineer (100% remote work)
Designs, develops, and deploys ETL programs to facilitate the receipt of data from various data sources and the loading of data into destination tables within the overall data architecture framework. Utilizes advanced understanding of healthcare data models to identify data sources and maps data to ...
SQL Database Administrator
SQL DBA - with the view to move into a Database Security focused role. Collaborate with various teams to identify database security requirements. Monitor database systems for unauthorized access, unusual activities, or potential security breaches. Conduct regular audits to verify the accuracy and va...
BI Developer w/ ALTERYX & ETL--100% REMOTE
Individuals with Disabilities and Protected Veterans are encouraged to apply. ...
Jr Database Developer
The Database Developer is responsible for developing and supporting SQL Server database solutions within both the production and development environments. Perform database/code migrations and track the requests within internal SharePoint workflows. Intermediate level of self-sufficiency and initiati...
Senior Database Administrator (Work From Home)
Buildertrend is looking for a professional Senior Database Administrator to keep our database up and running smoothly 24/7. Senior Database Administrator. Proven working experience as a SQL Server Database administrator, preferably with high volume enterprise applications. Build, manage, and perform...
Database Administrator
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,...