BI Developer

Are you looking to make a difference? So are we...

Thanks for stopping by! We’re Doctor Care Anywhere: a leading digital platform, with a clear vision to radically transform the future of healthcare – and that all starts with our brilliant team.

From doctors and designers to software developers and marketers – we’re proud of our people, who love working together to enhance patient experiences for the better. It’s why every year, we help over 2 million people speak to a GP by video or phone, anywhere in the world.Our story started back in 2013, but as we continue to rapidly grow, we’re looking for the very best talent to help us achieve our ambitious goals.

If you’re highly motivated, hard-working and ready to dream big – while having lots of fun at the same time – then we want to hear from you today!

Your new role: We are seeking an experienced Business Intelligence Developer to join our growing Data team to enable us to delve deeper into our data and provide insights for us to continue to Improve Peoples' Lives. This opportunity is hybrid/working from home.

Requirements

• Examine complex data and turn the data into information and insights
• Develop Power BI models used for the different departments’ reporting
• Use various sources to pull data into Power BI such as SQL Server, Dynamics 365, SQL Azure, etc
• Install and configure Enterprise Gateway and Personal Gateway in Power BI Service
• Create Workspace and Content Packs for business users to view the developed reports
• Schedule Automatic Refresh and Scheduling Refresh in Power BI Service
• Write Calculated Columns, Measures Queries in Power BI Desktop to show good data analysis techniques
• Create stored procedures and SQL queries to pull data into Power Pivot Model
• Extensively use Joins and Sub-Queries to simplify complex queries involving multiple tables
• Transform complex business logic into Database design and maintain it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs
• Develop Excel Power View, Power Query and Power Pivot dashboards for data analysis
• Perform Index analysis for tables and come up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard
• Create Reports using Charts, Gauges, Tables, Matrix
• Create Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week
• Create Drill Down Reports, Drill Through Report for multiple dimensions
• Build data loading services for the purpose of importing data from numerous, disparate data sources, inclusive of APIs, logs, relational, and non-relational databases
• Keep track of industry best practices and trends, and through acquired knowledge, take advantage of process and system improvement opportunities

Experience

• Database design, interrogation & programming skills (relational database, advance select queries, indexes and constraints).
• Expertise in writing complex DAX functions in Power BI and Power Query
• Ability to write advanced SQL including some query tuning
• Expert in creating and developing Power BI Dashboards in to rich look
• Good understanding on the data warehouse concepts
• Expertise in OLAP and OLAP Cubes
• Experience in ad-hoc reports, data driven subscription reports
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week
• Previously worked with large data sets
• Excellent problem solver able to analyse data, identify issues/opportunities, design and implement pragmatic solutions
• Proven abilities to be pro-active, take initiative and be innovative within a team environment
• Analytical mind within a problem-solving attitude with a keen eye for detail
• Ability to work on several projects at the same time and prioritise effectively

Software experience

Must have

• Microsoft SQL Server,T-SQL, Advanced Excel, Power BI, SSRS, SSAS

Desirable

• Git hub, Jira – Confluence , DevOps , Microsoft Dynamics, Azure environment, Healthcare experience, Evidence of continued learning

Benefits

Why you want to work here:

We understand the importance of good health and happiness for our patients and our team is just the same. You should expect to be as supported and valued being a member of our team and have the freedom to make the most of your role and career with us! When you’re part of the team you will have access to:

• Free Private Medical Insurance (savings on vision and dental care plus 40% off Nuffield Health gym membership)
• Doctor Care Anywhere subscription for you + 5 members of your friends or family
• Company bonus
• 25 days holiday + bank holidays
• 4 x charity days a year
• Enhanced Maternity and Paternity pay
• Life Assurance
• Bike2Work scheme
• Cross-team collaboration opportunities in an autonomous environment
• Remote / Flexible Working with contribution towards home set up and your laptop provided
• Range of Development opportunities including learning and progression
• Pool Table, PlayStation and karaoke machine
• Beer Fridge Fridays / Free fruit + snacks