Lead ETL Developer
Bengaluru - Whitefield India
Applications have closed
athenahealth
Join 140K providers on the largest connected network in healthcare. See how we’re making connections that improve patient outcomes & clinician experiences.Join us as we work to create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all.
We are seeking a highly skilled and motivated individual to join our Enterprise Data and Analytics team as a Lead Member of Technical Staff, individual contributor. In this role, you will be responsible for the Marketing data subject area, with a focus on building and supporting ETL pipelines for the Marketing organization, as well as acting as a data warehouse architect.
If you are a highly motivated individual with a passion for data management, ETL development, and data warehousing, we encourage you to apply for this exciting opportunity to contribute to our Enterprise Data and Analytics team. The team consists of a cohesive group of highly skilled professionals who are passionate, intellectually adept, and committed to delivering exceptional results while also fostering an engaging and enjoyable work environment.
Job Responsibilities:
- Collaborate with the Marketing team to understand their data requirements and design efficient ETL pipelines to extract, transform, and load data from various sources into the data warehouse.
- Build and maintain scalable and robust ETL processes using Informatica or similar ETL technologies, ensuring data accuracy and integrity.
- Serve as a data warehouse architect, designing and implementing data warehousing solutions that meet the needs of the Marketing organization.
- Work closely with cross-functional teams to gather business requirements, provide data insights, and support data-driven decision-making processes.
- Optimize and tune ETL processes for performance and efficiency, ensuring timely and accurate data delivery.
- Troubleshoot and resolve issues related to data quality, data integration, and ETL processes.
- Collaborate with other teams within the Enterprise Data and Analytics department to ensure alignment and consistency in data management practices.
- Stay up-to-date with industry trends and best practices in ETL technologies, data warehousing, and data management.
Qualification & Skills required:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Strong understanding of data warehousing concepts, dimensional modeling, and data integration techniques,
- Proven hands-on experience designing and implementing data warehouses and data marts.
- Proven experience (at least 7 years) in hands-on ETL development, with expertise in Informatica or similar ETL technologies, including web services (APIs).
- Excellent communication skills, with the ability to effectively communicate complex technical concepts to both technical and non-technical stakeholders.
- Self-starter with the ability to work independently and manage multiple projects simultaneously.
- Strong analytical and problem-solving skills, with a keen attention to detail.
- Familiarity with data modeling concepts and techniques, including entity-relationship diagrams (ERDs) and data flow diagrams (DFDs).
- Proficient in creating comprehensive data models and supporting documentation, including data dictionaries, entity-relationship diagrams (ERDs), and data flow diagrams (DFDs), to ensure clear understanding and efficient communication of data structures and relationships within the organization.
- Experience with SQL and relational databases, including the ability to write complex queries, optimize database performance, and ensure data integrity.
- Experience working in a collaborative team environment, with the ability to work effectively with cross-functional teams.
- Familiarity with marketing data and analytics strongly preferred.
About athenahealth
Here’s our vision: To create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all.
What’s unique about our locations?
From an historic, 19th century arsenal to a converted, landmark power plant, all of athenahealth’s offices were carefully chosen to represent our innovative spirit and promote the most positive and productive work environment for our teams. Our 10 offices across the United States and India — plus numerous remote employees — all work to modernize the healthcare experience, together.
Our company culture might be our best feature.
We don't take ourselves too seriously. But our work? That’s another story. athenahealth develops and implements products and services that support US healthcare: It’s our chance to create healthier futures for ourselves, for our family and friends, for everyone.
Our vibrant and talented employees — or athenistas, as we call ourselves — spark the innovation and passion needed to accomplish our goal. We continue to expand our workforce with amazing people who bring diverse backgrounds, experiences, and perspectives at every level, and foster an environment where every athenista feels comfortable bringing their best selves to work.
Our size makes a difference, too: We are small enough that your individual contributions will stand out — but large enough to grow your career with our resources and established business stability.
Giving back is integral to our culture. Our athenaGives platform strives to support food security, expand access to high-quality healthcare for all, and support STEM education to develop providers and technologists who will provide access to high-quality healthcare for all in the future. As part of the evolution of athenahealth’s Corporate Social Responsibility (CSR) program, we’ve selected nonprofit partners that align with our purpose and let us foster long-term partnerships for charitable giving, employee volunteerism, insight sharing, collaboration, and cross-team engagement.
What can we do for you?
Along with health and financial benefits, athenistas enjoy perks specific to each location, including commuter support, employee assistance programs, tuition assistance, employee resource groups, and collaborative workspaces — some offices even welcome dogs.
In addition to our traditional benefits and perks, we sponsor events throughout the year, including book clubs, external speakers, and hackathons. And we provide athenistas with a company culture based on learning, the support of an engaged team, and an inclusive environment where all employees are valued.
We also encourage a better work-life balance for athenistas with our flexibility. While we know in-office collaboration is critical to our vision, we recognize that not all work needs to be done within an office environment, full-time. With consistent communication and digital collaboration tools, athenahealth enables employees to find a balance that feels fulfilling and productive for each individual situation.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Computer Science Data management Data quality Data warehouse Data Warehousing ETL Informatica Nonprofit Pipelines RDBMS Security Spark SQL STEM
Perks/benefits: Career development Health care Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Marketing Data Analyst jobs
- Open Power BI Developer jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open LLMs-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Data warehouse-related jobs