Our client, a US Fortune 50 organization and a leading provider of Health care and Health Insurance services, seeks an accomplished ETL/Power BI Engineer

______________________________________________________________________

NOTE: THIS IS 100% REMOTE ROLE & ONLY W2 CANDIDATES.

*** Candidate must be authorized to work in USA without requiring sponsorship ***

Position: ETL/Power BI Engineer (Job Id - # WLPTJP00045255)

Location: Indianapolis IN 46250 (100% REMOTE)

Duration: 12 months + Strong Possibility of Extension

_________________________________________________________

The Data/BI Engineer Sr is responsible for designing, developing, implementing, and maintaining cloud data pipelines for business intelligence collection and analysis. This role is crucial in managing data integration processes and visualization solutions, utilizing both technical and analytical skills to convert raw data into actionable insights.

Client is looking for a highly skilled and motivated Data/BI Engineer Sr with expertise in AWS cloud technologies to support automation, orchestration, and ETL processes across the entire data lifecycle, including transformation, management, retention, security, performance tuning, and SLA management. The Data/BI Engineer will collaborate with data owners, technical teams, and business units to identify key metrics and insights, developing reporting and visualization solutions. Responsibilities include requirements gathering, system design, data process development, and data delivery and visualization to meet business needs.

Key Responsibilities:

• Design and develop scalable cloud data pipelines using AWS technologies, such as Glue, for extracting, transforming, and loading (ETL) data from various sources into data lakes or warehouses.
• Create and maintain data models to support efficient querying and reporting, ensuring data integrity and consistency.
• Integrate data from multiple sources, including relational databases, APIs, and unstructured data, to provide a unified view for analysis.
• Develop interactive dashboards and reports in Microsoft Power BI to present data insights to stakeholders and facilitate informed decision-making.
• Optimize ETL processes and Power BI reports for performance, ensuring data availability and responsiveness.
• Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver solutions that meet business needs.
• Demonstrate proficiency in SQL and scripting languages such as Python or Scala.
• Build data visualizations to effectively illustrate trends, patterns, and outliers.
• Monitor and refine data pipelines and visualization tools to meet SLAs and delivery expectations.
• Provide timely updates to customers, business units, and staff regarding projects and tasks.
• Conduct proactive data reviews to ensure the quality and accuracy of reporting solutions.
• Ensure data processing and storage operations are conducted efficiently and in compliance with security guidelines.

Required Skills, Capabilities and Experiences:

• Over 5 years of experience in designing, developing, testing, and implementing enterprise ETL solutions, as well as process automation and orchestration.
• Proficiency with cloud data processing platforms and technologies, including AWS data pipeline toolsets.
• Expertise in data process orchestration and the design and development of near-real-time and batch data pipelines.
• Skilled in programming languages such as Python, Scala, SQL, R, and T-SQL.
• Ability to analyze, troubleshoot, and optimize SQL queries, with the capability to recommend improvements.
• Experience in analyzing and monitoring data processing resources, implementing proactive alerts and notifications based on SLAs.
• Possession of relevant certifications in data engineering/development platforms and related technologies.
• Experience in the healthcare claims processing industry with an understanding of data security and privacy considerations.
• Strong critical thinking and problem-solving skills.

_______________________________________________________

If you're looking for rewarding employment and a company that puts its employees first, we'd like to work with you. We're driven, people driven

Bhupesh Khurana

Senior Technical Recruiter

Email:

Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally; as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients’ businesses forward.

Amerit Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.