What are the responsibilities and job description for the SQL/Power BI Developer position at Refulgent Technologies Inc.?
Job: SQL/Power BI Developer
Location: Raleigh, NC ( Hybrid)
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.