Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Design, code, test, debug, and document. Provide hands-on design, development, and configuration of applications, visualizations, dashboards, and reports. Collaborate with business stakeholder teams to gather requirements for new dataset availability for self-service reporting and data analysis. Leadership in the areas of advanced data techniques, including data modeling, data access, data integration, data discovery, database design/implementation, and the use of statistical methods. Establishes plans, schedules, and processes to manage on-time delivery of projects and produces regular progress reports of all activities for review and planning. Deliver on the project roadmap, help drive the vision, and support the prioritization, ideation, and planning of the future business intelligence needs. Maintain version control and own the change and release management process. Define processes, standard operating procedures, and prepare technical documentation. Preform QA on reports and devise and deliver testing plans and testing data to validate BI solutions, coordinate user testing for acceptance of BI solutions. Manage Power BI administration activities including capacity creation and management, data connection creation and updating, user and group access provisioning, manage row level security. Build advanced user and usage reporting capabilities. Ingest data from a wide variety of sources and preform ETL to clean and process data for final consumption into Power BI. Follow the latest Power BI releases and capabilities. Assist, instruct, and coordinate the work of future developers.

Skills:

Expert in MS Power BI. Solid understanding of DAX with significant experience coding complex DAX expressions Prior experience facilitating conversations to translate business requirements into the technical data requirements needed to develop solutions. Advanced knowledge of SQL, comfortable and writing and debugging SQL queries and extracting from and querying large and diverse databases (e.g. Azure Databricks, Snowflake, Teradata, MS SQL server). Advanced understanding of stored procedures Advanced skills in data cleansing, profiling, modeling, integration, analysis Strong knowledge and hands-on experience in data modeling, data architecture and data warehouse design. Power BI administration expertise Understanding of both on-premises and a gateway Need to be versed in security, setting up workspaces, creating data models, the cubes to support the data modeling, understand the limitations of the tool. Power Query experience Experience using APIs and API data transfer