Job Description
BI Engineer – EDW/BI Analytics
What You’ll Be Doing:
- Ability to create and maintain the logical and physical Data Models for Business Intelligence Data Warehouse and Data Marts
- Designs and monitors the construction of user-facing Data Visualization and presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports, SSAS cubes, PowerBI, Excel – Pivots and PowerPivots.
- Defines and implements best practices and standards for the data modeling processes required for developing reporting and analytical layer in EDW platform.
- Collaborates in data design walkthroughs to communicate Data Warehouse and Data Mart table designs to the development team.
- Develops prototype views and reports of the data and works with business users both internal and external to refine their requirements.
- Data Analysis: Ability to perform complex data analysis using advanced SQL skills and Excel to support internal client’s data requests and queries.
- Self-motivated; takes initiative without prompting, ability to problem solve and think critical/ logical reasoning, attention to details; passion for accuracy.
- Collaborative; seeks input from others; operates with positive intent.
- Minimum of 4 years’ experience in BI/ Data Warehouse domain developing BI solutions and data analysis tasks using MSBI suites.
- Expert level T-SQL experience in writing/maintaining stored procedures and complex queries.
- Expert level experience in SQL Server Reporting Services (SSRS) and/or SQL Server Analysis Services (SSAS) in developing BI solutions.
- Construction design of user-facing presentation tools: PowerBI, Excel based charting, Power Pivot, etc.
- Strong attention to detail, ensuring software development processes are followed and root cause remediation is planned and executed for each issue, and that actions are fully documented.
Finishing Touches (Preferred):
- BA/BS in Engineering, Computer Science, or related field.
- Comfortable working in shifts
- Healthcare with Clinical and/or claims data experience will be a plus.
- Microsoft Certifications in MSBI suites.
- Fair understanding of statistical methods & data modeling to enhance analytical capabilities.
- Experience in SSIS.
- Experience with Medical claims data and Oncology or Cardiology specific domain.
- Experience with MS Master Data Services(MDS) and MS Data Quality Services(DQS) tools will be a plus.
About Mindpool Technologies:
Mindpool Technologies Limited is one of the renowned development and digital marketing firm with a decade long experience. We design strategies and solutions that are tailored specifically to your business vision. What makes us strong are our diverse expertise and a proven record of working with every industry type. We are powered with a strong team of certified and promising professionals. Our unique approach and innovative thinking have helped many businesses to expand and gain recognition. Accredited with ISO 9001:2015 and ISO/IEC 27001:2013, Mindpool has proven to be a trusted technology partner to our clients by maintaining a high standard of products/service
Apply for this Position
Ready to join ? Click the button below to submit your application.
Submit Application