2 Bi Solutioning Jobs

Job Responsibilities Data Management, Analysis and Visualization: Design compelling data visualizations and dashboards that support insight generation and effective data storytelling. Lead the design, development, and maintenance of BI dashboards and reports using Power BI. Integrate various data sources (Azure, SharePoint, SQL Server, APIs, etc.) with Power BI and perform data extraction, transformation, and loading (ETL) using DAX and Power Query (M Language) Implementing Row-Level Security (RLS) to enforce granular access controls, personalize data views based on user roles, and ensure compliance with data governance and privacy standards. Designing efficient data models with relationships, hierarchies, and star/snowflake schemas. Leverage machine learning techniques to enhance BI capabilities, including predictive modeling, anomaly detection, and automated insights within dashboards and reports. Collaborate with business stakeholders to gather requirements and translate them into analytical solutions. Project Management: Lead the team in planning, executing, and monitoring data-driven projects. Coordinate with cross-functional teams to ensure project goals are met within timelines. Identify and address potential roadblocks and propose solutions to maintain project momentum. Quality Assurance: Develop and implement data quality control procedures to ensure data accuracy and completeness. Conduct regular data audits and perform root cause analysis for any data discrepancies. Work closely with data engineers to maintain and improve data infrastructure. Stakeholder Engagement: Build strong relationships with internal stakeholders to understand their data needs and provide tailored solutions. Communicate complex data-related concepts to non-technical stakeholders in a clear and concise manner. Act as a liaison between the Data and Analytics Team and other departments to facilitate data-sharing and collaboration. Continuous Improvement : Stay updated with industry trends and best practices in data management and analytics. Propose and implement process improvements to enhance team efficiency and effectiveness. Participate in knowledge sharing sessions to foster a culture of continuous learning and growth. Qualifications Bachelor`s or Master`s degree in Data Science, Statistics, Mathematics, Computer Science, or a related field. Professional Experience The candidate must have 6-8 years of relevant experience in Data analytics, BI solutioning or a related field. Skills Expert-level proficiency in Power BI and SQL. Strong understanding of data warehousing and ETL pipelines. Hands-on experience with PySpark and big data platforms. Understanding of cloud services and machine learning tools. Excellent analytical and problem-solving skills. Excellent interpersonal and communication skills; capable of leading teams and collaborating across departments. Proven ability to manage multiple projects, prioritize tasks, and deliver results under tight deadlines.

As a Lead PowerBI Engineer, you will be responsible for working primarily with Power BI & Qlik Sense along with other Business Intelligence tools such as Tableau, Micro Strategy, Alteryx, or similar visualization technologies to present complex data in an easily digestible format. Your role will involve utilizing your experience in data analysis and writing SQL/MYSQL Workbench queries using joins, unions, and analytical functions. You will be expected to perform data management, mining, and manipulation tasks, utilizing SQL for data manipulation purposes. Additionally, your responsibilities will include BI solutioning to design, develop, and maintain user-friendly data visualizations and dashboards using complex datasets from various sources in Business Intelligence Tools. Collaboration with stakeholders to understand requirements and deliver comprehensive BI Solutions will be a key aspect of your role. You will also be required to connect Power BI to diverse data sources like Databricks, Oracle, and SharePoint, and design data models to facilitate complex data analysis. Using Dax & Power Query for advanced data analysis and creating calculated columns, measures & tables will be part of your routine tasks. Furthermore, you will develop Power BI models for report creation and dashboards, as well as create and execute manual or automated test cases and analyze the test results. Migration of dashboards from Qlik Sense to Power BI and working closely with fellow developers and project leads to coordinate tasks & deliverables are also part of your responsibilities. Your expertise should include the ability to work on multi-relational database structures, with a strong background in the Oracle Database environment, SQL, and PL/SQL programming. Designing and troubleshooting complex queries, stored procedures, functions, views, indexes, constraints, unions, joins, and similar development tasks will be part of your daily activities. Moreover, contributing to architecture, database design, and query optimization, as well as reviewing the database architecture of the product to achieve the required technical outcome, will be expected from you. Experience in Data Lake systems using AWS cloud technologies, particularly Data bricks, will be advantageous. Your role will also involve extensive data modeling and metadata experience, specifically designing logical models and data dictionaries based on business requirements and reverse-engineering. Hands-on experience in contributing to data/application architecture & designs, software/enterprise integration design patterns, and full-stack knowledge, including modern distributed front-end and back-end technology stacks, will be beneficial. Finally, you will be responsible for refining the product based on feedback, ensuring the continuity of accuracy and functionality, debugging applications, tracing code, and finding and fixing bugs to maintain the integrity and performance of the systems you work on.,