Our EDWBI team at New Century Health (wholly-owned subsidiary of Evolent Health) is looking for a Technical Lead to part of EDWBI platform team to help build data driven analytics apps leveraging existing EDWBI platform
Essential functions
Design and implement construction and enhancements of NCH enterprise data warehouse including ETL and user-facing presentation tools, such as Microsoft SQL Server SSIS, SSRS, SSAS & PowerBI while collaborating with a Data engineers & BI Developers.
Design and implement construction of OLAP or Semantic Layer based on business needs for advanced analytics
Mentor and guide data engineers, consultants and data analysts in design and development processes.
Establish and implement standards and strategies for Data Validation approaches and Master Data Management, lifecycle, and data quality.
Define best practices and standards for the data modelling process, software development life cycle and Agile methodologies.
Creation and maintenance of the logical and physical data models for the production and Business Intelligence data warehouse and data marts.
Release Management: Manages DWBI release calendar and change management process including managing coding standards, central code repository and code release to production.
Engineer workflows using cutting edge functional techniques – You will be part of a team that develops interactive analytic solutions against healthcare data. You will learn functional techniques that enable our systems to ingest data, generate insights and distribute meaningful insights.
Deliver work in Agile process – You will work in Agile processes for your day to day work. You will work closely with other engineers to deliver critical business enhancements on a bi-weekly cadence. You will be expected to participate in hackathon and innovation opportunities on a quarterly basis.
Code review fellow team members according to corporate standards – Part of your responsibilities will be to collaborate with your fellow engineers to ensure quality and performance of the enhancements. Your opinion will be critical to the success of your colleagues – just as much as their opinions will be critical to your success!
Follow Continuous Delivery processes for software development and deployment – You will be expected to maintain exceptionally high quality of code check-ins with enhancements being shipped to production environments on a regular basis. It will be your responsibility to ensure that automated controls for validating software quality are kept up to date and functioning.
Key competencies/skill/success factors:
Requires hands-on knowledge of developing data applications using SQL Server 2016 and MS BI suites (SSRS, SSIS, SSAS).
Hands on experience with data modelling, building queries, data warehouse, data marts, and cubes.
Minimum 1-3 years’ experience in healthcare (e.g. claims, finance, authorizations, pharmacy data).
Professional speaking abilities; able to articulate thoughts with both business & technical audiences
Qualification and Experience:
Required
Bachelor’s degree in Computer Sciences or related fields
Minimum 7 years’ experience in building and managing Data Warehouse and Analytical platforms.
Minimum of 3 years’ experience in leading design and architecture of Data Warehouse development and BI applications.
Big plus
Microsoft Certified Database Administrator (MCDBA) or Microsoft Certified Solutions Developer (MCSD)
Experience in building data validation platform using Master Data Services (MDS) and Data Quality Services (DQS).
Familiarity with Power BI Online and Azure cloud based data warehouse technologies.
Knowledge of addressing query performance issues, indexing, data profiling, DMV’s, DMF’s, and other database related activities.

One of our leading client is looking for a Power BI Developer. The Power BI resource will analyze, design and build all the reports for the business users from the new Risk DB Application.

Position : Permanent
Location : Chennai
Salary : As per industry standards

Job Details:

Job Title: Power BI Developer

Location : Chennai

Experience : 5 – 8 Years

Contract Period : 10 months with high probability of extension

Salary: As per industry standards

Scope of work
The Power BI resource will analyze, design and build all the reports for the business users from the new Risk DB Application. The person will ensure that he/ she works closely with the business users to document the reporting/ dash boarding requirements and create these reports. The incumbent will be expected to consistently produce high quality results that meet business and other stakeholder needs , while ensuring the analysis, design, and development of reports are based on requirements and desired functionality defined by the business and produces quality results that meet business objectives and timelines.

Skills / Experience Required

The Business Intelligence resource will work under minimal supervision to analyze, design, build, Test and deploy the reports and dashboards as required by the stakeholders. The BI resource shall work closely both with the business users and application builds IT team. The person shall also work very closely with the other IT teams within the project and without, to meet the client’s internal standards and guidelines for the said application.

General Skills / Abilities

• 3 to 6 Years

• B.E. (Information Technology) / B.E. (Computer Science) / M.C.A. / B.Tech (Information Technology)

• NA

Position Overview

The Business IntelligenceSenior Developer is responsible for technical implementation of current and future data warehouse, business intelligence solutions and data migration strategies using Microsoft BI stack.

Key Responsibilities

• Implement new business intelligence and data warehouse requirements using SQL, ETL, business intelligence tools, and database programming and reporting tools
• Meet with customer, business, and technical leaders to identify and scope business opportunities, document and vet business requirements, identify effective reporting techniques, identify the best data sources for each report field, identify risks and constraints, and design reporting formats
• Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse
• Develop optimized database design to achieve acceptable performance by tuning view, tables, and indexes for proper response times
• Develop new capabilities and architectures that capitalize on the development of client portal, and ad-hoc BI capabilities
• Full life-cycle development and maintenance of data warehouse, ETL, and business intelligence solutions
• Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners
• Provide guidance and recommendations on BI reporting packages
• Develop ETL Packages using Microsoft SQL Server Integration Services
• Implementation & Maintenance of Data Warehouse & Cube.
• Optimize the ETL Packages
• Analyze system issues reported by users and present workable solutions
• Deploy ETL Packages/Cubes on Development/Test environment, and provide deployment instruction for further deployment on production
• Plan and oversee the design, build, and testing of system environments and related interfaces
• Supervise staff and perform tasks associated with managing a development and support team
• Participate in peer-reviews of solution design and related code
• Provide technical leadership that allows the team to enrich their technical skills, knowledge, methods, and development toolsets
• Create unit test cases and unit test plans; execute unit testing
• Mentor and train technical and non-technical team members

We are seeking candidates with the following experience and skills

• 6+ years of hands on experience implementing business intelligence solutions using Microsoft BI stack
• Strong SSRS, SSIS and SSAS skills
• Strong TSQL and MDX query writing skills
• Experience working with PowerBI or Dundas is preferred
• Strong customer service orientation
• Analytical, troubleshooting, and problem-solving skills
• Logical, efficient, and proactive
• Keen attention to detail
• Ability to effectively communicate ideas
• Experience working in a team-oriented, collaborative environment
• Comfortable with ambiguity, possess the ability to adapt quickly and easily, and possess the ability to analyze complex problems and move them to resolution
• Background and style that elicits respect in the organization through style of engagement, technical depth, customer service and results
• Positive attitude and ability to build strong relationships within the company and with external partners
• Very strong communication skills (written and verbal)
• Skills : SSRS, SSIS, TSQL, SSAS, MDX Query Writing Skills

As a rapidly growing global provider of IT solutions, we’ve expanded from Seattle to Sydney, Dallas to New Delhi and beyond – with reach in over 80 countries around the world. Today’s top brands count on Zones and our world-class partners – Microsoft, Apple, Cisco, Dell, Lenovo, and more – to transform their enterprises. Headquartered in New Delhi and backed by the Zones Global Team, Zones India offers customized IT solutions and professional services to multinational organizations conducting business in the country.

Zones offers a comprehensive Benefits package

While we’re committed to providing top-tier solutions, we’re just as committed to supporting our own team. Our employees enjoy a variety of comprehensive benefits, paid time off, and much more. And as a Minority Business Enterprise, a Corporate Plus member of the Northwest Minority Supplier Development Council, and an Equal Employment Opportunity Employer, our community is just as diverse.

At Zones, work is more than a job – it’s an exciting career immersed in an inventive, collaborative culture. If you’re interested in working on the cutting edge of IT innovation, sales, engineering, operations, administration, and more, Zones is the place for you!

About Accenture: Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, Technology and Operations services-all powered by the world’s largest network of Advanced Technology and Intelligent Operations centers. Our 674,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries.We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities. Visit us at www.accenture.com

Accenture | Let there be change

We embrace change to create 360-degree value

www.accenture.com

• Project Role :Application Developer
• 
  Project Role Description :Design, build and configure applications to meet business process and application requirements.
• 
  Management Level :10
• 
  Work Experience :4-6 years
• 
  Work location :Bengaluru
• 
  Must Have Skills :Microsoft PowerApps
• 
  Good To Have Skills :Microsoft Power BI
• 
  Job Requirements :
  

  • Key Responsibilities : aTechnical understanding of the Power App, Power Virtual Agents, Power Automate and its implementation Support the Product Architect in defining and documenting artefacts supporting their business outcomes including but not limited to: conceptual solution diagram, high-level solution architecture, capability definition and diagram,
  • 
    Technical Experience : a- Ability to architect Enterprise Solutions using Power App, Power Virtual Agents, Power Automate Understanding of all custom connectors in power platform / Power Automate Provide power platform / Power Automate implementation strategy and approach Experience of developing and architecting enterprise scale services or solutions Proficient expertise across a breadth of technology architectures
  • 
    Professional Attributes : aResource is expected to have excellent verbal communications skills and have good client expectation management and presentation skills
  • 
    Educational Qualification : aAs per Company Standards

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

DescriptionExternal

BI Developer – Staff

The opportunity

We’re looking for Staff Level Consultants as Business Intelligence (BI) Developer to join the Enterprise Applications group of our GDS consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.

Your key responsibilities

• Translating business needs into technical specifications.
• Developing reporting systems that provide accessible information for decision-making.
• Using warehouse data to generate reports to support business decision making and business performance monitoring.
• Evaluating and improving existing BI systems over enterprise applications like Oracle ERP.
• Generating and delivering quality reports to customers and performing quality assurance checks on reports. Develop, Customize, Deploy, maintain data visualizations as per client business requirements
• Should have thorough knowledge in creating dynamic visualizations with multiple concepts.
• Experience working with clients throughout various parts of implementation lifecycle
• Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements.

Skills and attributes for success

• Strong experience on building Dynamic, Interactive dashboards and ad hoc reporting.
• Experience with query tools and data visualization.
• Demonstrate management and an ability to drive projects or teams individually
• Excellent analytical thinking for translating data into informative visuals and reports

To qualify for the role, you must have

• 2-6 years of experience as BI Developer
• Expertise in the Power BI or OBIEE or IBM Cognos with strong Data Warehouse concepts.
• Expert Level knowledge in Structured Query Language (SQL) and experience working on RDBMS
• Should have experience in creating dashboards, presentations like line, bar, histograms, scatter, water, Bullet, Heat maps, tree maps etc.
• Should have experience in creating calculated measures and columns with DAX in Power BI.
• Experience on Sharing, Publishing and setting up Row level security of reports.
• Should have designed and developed stored procedures, queries, ETL Process, views, Data models necessary to support BI Visualizations.

• Should be able to effectively handle reports performance and administration
• Knowledge of SSRS/SSAS would be a plus
• Experience on different type of Power BI web concepts like Gateways, Schedule refresh, Q&A, Insights in Datasets.
• Should have Worked on providing permissions on Reports, Dashboards and Datasets using Content packs.

Ideally, you’ll also have

• Strong knowledge of ELT/ETL concepts, design and coding
• Expertise in data handling to resolve any data issues as per client needs
• Experience in designing and developing Oracle object such as
  • Tables, Views, Indexes, Materialized Views and Analytical functions
• Experience of creating complex SQL queries for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Candidate should be eager to learn advance technologies, new product updates etc., learn and train other team members
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into BI specifications and High- and Low-level design documents.
• Candidates having additional knowledge of BI tools such as Tableau, IBM Cognos etc will be preferred.

What we look for

• The incumbent should be able to drive BI dashboards related developments. Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage.
• An opportunity to be a part of market-leading, multi-disciplinary team of 10000 + professionals, in the only integrated global transaction business worldwide.
• Opportunities to work with EY GDS consulting practices globally with leading businesses across a range of industries

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

About EY

As a global leader in assurance, tax, transaction and GDS consulting services, we’re using the finance products, expertise and systems we’ve developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Join us in building a better working world.

Apply now

Responsibilities, Qualifications, CertificationsExternal

BI Developer – Staff

The opportunity

We’re looking for Staff Level Consultants as Business Intelligence (BI) Developer to join the Enterprise Applications group of our GDS consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.

Your key responsibilities

• Translating business needs into technical specifications.
• Developing reporting systems that provide accessible information for decision-making.
• Using warehouse data to generate reports to support business decision making and business performance monitoring.
• Evaluating and improving existing BI systems over enterprise applications like Oracle ERP.
• Generating and delivering quality reports to customers and performing quality assurance checks on reports. Develop, Customize, Deploy, maintain data visualizations as per client business requirements
• Should have thorough knowledge in creating dynamic visualizations with multiple concepts.
• Experience working with clients throughout various parts of implementation lifecycle
• Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements.

Skills and attributes for success

• Strong experience on building Dynamic, Interactive dashboards and ad hoc reporting.
• Experience with query tools and data visualization.
• Demonstrate management and an ability to drive projects or teams individually
• Excellent analytical thinking for translating data into informative visuals and reports

To qualify for the role, you must have

• 2-6 years of experience as BI Developer
• Expertise in the Power BI or OBIEE or IBM Cognos with strong Data Warehouse concepts.
• Expert Level knowledge in Structured Query Language (SQL) and experience working on RDBMS
• Should have experience in creating dashboards, presentations like line, bar, histograms, scatter, water, Bullet, Heat maps, tree maps etc.
• Should have experience in creating calculated measures and columns with DAX in Power BI.
• Experience on Sharing, Publishing and setting up Row level security of reports.
• Should have designed and developed stored procedures, queries, ETL Process, views, Data models necessary to support BI Visualizations.

• Should be able to effectively handle reports performance and administration
• Knowledge of SSRS/SSAS would be a plus
• Experience on different type of Power BI web concepts like Gateways, Schedule refresh, Q&A, Insights in Datasets.
• Should have Worked on providing permissions on Reports, Dashboards and Datasets using Content packs.

Ideally, you’ll also have

• Strong knowledge of ELT/ETL concepts, design and coding
• Expertise in data handling to resolve any data issues as per client needs
• Experience in designing and developing Oracle object such as
  • Tables, Views, Indexes, Materialized Views and Analytical functions
• Experience of creating complex SQL queries for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Candidate should be eager to learn advance technologies, new product updates etc., learn and train other team members
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into BI specifications and High- and Low-level design documents.
• Candidates having additional knowledge of BI tools such as Tableau, IBM Cognos etc will be preferred.

What we look for

• The incumbent should be able to drive BI dashboards related developments. Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage.
• An opportunity to be a part of market-leading, multi-disciplinary team of 10000 + professionals, in the only integrated global transaction business worldwide.
• Opportunities to work with EY GDS consulting practices globally with leading businesses across a range of industries

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.