Data warehouse developer job description

+ Department: HCV Business Analytic O

Engagement Description: - Responsible for leading complex projects and independently executing analyses that support the healthcare value portfolio either individually or within a workgroup. - Translates results into answers for healthcare business questions and applies a strong understanding of healthcare industry when creating those solutions. - Partners effectively outside of the business team to prosecute work. - Works closely with team members to fully specify the research question and source associated data required. - Executes work efficiently, bringing forward process enhancements with a continuous improvement mindset. Top 3 Required Skills/Experience:

+ - Minimum 6 years' experience in Advanced Data Analytics.

+ - Proficient in advanced functions in SQL.

+ - Expertise in data warehousing and data mining concepts including but not limited to ETL, DataMart design, fact tables, dimension tables, data views within data marts/data warehouses, data models such as star schemas and snowflake schemas.

Required Skills/Experience - The rest of the required skills/experience. Include: - Experience with big data tools: Hadoop, Spark, and scripting languages: Python or Scala - Solid working knowledge of Microsoft tools and software (i.e., Excel, Visio, Access, PowerPoint) - Ability to recognize data patterns, quantify potential issues and identify solutions. Ability to standardize, harmonize, clean, prepare and use data for developing datasets, reporting and analysis. - Assemble large, complex data sets that meet functional / non-functional business requirements. - Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions Preferred Skills/Experience - Optional but preferred skills/experience. Include: - Healthcare Experience Education/Certifications - Include:

+ Bachelor's Degree in computer science, Information Systems, Business, Mathematics, Healthcare Information Technology or similar degree required. Master's Degree preferred.

Works closely with clients, business analysts and team members to understand the business requirements that drive the analysis and design of quality technical solutions. These solutions must be aligned with business and IT strategies and are in compliance with the organization's architectural standards. Application Developers are involved in the full systems life cycle and therefore are responsible for designing, coding, testing, implementing and supporting application software that is delivered on time and within budget. Responsibilities beyond development of software may include participation in component and data architecture design, technology planning, product evaluation, advanced testing processes and buy vs. build recommendations. Individuals also provide input to project plans related to the Application Development initiative. Application Developers have a strong knowledge of programming languages used by the organization. They have experience in systems design and have a solid understanding of development, database development, testing, and integration methodologies. Knowledge of current and emerging IT products, services and processes is required. Work Complexity - Works on major projects as a project team member, sometimes as a project lead. - Works on projects that may span a broad range of applications. - Supports multiple applications. - Expertise in multiple technical environments and possesses business knowledge that spans one or more business areas. Education/ Experience - Bachelor's degree in related field preferred. - 5 years of application programming and analysis experience required. - Has a broad level of understanding surrounding information systems and application architecture standards. - Demonstrated ability to analyze and interpret complex problems or processes that span multiple business areas, identify and understand requirements, and develop alternate solutions. - Experience designing, developing and testing applications using proven or emerging technologies. As an equal opportunity employer, ICONMA prides itself on creating an employment environment that supports and encourages the abilities of all persons regardless of race, color, gender, age, sexual orientation, citizenship, or disability.

Are you inspired by “what's next”? So are we.

When you join the Albemarle team, you contribute to a better tomorrow. You will play a role in powering many of the world's largest and most critical industries, from energy and communications to transportation and electronics. We are putting innovation to work to improve people's lives and we want YOU to be a part of it.

Job Description

The Data Science - Python/Azure Developer is a new and critical role in the Lithium Data Science team.

In this role, you will develop Azure-hosted python applications that guide Albemarle product, research, and investment decisions. You will partner with data scientists to develop effective, scalable code and models that answer strategic questions. You will support leaders across Product Management, Sales, R&D, Manufacturing, & Finance with tools to understand market dynamics, compare scenarios, and make decisions.

This role includes, but is not limited to the following duties:
Develop effective and scalable python code Create applications for the Lithium Data Science Suite that demonstrate full stack data science skills with a focus on back-end development and support Communicate insights and recommendations clearly and visually Work with an array of complex and unstructured internal and external data sources Work on a team to create comprehensive models that identify, analyze, and forecast key metrics across the lithium supply chain
Education
BS/MS in Computer Science or Related Field
Experience
Required:
3-6 years of work experience Intermediate or greater Python experience Intermediate or greater Azure experience Experience with version control (Github preferred) Innovative thinker with an interest and ability to learn new tools/techniques and apply themA demonstrated ability to communicate progress and result in a clear and concise manner Experience using data and models to make strategic recommendations Working on a team, including co-development of models and results

Preferred:
Plotly, Dash, and/or Dash EnterpriseDatabase/Cloud (Databricks, Spark, SQL, SAP HANA) Front-end development (HTML, CSS, JavaScript, Bootstrap, etc) Experience in market research/intelligence, forecasting, chemical engineering, and/or energy storage

Choose to unlock your full POTENTIAL. Apply today.

What's the secret to our success here at GEICO? It's actually no secret at all; we simply find and invest in good people. That's why we're looking for an innovative and talented developers to join our Data & Analytics team!

As a Data & Analytics (D&A) Developer you'll develop robust data structures, reports, and visualizations to support analysis, identify insights, and drive business decisions. You will work closely with Business Partners, Engineers, Data Architects, and Data Governance. Responsibilities include assisting with translating business requirements into technical specifications, documenting code, data definitions, reporting metrics, serving as data stewards for assigned areas, researching and implementing software, services and platforms to enable business analysis, and creating plans for project tasks.
Well-qualified candidates have the following qualifications:

* Strong SQL skills (beyond writing queries) and experience owning, managing, maintaining, and updating databases.
* Experience building and troubleshooting data structures within Snowflake to support analytics
* A history of several completed projects demonstrating experience building dashboards with Power BI
* Experience transforming data with DBT
* Curiosity with exceptional aptitude for learning and self-development
* Excellent communication skills and the ability to negotiate appropriate deadlines with management and teammates

The following skills may also be helpful to you in this position and considered a "plus" in this role:

* Prior experience in a role translating high-level business questions into technical reporting requirements
* Experience designing and building Salesforce Lightning reports
* Experience with Python
* Experience with Power Automate and other Power Platform apps
* Experience in other analytics roles, including statistical analysis and AI/ML applications

Benefits:

At GEICO, we make sure you have the support and resources to leverage and develop your skills, secure your financial future, and take care of your health and well-being. GEICO continually seeks to provide a workplace where everyone can be their authentic self. To help achieve this goal, we support associate-led Employee Resource Groups that foster a true sense of community. Through GEICO's competitive benefits offerings and various training and development opportunities, we have you covered with our Total Rewards Program* that includes:

* Premier Medical, Dental and Vision Insurance with no waiting period
* Paid Vacation, Sick and Parental Leave
* 401(k) Plan
* Tuition Assistance including Direct Billing and Reimbursement payment plan options
* Paid Training, Licensures, and Certificates
* Benefits may be different by location. Benefit eligibility requirements vary and may include length of service.

Coverage begins on date of hire. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect.

GEICO is proud to be an equal opportunity employer. We are committed to cultivating an environment where equal employment opportunities are available to all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO celebrates diversity and believes it is critical to our success. As such, we are committed to recruit, develop and retain the most talented individuals to join our team.

GEICO also provides a work environment in which each associate is able to be productive and work to the best of their ability. We do not condone or tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.

#LI-BN1