Job Closed

This listing is no longer active.

Data Warehouse ETL Developer

Analytics EngineerAnalytics EngineerOtherRemoteSeniorTeam 10,001+Since 2017H1B SponsorCompany SiteLinkedIn

Location

New Jersey

Posted

97 days ago

Salary

$80.1K - $104K / year

Seniority

Senior

Bachelor Degree5 yrs expEnglishETLInformaticaOracle DatabaseSQL

Job Description

Data Warehouse ETL Developer

Conduent

• Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter. • Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments. • Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions. • Optimize ETL processes for performance, scalability, and maintainability. • Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity. • Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents. • Participate in code reviews, unit testing, and UAT support. • Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements. • Provide production support and resolve data-related issues in a timely manner.

Job Requirements

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • 5+ years of experience in ETL development using Informatica PowerCenter.
  • Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
  • Experience with SQL, PL/SQL, and performance tuning of database queries.
  • Knowledge of data quality, data governance, and best practices in ETL development.
  • Strong analytical, problem-solving, and communication skills.
  • Experience with version control systems and ETL deployment processes.

Benefits

  • Health & Welfare Benefits: Comprehensive plans tailored to your needs, effective from day one.
  • Retirement Savings: Robust programs to help you secure your financial future.
  • Employee Discounts: Access to a wide range of discounts on merchandise, services, travel, and more.
  • Career Growth Opportunities: Paths for advancement within a global organization.
  • Paid Training: Learn while you earn with award-winning learning platforms.
  • Paid Time Off: Competitive PTO packages to help you recharge.
  • Great Work Environment: Join an award-winning culture that values diversity and inclusion.

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Komodo Health logo

Analytics Consulting Manager

Komodo Health

In our mission to reduce the burden of disease, our Healthcare Map™ answers healthcare's most complicated questions.

OtherRemoteTeam 501-1,000Since 2014H1B Sponsor

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This role exists on the Marmot Enabled Analytics (MEA) team to ensure the delivery of high-quality analytics products and services to our clients. The Analytics Consulting Manager plays a crucial role in driving client satisfaction, business growth, and innovation within the company seeking to demonstrate the value of Marmot (Komodo’s AI-enabled analytic platform). Looking back on your first 12 months at Komodo Health, you will have: - Successfully delivered complex analytics projects on time and within budget, exceeding client expectations. - Built strong, collaborative relationships with key client stakeholders, resulting in high levels of client satisfaction and repeat business. - Implemented process improvements that enhanced the efficiency and effectiveness of the MEA team. - Developed the skills and capabilities of team members, fostering a high-performing and engaged team culture. - Contributed to the growth of the company by identifying and pursuing new business opportunities within existing client accounts. - Demonstrated thought leadership in healthcare analytics, both internally and externally, through presentations, publications, and industry events. - Deepened your domain expertise across multiple key areas of interest to our clients, including but not limited to areas such as market landscaping, patient journey, line-of-therapy based analytics, segmentation & targeting, and analytical support for Custom Data Deliveries, “Digital” Audience Quality and other “advanced” analytics. You will accomplish these outcomes through the following responsibilities: - Manage the end-to-end delivery of analytics projects (~20-30 per year), from scoping and planning to execution and delivery. - In addition, manage the end-to-end delivery of year-long, on-going, Custom deliverables (3-5 per year). - Collaborate with cross-functional teams, including Data Science, Engineering, and Product Management, to ensure alignment on project goals and deliverables. - Serve as the primary point of contact for clients, addressing any concerns or issues that may arise during the project lifecycle. - Monitor project progress and performance, proactively identifying risks and implementing mitigation strategies as needed. - Stay abreast of industry trends and best practices in healthcare analytics, incorporating new insights and technologies into our service offerings. Qualifications - Bachelor's or Master's (preferred) degree in a quantitative field (e.g., Statistics, Mathematics, Computer Science, Economics) or equivalent practical experience. - 4-5 years of experience in healthcare analytics or related field, with a proven track record of delivering analytics solutions to clients. - Strong project management skills, with experience leading cross-functional teams and managing client relationships. - Excellent communication and presentation skills, with the ability to convey complex analytical concepts to non-technical audiences. - Proficiency in data analysis tools and programming languages such as SQL, Python, or R. Requirements - Judgement & Creativity: Applies AI strategically, knowing how to use the right tools at the right time to solve problems or generate new ideas. - Curiosity & Initiative: Demonstrates curiosity and initiative in exploring new AI tools and workflows relevant to their role. - Integration & Productivity: Brings a reflexive AI mindset and uses AI as a natural part of their process to iterate, research, and deliver better work. - Regularly leverages AI tools such as Notion AI, Perplexity, Claude, Descript, Runway, Midjourney, or Microsoft Copilot to improve speed, clarity, or creative output. Benefits - Comprehensive health, dental, and vision insurance. - Flexible time off and holidays. - 401(k) with company match. - Disability insurance and life insurance. - Leaves of absence in accordance with applicable state and local laws and regulations and company policy. Company Description At Komodo Health, our mission is to reduce the global burden of disease. We believe that smarter use of data is essential to this mission. The Healthcare Map serves as our foundation for a powerful suite of software applications, helping us answer healthcare’s most complex questions for our partners. Komodo Health has a hybrid work model with hubs in San Francisco, New York City, and Chicago.

United States
Job Closed
MetLife logo

Senior Data & Analytics Consultant

MetLife

MetLife is a leading insurance and financial services company based in New York, New York. The company and its affiliates specialize in employee benefits and li

Description and Requirements The Pet Senior Data & Analytics Consultant is responsible for delivering on the data needs of the pet business. This new position on the Pet Product Team will serve as the internal leader for data structure, reporting, and analysis, and will play a key role in efforts to improve and further develop the data capabilities of the department. They will ensure the business has the necessary data and accurate reporting to achieve our objectives and key results. This is a very visible role within the organization and will operate closely with various business leaders on a day-to-day basis to business' data and analytic requirements. Principal Responsibilities: • Supporting Pet Executive Team in extracting reporting from our data tables and systems of record (SORs) • Develop and maintain tooling to track cross functional performance, giving guidance where necessary • Manage analytics initiatives end-to-end, collaborating with the Data & Analytics and IT teams • SQL modeling for complex and layered problems not yet solved by Data Engineering • Utilize data and dashboards to identify opportunities for improving policy holder retention • Audit and reconcile differences in reporting across various teams • Organize multiple data sources and tables to build and prepare data foundations for each business use case • Will be responsible for UAT & QA testing, data analysis, data visualization, measurement, and analytics • Work closely with Pet Executive Team to review and monitor reporting requirements. This is a very technical hands-on role and is responsible for the functional design of the end-to-end data process • Work with business owners and data scientists to translate given business problems into analytical solutions with defined outcomes • Drive Continuous Improvement: Constantly analyze existing processes and systems to identify opportunities for automation and optimization • Perform other related duties as assigned or required Knowledge/Skills/Competencies Required: - 5+ years of relevant experience (Pet Insurance knowledge a plus) - Expert proficiency in SQL required for data extraction and transformation - Expert proficiency in Microsoft Excel required (VBA a plus) - Proficiency with PowerBI and data visualization - Understanding data warehousing concepts and architecture - Experience designing and maintaining scalable reporting solution - Excellent organizational, interpersonal, and communication skills, both written and verbal - Strong project management skills including problem solving, attention to detail, analytical thinking, and decisiveness - Ability to work autonomously; effectively handle multiple tasks, prioritize deadlines appropriately and remain flexible The expected salary range for this position is $76,500 - $125,000. This role may also be eligible for annual short-term incentive compensation. All incentives and benefits are subject to the applicable plan terms. Benefits We Offer Our U.S. benefits address holistic well-being with programs for physical and mental health, financial wellness, and support for families. We offer a comprehensive health plan that includes medical/prescription drug and vision, dental insurance, and no-cost short- and long-term disability. We also provide company-paid life insurance and legal services, a retirement pension funded entirely by MetLife and 401(k) with employer matching, group discounts on voluntary insurance products including auto and home, pet, critical illness, hospital indemnity, and accident insurance, as well as Employee Assistance Program (EAP) and digital mental health programs, parental leave, volunteer time off, tuition assistance and much more! About MetLife Recognized on Fortune magazine's list of the "World's Most Admired Companies", Fortune World's 25 Best Workplaces™, as well as the Fortune 100 Best Companies to Work For®, MetLife, through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by our core values - Win Together, Do the Right Thing, Deliver Impact Over Activity, and Think Ahead - we're inspired to transform the next century in financial services. At MetLife, it's #AllTogetherPossible . Join us! MetLife is an Equal Opportunity Employer. All employment decisions are made without regards to race, color, national origin, religion, creed, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, age, disability, marital or domestic/civil partnership status, genetic information, citizenship status (although applicants and employees must be legally authorized to work in the United States), uniformed service member or veteran status, or any other characteristic protected by applicable federal, state, or local law ("protected characteristics"). If you need an accommodation due to a disability, please email us at accommodations@metlife.com. This information will be held in confidence and used only to determine an appropriate accommodation for the application process. MetLife maintains a drug-free workplace. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liabilities. $76,500 - $125,000

United States
$76.5K - $125K / year
Job Closed
General Motors logo

AV Safety Engineering Analytics AI/ML Engineer (GPSSC)

General Motors

Join us on our journey toward a world with zero crashes, zero emissions, and zero congestion.

OtherRemoteTeam 10,001+Since 1908H1B Sponsor

Description Work arrangement : Remote: This role is based remotely but if you live within a 50-mile radius of [Atlanta, Austin, Detroit, Warren, Milford or Mountain View], you are expected to report to that location three times per week, at minimum. The AV Safety Engineering Analytics team is seeking and AI/ML Engineer with capabilities at the intersection of vehicle engineering, AI/ML and cloud processing. The AV Safety Engineering Analytics team is the resource supporting teams and stakeholders from around the company bring a broad range of data and analytics capabilities to bear in AV safety related decision making. This team will maintain proficiency integrating continuously flowing data from vehicle systems, company databases, third-party services, federal agencies and state DOTs to inform system design and quantify driving performance. The team focuses on continuous up-time proactive analyses as well as supporting specific investigations. If you're passionate about the benefits of autonomous vehicle technology, committed to advancing safety through AI and ML, and love channeling big data into clear guidance, this role offers exciting opportunities to make a meaningful impact on the future of transportation safety in a dynamic and fun environment. As part of the AV Safety Engineering Analytics team, you will be the subject matter expert in appropriately implementing AI/ML methods for safety assurance analytics. You will work closely with cross-functional partners and internal customers to consider opportunities for appropriate use of AI/ML methods to organize safety related data, and evaluate driving performance. You will engage deeply with other members of the AV Safety Engineering Analytics team, and stakeholders, to understand their challenges and needs, collaborate to develop solutions using your expertise in AI/ML. What You'll Do - Contribute to the development of data analytics infrastructure that supports safety assurance analytics addressing internal and external stakeholder needs across the phases of automated vehicle development and deployment, including both real-world and simulation data. - Apply your AI/ML expertise to developing trustworthy and explainable methods for validating the safety performance of an AI/ML based automated driving system. - Mentor and develop team members in the appropriate implementation of AI/ML to support the mission of the SAFE-ADS department and AV Safety Engineering Analytics team. - Pilot and develop metrics for monitoring of development operations and deployment, and establish sufficiency criteria for launch readiness. - Develop methods for leveraging a variety of internal and external data sources for AI/ML based safety monitoring and contribute to the development of a reliable supply chain of continuously flowing data from a variety of sources (internal and external) to support safety assurance related activities. - Implement cloud-based continuous up-time analytics solutions for monitoring driving performance for safety and generating browser based interactive visualizations and periodic reporting artifacts. - Actively contribute to determining appropriate use of AI/ML approaches within automated driving systems and provide technical expertise to inform leadership decision-making regarding mechanisms for ensuring they are trustworthy and explainable. - Through AI/ML expertise, contribute to the definition of GM's data sourcing and processing strategy for AV safety assurance needs, engage externally to influence evolving standards, and contribute to internal and external thought leadership that strengthens GM's position in the autonomous vehicle ecosystem. - Represent SAFE-ADS in AI/ML related discussions across Global Product Safety, Systems, and Certification activities. - Identify and drive opportunities to improve the efficiency, quality and transparency of safety analytics within GPSSC and across GM. Your Skills & Abilities (Required Qualifications) - Master's degree in Computer Science, Mechanical Engineering, Vehicle Engineering, Physics, or a related field; or equivalent practical experience focused on AI/ML - 10+ years of experience in large scale analyses of vehicle related data - 5+ years in safety-critical AI/ML systems in automotive engineering applications - Experience in the following: - Machine Learning & AI: Extensive experience in building large-scale models with significant focus on E2E validation. Experience using Large Language Models (LLMs), Generative AI, RAG, Deep learning, Reinforcement Learning, Natural Language Processing (NLP), SVM, XGBoost, Random Forest, Decision Trees, Clustering - AI Standards and Evolving Regulations: Understanding of ISO/PAS 8800, NIST AI Risk Management Framework, EU AI Act (2024-2027), other applicable industry standards and best practices for autonomous vehicles, aerospace and/or robotics. - Programming & Frameworks : Python, R, Java, PySpark, PyTorch, TensorFlow, Scikit-learn, LangChain, SQL - Cloud & Big Data: Experience in cloud-based large scale process including notifications, queuing, serverless cloud functions, event driven processing, code as infrastructure, containerization, process monitoring, process optimization, identity and access management, service to service access, etc. ( Microsoft Azure - Data Lake, Machine Learning, Databricks), (AWS - S3, SageMaker, Bedrock) or Google Cloud Platform (BigQuery, Dataflow, AI Platform) - Deployment & MLOps: CI/CD, MLflow, Model Monitoring & Versioning, Docker & Kubernetes, GitHub, Jira, Jenkins, Poetry, Terraform - Data Analysis & Visualization : Tableau, PowerBI, Plotly/Dash, Shiny, Pandas, NumPy - Proven track record providing technical leadership in AI/ML applied to safety-critical systems - Excellent communication and collaboration skills, with the ability to work effectively in a team environment - Strong problem-solving mindset and a proactive attitude towards learning and self-improvement What Will Give You A Competitive Edge (Preferred qualifications) - Record of involvement in public AI/ML related discourse through conference participation or publications. - Experience productionizing the use of AI/ML within the corporate setting. "Company Vehicle: Upon successful completion of a motor vehicle report review, you will be eligible to participate in a company vehicle evaluation program, through which you will be assigned a General Motors vehicle to drive and evaluate. Note: program participants are required to purchase/lease a qualifying GM vehicle every four years unless one of a limited number of exceptions applies." GM DOES NOT PROVIDE IMMIGRATION-RELATED SPONSORSHIP FOR THIS ROLE. DO NOT APPLY FOR THIS ROLE IF YOU WILL NEED GM IMMIGRATION SPONSORSHIP (e.g., H-1B, TN, STEM OPT, etc.) NOW OR IN THE FUTURE. This job is not eligible for relocation benefits. Any relocation costs would be the responsibility of the selected candidate. #LI-SA2 GM does not provide immigration-related sponsorship for this role. Do not apply for this role if you will need GM immigration sponsorship now or in the future. This includes direct company sponsorship, entry of GM as the immigration employer of record on a government form, and any work authorization requiring a written submission or other immigration support from the company (e.g., H1-B, OPT, STEM OPT, CPT, TN, J-1, etc.) This role is categorized as remote. This means the selected candidate may be based anywhere in the country of work and is not expected to report to a GM worksite unless directed by their manager. The selected candidate will be required to travel <25% for this role. This job is not eligible for relocation benefits. Any relocation costs would be the responsibility of the selected candidate. About GM Our vision is a world with Zero Crashes, Zero Emissions and Zero Congestion and we embrace the responsibility to lead the change that will make our world better, safer and more equitable for all. Why Join Us We believe we all must make a choice every day - individually and collectively - to drive meaningful change through our words, our deeds and our culture. Every day, we want every employee to feel they belong to one General Motors team. Total Rewards | Benefits Overview From day one, we're looking out for your well-being-at work and at home-so you can focus on realizing your ambitions. Learn how GM supports a rewarding career that rewards you personally by visiting Total Rewards resources. Non-Discrimination and Equal Employment Opportunities (U.S.) General Motors is committed to being a workplace that is not only free of unlawful discrimination, but one that genuinely fosters inclusion and belonging. We strongly believe that providing an inclusive workplace creates an environment in which our employees can thrive and develop better products for our customers. All employment decisions are made on a non-discriminatory basis without regard to sex, race, color, national origin, citizenship status, religion, age, disability, pregnancy or maternity status, sexual orientation, gender identity, status as a veteran or protected veteran, or any other similarly protected status in accordance with federal, state and local laws. We encourage interested candidates to review the key responsibilities and qualifications for each role and apply for any positions that match their skills and capabilities. Applicants in the recruitment process may be required, where applicable, to successfully complete a role-related assessment(s) and/or a pre-employment screening prior to beginning employment. To learn more, visit How we Hire. Accommodations General Motors offers opportunities to all job seekers including individuals with disabilities. If you need a reasonable accommodation to assist with your job search or application for employment, email us [email protected] or call us at 1-800-865-7580. In your email, please include a description of the specific accommodation you are requesting as well as the job title and requisition number of the position for which you are applying.

District of Columbia
Job Closed

Senior ETL Developer

Tria Federal

Tria Federal, founded in 2023, is a technology and advisory services firm specializing in digital transformation solutions for the federal sector. Guided by its commitment to servi

Who we are: Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow. We are proud to employ and support military veterans who bring mission-first mindset, technical expertise, and leadership qualities that strengthen our work. Veterans, transitioning service members, and military spouses are strongly encouraged to apply. Job Description: Softrams is seeking a strong Senior ETL Developer to join our collaborative and agile team delivering modern, mission-critical data solutions for U.S. federal government health IT programs. This role is central to designing, developing, and maintaining the data pipelines that power our analytics and reporting capabilities — extracting data from diverse sources, transforming it into consistent, reliable formats, and loading it into data warehouses and target systems. Operating within a SAFe Agile framework, the ETL Developer will work alongside data engineers, application developers, and business stakeholders to solve complex data challenges across large-scale Medicaid and Medicare programs. This role is ideal for a data professional who thrives in ambiguity, takes initiative in investigating and dissecting complex datasets, and is ready to own end-to-end pipeline development while contributing to broader data architecture decisions across a cloud-native AWS ecosystem. Basic Requirements: - 8+ years ETL / Data Pipeline Development (End-to-End) - 5 years of experience with Python & PySpark - Experience with AWS Glue & Data Lake Architecture (S3, EMR, LakeFormation) - 5+ years of strong PL/pgSQL or PL/SQL experience - 6+ years of experience with complex SQL — Data Extraction & Manipulation - 3+ years of experience with workflow Orchestration (Airflow, Prefect, NiFi or equivalent) - 3+ yeasrs of experience Cloud Data Warehousing (Snowflake, Redshift, or equivalent) - 3+ yeasrs of experience working in Agile/Scrum large-scale programs - Excellent written, verbal, and interpersonal communication skills - Strong time management skills with the ability to quickly triage and escalate issues - Strong attention to detail and a focus on task completion Responsibilities: - Analyze and understand complex business and engineering challenges to design effective data pipeline solutions - Design, develop, and maintain end-to-end ETL/ELT data pipelines using Python, PySpark, and AWS Glue - Build and manage data validation pipelines using Great Expectations or equivalent frameworks - Implement and maintain workflow orchestration using Apache Airflow, Prefect, Apache NiFi, or equivalent tools - Architect and operate Data Lake solutions in AWS, including S3, Glue, EMR, and Lake Formation - Write complex SQL queries for data extraction, transformation, and manipulation across multiple database systems - Collaborate with cross-functional teams including data engineers, application developers, and business stakeholders - Ensure data quality, reliability, and integrity across all pipeline stages - Contribute to data architecture decisions and promote best practices across the team Why Tria? What defines the Tria brand is more than just our dedication to excellence in our craft; it’s our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team’s shared success. As a company that cares about people, we seek to cultivate a culture in which all can thrive personally and professionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life. At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all. Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow. California Consumer Privacy Act (CCPA) We are committed to protecting your privacy. As part of our compliance with the California Consumer Privacy Act (CCPA), we want to inform you about how we collect, use, and protect your personal information during the job application process. For more details, please review https://www.oag.ca.gov/privacy/ccpa.

United States
Job Closed