Senior Marketing Database Analyst - Remote Job at Phenom People in Brooklyn

Data Warehouse Engineer At UnitedHealthcare, we're simplifying the health care experience, creating healthier communities and removing barriers to quality care. The work you do here impacts the lives of millions of people for the better. Come build the health care system of tomorrow, making it more responsive, affordable and equitable. Ready to make a difference? Join us and start doing your life's best work. UHC Analytics and Engagement Solutions (AES), is a team within the UnitedHealthcare Consumer Experience organization that drives business results through the management and use of consumer engagement technology and data-driven insights. Our vision is to use data and insights to design, orchestrate and maximize experiences that matter to consumers, clients, and health care professionals, resulting in enterprise strategic growth as well as a brand that people love. To support this vision, one of our goals is to evolve our analytic and data environments to improve speed of decisioning and to support higher velocity use cases. We are looking for someone who is passionate about complex data structures and problem-solving skills and someone who wants to come along for the ride and grow with us to support building a new data warehouse in the cloud and implement efficient and robust ETL/ELT processes. You will build data pipelines to ingest the data from heterogeneous sources into our system Hadoop/Azure/Snowflake. You should have excellent business and communication skills and be able to work with business owners to understand their data requirements using your data knowledge and experience. The job might also require you to learn new tools and technologies fast, and you should have knowledge in database concepts, ETL concepts, solid data querying, and debugging skills. You will help maintain and support data pipelines using Azure Data Factory and Snowflake. You will also be responsible for monitoring the data pipeline using cloud-based tools, testing, and clearly documenting the implementations. You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. Primary Responsibilities:

• Contribute in the monitoring of data interfaces supporting enterprise operations, reporting and analytics
• Interact with technical and non-technical customers to understand requirements and implement relevant data solutions
• Proactively and continuously identify, evaluate, and recommend integration and delivery process improvements
• Provide inputs in designing, implementing, and automating analytics warehouse data flows
• Developing ETL pipelines and data flows in and out of the data warehouse using a combination of Azure Data Factory and Snowflake toolsets
• Developing idempotent ETL process design so that interrupted, incomplete, or failed processes can be rerun without errors using ADF dataflows and Pipelines
• Ability to work in Snowflake Virtual Warehouses as needed in Snowflake and automate data pipelines using Snowpipe
• Capturing changes in data dimensions and maintaining versions of them using Stream sets in snowflake and scheduling them using Tasks
• Optimize data movement steps not only limited to source and during travel, but also when it's at rest in the database for accelerated responses
• Build schedule jobs, execute workflows, and perform Data quality checks, coordinating dependencies among tasks
• Assist in testing of ETL system code, data design, and pipelines and data flows. Participate in Root cause analysis on all processes and resolving production issues are also a part of the process and routine tests on databases and data flow and pipeline testing
• Assist in the execution of test cases for deployment needs

Required Qualifications:

• 1+ years of experience in data warehousing concepts, ETL concepts, and working with ETL/Data quality tools on any ETL platform
• 1+ years of experience in writing complex SQL queries, and performance tuning
• 1+ years of experience with Microsoft Azure cloud services and data warehouse environment
• 1+ years of experience with building, deploying, and troubleshooting data extraction and loading pipelines (ETL) using Azure Data Factory (ADF)
• 1+ years of experience analyzing and executing data profiles

Preferred Qualifications:

• Azure or Snowflake Certification in database and data engineer roles
• 1+ years of experience developing a data solution on Snowflake Data Warehouse using snowflake continuous data pipelines with Snowpipe, Streams and Tasks
• 1+ years of experience working with databricks
• 1+ years of experience with Adobe CJA (Consumer Journey Analytics) or Adobe Campaign
• 1+ year of experience working with healthcare data
• Experience Python programming language
• Experience with Unica Campaign and Interact
• Experience is working with offshore teams (India etc.)

Careers with UnitedHealthcare. Work with a Fortune 5 organization that's serving millions of people as we transform health care with bold ideas. Bring your energy for driving change for the better. Help us improve health access and outcomes for everyone, as we work to advance health equity, connecting people with the care they need to feel their best. As an industry leader, our commitment to improving lives is second to none. California, Colorado, Connecticut, Nevada, New York, Rhode Island, or Washington Residents Only: The salary range for California, Colorado, Connecticut, Nevada, New York, Rhode Island or Washington residents is $67,800 to $133,100. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives. • All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission. Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.