International System Technologies
Location
Las Vegas, NV | United States
Job description
- Development of logic for KPIs requested by the business leadership.
- Troubleshoot existing and create new ETLs, SSIS packages, SQL stored procedures and jobs.
- Assist in Star and Snowflake modeling, creating dimensional models and ETL processes.
- Write an efficient SQL code for use in data pipelines and data processing.
- Drive data quality processes like data profiling, data cleansing, etc.
- Maintain existing and create new Microsoft Power Apps solutions (including but not limited to Power Apps, Power Automate, Power BI, Flows, etc.) according to business needs.
- 2+ years of experience in building data pipelines and ETL processes is required.
- 2+ years of experience creating visualizations and reports (Power BI, Tableau, MicroStrategy, Google Analytics) is required.
- 2+ years of experience in writing advanced SQL, data mining and working with traditional relational databases (tables, views, window functions, scalar and aggregate functions, primary/foreign keys, indexes DML/DDL statements, joins and unions) and/or distributed systems (Hadoop, Big Query) is required.
- 1+ years of experience with programming/scripting languages such as Python, R or Big Query is required.
- Experience in either Microsoft Power Suite (Power Apps, Power Automate, Power BI, etc.), Microsoft Azure, Google Cloud Platform, or RPA tools is preferred.
- Excellent understanding of data types, data structures and database systems and their specific use cases is required.
Report this job
- Dice Id: 10100005
- Position Id: 8212400
Job tags
Salary