Senior Data Engineer
Remote, United States
Cotiviti
Cotiviti is a solutions and analytics company leveraging unparalleled clinical and financial datasets to deliver insight into the healthcare system’s performance.Overview
As a Senior Data Engineer, you will work with the team to build complex data pipelines using a new cutting-edge Data Ingestion Platform as well as several new and exciting products in the Big Data/Advanced Analytics space. You will operate in a fast-paced environment where multiple project deliverables are coordinated within specified deadlines. The primary responsibility of this role is to deliver accurate and timely data across various products to enable revenue for the company. The ideal candidate will have data analysis and data pipeline development experience using big data tools (like Spark, Scala, Hive), relational databases, intermediate SQL skills. Healthcare knowledge is a plus.
Responsibilities
- Assemble large, complex sets of data that meet non-functional and functional business requirements
- Identify, design and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
- Build required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies
- Build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition
- Work with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues
- Work with the Business and Product owners to determine business requirements.
- Works with the development team to develop and define the scope and objectives of the BI requirements.
- Demonstrate leadership skills in driving team to achieve high vlue business priorities.
- Communicate effectively (oral and written) and in a timely and accurate manner, keeping management abreast of potential issues that could derail priority objectives. Risk mitigiation plans are proposed and demonstrate intellectual control over the subject matter.
- Delegate effectively and use delagation to promote growth/maturity of junior personnel.
- Analyze and evaluate detailed business and technical requirements and comes up with a high-level design and solution which leverages reuse and is generic in nature, avoiding client specific solitions.
- Design creative solutions to automate extraction and migration of data from different source systems into the BI environment using SSIS and MS SQL Server 2019.
- Review the database needs and develop strategies and programs to manage any forthcoming issues.
- Perform support work as needed. For issues that are recurring in nature, assesses low-risk options and promotes/sponsors alternatives that will help in reducing/eliminating reoccurence of such issues.
- Research and learn new technological capabilities to drive our offerings forward.
- Work as a SME and mentor to Business Intelligence Developers on Data warehouse/ Data Vault and Analytics team.
- Document and maintain the design and architecture components of the BI applications.
- Define and implemens coding standards and best practices for BI development.
- Mentor others on coding standards and performs code reviews.
- Anticipate opportunities for improvement and identifies alternate solutions.
- Develop and perform system/integration testing and fixes defects identified during the testing.
- Aid in the integration activities with other BI teams for successful implementation and support of products.
- Support Infrastructure team to maintain the technical BI development environment and provides inputs to the implementation plan
- Assist in developing training documentation, including proactive identification of additional needs and enhancements.
- Complete all responsibilities as outlined in the annual Performance Plan.
- Complete all special projects and other duties as assigned.
- Self-starter who can take initiatives, flexible, and has worked under tight timelines to deliver.
- Must be able to perform duties with or without reasonable accommodation.
Qualifications
- Bachelor's degree in Computer Science or other Bachelor's degree demonstrating technical expertise.
- 7-8 Years of experience in IT field with strong understanding of development life cycle and development practices.
- 5-6 year working experience in TSQL with SQL Server.
- Proficient in writing advanced optimized TSQL query and tuning the existing code.
- 3-4 years of working experience in SSIS using SQL Server.
- Experience in working with data warehouse designing and it's architecture.
- Experience in working on reporting tools, SSRS, Tableau.
- Strong organizational, analytical, and communication skills are a must
- Experience working with a large volume of data in a Healthcare environment
Base compensation ranges from $90,000 to $125,000. Specific offers are determined by various factors, such as experience, education, skills, certifications, and other business needs.
Cotiviti offers team members a competitive benefits package to address a wide range of personal and family needs, including medical, dental, vision, disability, and life insurance coverage, 401(k) savings plans, paid family leave, 9 paid holidays per year, and 17-27 days of Paid Time Off (PTO) per year, depending on specific level and length of service with Cotiviti. For information about our benefits package, please refer to our Careers page.
Since this job will be based remotely, all interviews will be conducted virtually.
Date of posting: 03/13/2024
Applications are assessed on a rolling basis. We anticipate that the application window will close on 06/13/2024, but the application window may change depending on the volume of applications received or close immediately if a qualified candidate is selected.
#LI-RA
#LI-Senior
Tags: Architecture AWS Big Data Business Intelligence Computer Science Data analysis Data pipelines Data warehouse MS SQL Pipelines RDBMS Research Scala Spark SQL SSIS Tableau Testing T-SQL
Perks/benefits: Career development Competitive pay Flex hours Flex vacation Health care Insurance Medical leave Startup environment
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 Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs