JOBS
SQL BI DEVELOPER
SQL BI DEVELOPER
Job Description:
Gather requirements from business stakeholders and translate them into technical specifications.
Prepare a solution and design review session with all the stakeholder explaining the details on how the changes will be done and explain the affected End user due to the change.
Develop Dashboards with rich visualizations using Tableau/Microsoft Power BI tool with wide variety of controls and converting big raw data into business useful insights\metrics.
Provide road map and leveraging cloud platforms for Advanced Analytics (BigData, Machine Learning, Azure data lake store, GCP, PySpark etc).
Create visualizations with the knowledge acquired through academic coursework in data mining, analyzing and visualizing data, cloud computing, application security, and blockchain.
Implement Azure data factories and child resources including datasets, linked services, triggers, and integration runtimes.
Handle bigdata processing through Python (PySpark), Spark SQL and DataFrames.
Manage Snowflake, Azure Data Factory and Data Lake Analytics to integrate with other on-premises and Azure Services.
Design & develop ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.
Design & optimization, health check, audits, compliance, security, configurations, maintenance, optimization, performance tuning, scalability, integrations, backups/restore.
Implement SSAS Multidimensional/Tabular Cubes as the reporting layer and Use both MDX/DAX scripting to access data from Multidimensional/Tabular Models.
Responsible for building the continuous integration process using Hudson Jenkins and reporting the failures.
Develop test cases and implement Referential Integrity rules and regulations through constraints, triggers, views and partitioned views.
Develop and maintain the ADF, DTSX data pipelines for end to end reporting.
Write custom scripts using PowerShell and C# to extract data from Third Party REST APIs, Websites, Device Compliance and Usage Data and Active Directory.
Provide 24×7 on-call Support for critical production Databases.
Provide analytical support including analysis and graphical representation of data, assisting with MBR & QBR reporting for executives with strong analytics and comments.
Work on R application showcasing machine learning for improving the forecast of business and strong experience in RStudio.
Using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer.
Use GIT STASH/TFS as version control tools.
Review and update the servers using version control tool to maintain all versions of the codes in-order to maintain history, analyze whenever needed and revert or deploy a specific version whenever required.
Master’s degree in Computer Science, Information Technology, or a related field is required.
Work location: Irving, TX.
Send Resume to HR Dept., PhiDimensions, Inc., 1303 W Walnut Hill Lane, Suite 103, Irving, TX 75038.
Should the candidate accept employment with PhiDimensions, Inc., the referring employee will be eligible to receive an award of $1,000.00 for the successful referral.
Read MoreSend Resume to HR Dept., PhiDimensions, Inc., 1303 W Walnut Hill Lane, Suite 103, Irving, TX 75038.
Work location: Irving, TX.