SQL/Power BI Developer
*Local to Raleigh, NC only please
*This is a hybrid position with 3 days/week onsite
*We are not considering Corp-to-Corp (C2C) arrangements for this position
Description
- The client 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 the client to design implement and manage power BI dashboards and reports that align with their technical requirements and business objectives.
Skills/Knowledge/Experience:
- 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
Responsibilities:
- 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 Skills/Knowledge/Experience:
- Experience with Power BI, familiarity in data science, business intelligence, data analytics, Required 5 Years
- Experience in creating detailed dashboards and writing DAX (Data Analysis Expressions) formulas, Required 5 Years
- Experience with RDBMS such as Oracle or MS SQL Server, writing SQL queries, stored procedures, Required 5 Years
- Ability to transform complex data into a range of visuals such as graphs, charts, and maps, Required 5 Years
- Experience working with On-premises Data Gateway architectures managing large volumes of data from AWS Data Lake or other cloud environments, Required 3 Years
- Implementing and maintaining data security and governance policies within Power BI, Required 3 Years
- Experience in data integration, connecting to and importing data from various sources including data lakes, cloud platforms, and Excel file, Required 3 Years
- Experience with ODBC connectors, Required 5 Years
- Excellent communication skills, Required 5 Years
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!
#AC