Internship Python Sql Developer Jobs in Raleigh, NC

client-ITD is looking to hire a SQL/power BI developer with 3-5 years of development experience. Must be available to work on-site for 3 days a week.
client-ITD is looking to hire a SQL/Power BI developer with 3 to 5 years of development experience. This role involves close collaboration with the data modernization teams at ITD and DPH to design, implement, and manage power BI dashboards and reports that align with their technical requirements and business objectives.
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
SkillRequired /DesiredAmountof ExperienceExperience with Power BI, familiarity in data science, business intelligence, data analyticsRequired5YearsExperience in creating detailed dashboards and writing DAX (Data Analysis Expressions) formulas Required5YearsExperience with RDBMS such as Oracle or MS SQL Server, writing SQL queries, stored proceduresRequired5YearsAbility to transform complex data into a range of visuals such as graphs, charts, and maps Required5YearsExperience working with On-premises Data Gateway architectures managing large volumes of data from AWS Data Lake or other cloud environments Required3YearsImplementing and maintaining data security and governance policies within Power BIRequired3YearsExperience in data integration, connecting to and importing data from various sources including data lakes, cloud platforms, and Excel fileRequired3YearsExperience with ODBC connectorsRequired5YearsExcellent communication skillsRequired5Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2All work must be completed on site at the client's discretion. Do you accept this requirement? Question3Please list candidate's email address HERE that will be used when submitting E-RTR. Question4Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment. Question5Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement? Question6Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement? Question7Candidates submitted above a rate of $$ per hour may not be considered. Do you accept this requirement? Question8Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement? Question9Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate's VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm?