SQLPower BI developer
Raleigh, WV - USA
Job Summary
My name is Himanshu and I serve as the Recruitment Manager at Nexiva INC. I am reaching out to share an excellent career opportunity for the role of SQL/Power BI Developer with our esteemed client. If you are interested then please share your updated resume at
Job Description
Position : SQL/Power BI Developer
Location : Raleigh NC Onsite
Duration : long term contract
Skill Sets and experience includes:
- Experience with Database Management Systems (DBMS) such as Microsoft SQL Server Oracle MySQL or PostgreSQL - including proficiency in writing SQL queries and stored procedures.
- Must possess at least 3 to 5 years of experience working with any BI tools and BI systems with familiarity in data science business intelligence and data analytics.
- Should have knowledge and experience on the PowerBI Security and the approaches to be used when exposing dashboards to public.
- Strong understanding of database design principles data modeling and normalization.
- Knowledge of ETL processes and Business Intelligence (BI) tools.
- Familiarity with programming languages like Python Java or C# for application integration is a plus.
- Should have experience in data integration connecting to and importing data from various sources including data lakes cloud platforms and Excel files.
- Excellent communication skills are necessary to work with stakeholders collect requirements and effectively present results.
- Knowledge of implementing and maintaining data security and governance policies within Power BI is essential.
- Experience working with On-premises Data Gateway architectures managing large volumes of data from AWS Data Lake or other cloud environments is required.
- Should have experience with ODBC connectors
- Ability to transform complex data into a range of visuals such as graphs charts and maps
Job responsibilities include (but not limited to):
- - Work with business stakeholders to understand their requirements and gather needs for the reporting solution.
- - Analyze and define business requirements related to business intelligence.
- - Design and create data models to query raw or processed data from the AWS data lake for insightful analysis.
- - Develop multiple Power BI reports based on business needs and specifications.
- - Implement processes to maintain data accuracy consistency security and regulatory compliance.
- - Use Power BI to build interactive and visually appealing dashboards and reports.
- - Determine key performance indicators that align with relevant objectives.
- - Examine historical and current data to aid better decision-making.
- - Monitor and improve Power BI reports and dashboards for better performance scalability and user experience.
- - Write and execute DAX queries and functions within Power BI.
- - Participate in standup meetings and share daily progress updates.
- - Create all required technical documentation.
- - Demonstrate dashboards and reports during technical presentations.
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
| Experience with Power BI familiarity in data science business intelligence data analytics | Required | 5 |
|
| Experience in creating detailed dashboards and writing DAX (Data Analysis Expressions) formulas | Required | 5 |
|
| Experience with RDBMS such as Oracle or MS SQL Server writing SQL queries stored procedures | Required | 5 |
|
| Ability to transform complex data into a range of visuals such as graphs charts and maps | Required | 5 |
|
| Experience working with On-premises Data Gateway architectures managing large volumes of data from AWS Data Lake or other cloud environments | Required | 3 |
|
| Implementing and maintaining data security and governance policies within Power BI | Required | 3 |
|
| Experience in data integration connecting to and importing data from various sources including data lakes cloud platforms and Excel file | Required | 3 |
|
| Experience with ODBC connectors | Required | 5 |
|
| Excellent communication skills | Required | 5 |
|