From:
Khushi Malhotra,
TestingXperts
[email protected]
Reply to: [email protected]
Role: Power BI DeveloperLocation: Charlotte, NC (Hybrid)Business Intelligence Engineer Job Description:This position is for a Business Intelligence / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. Strong Power BI experience is a must especially in developing dashboards and canned reports.The candidate will be responsible for the design and development of reports, dashboards and ad-hoc queries. The position calls for someone that is comfortable working with business users along with business analyst expertise. Experience with the following technologies will be required:- Power BI Dashboards and Paginated Reports- Snowflake- PBRS- Power On- SQL Server 2016- DatawarehousingQualifications:- Minimum 3+ years of combined experience in data warehousing/business intelligence/analytics and reporting systems.- Minimum 3+ years of relational and multi-dimensional (OLAP) data modeling Proficiency in the use of SQL, including relational and dimensional database structures, query optimization, specifically with SQL Server- Strong knowledge of Fixed Income, Equity and Derivative businesses- Strong ability to analyze user requirements, make recommendations and implement solutions- Self-driven and should be able to troubleshoot and provide quick resolutions to issues. - Full project management and development life cycle experience- Strong oral and written communication skills- Strong presentation and interpersonal skills- Ability to prioritize and execute in a high-pressured environment- University bachelor degree (Computer Science, Information Systems or Computer Engineering)Requirements:• Experience with Power BI development, visualizations and deployment (8+ years).• Experience with the Microsoft BI stack, including TSQL, PowerBI, DAX, Power Query, M, MDX and, SSAS, SSRS, SSIS (8+ years).• Experience with configuration / management of Microsoft Power BI Service Experience extracting, manipulating and analyzing data via Dataflows, Datamarts, Dashboards and Apps to recommend and/or take action. (8+ years).• Demonstrated SQL development experience by writing queries and procedures and also using functions to create curated data for use in reporting.• Excellent written, verbal and presentation skills.• AWS Cloud and/or Snowflake experience is a plus• Understand glossaries and terminologies in end-to-end skills and financial industry• Experience documenting business requirements, processes and workflows (5+ years)• Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming is preferred.• Must be detail oriented, and able to work independently and self-prioritize tasks.• Demonstrated experience in working with relational databases: SQL Server (8+ years).• Bachelor's degree in Computer Science, Design, Statistics, or equivalent.• Microsoft Power BI Certification is a plusResponsibilities:• Participate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions which answer those questions• Develop reports, thoughtful visualizations , dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniques• Perform UX design activities and Power BI navigation features (e.g. bookmarks, drill-throughs) to guide end-users through a data-driven story• Develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets• MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX• Work with our internal customers to manage User Acceptance Testing (UAT) processes and address their feedback• Power Query and coding fundamentals (ability to use M language to build loops, pull APIs, etc.)• Assist with governance and deployment of Power BI , including administration, content distribution/sharing, training and support• Proficient Data Architecture and Modelling experience (Structuring Tables, Attributes, and Relationships [One-to-One, One-to-Many, Many-to-One, Many-to-Many])• Champion the leading Power BI design methodology and best practices• Extract data from various data sources ; perform exploratory data analysis, cleanse, reshape, and aggregate data• Evangelize data analytics best practices among peers and stakeholders• Proactively monitor and evaluate the impact of monthly Power BI releases.• Conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities