Title: Data Engineer
Location: Orange, CA (Remote. Must work 9:00 a.m. to 2:00 p.m. PT. and can flex start/end times around this).
Duration: 6 months + w/potential temp to perm
Description: We are seeking qualified candidates to join us in an enterprise-wide analytics initiative to help drive incremental business value from our broad range of data assets.
POSITION SUMMARY:
Data Engineers and researchers are responsible to develop innovative data driven solutions that integrate distributed sources of data, perform large scale learning and reasoning, and integrate results in collaborative environments to support the business analytics and data provisioning needs of the enterprise. They must have a good understanding of data access requirements for business analytics and exploration. Also required are analytical skills, the ability to establish and maintain effective working relationships with team members, as well as an innate curiosity around wanting to understand business processes, business strategy and strategic business initiatives to help drive incremental business value from enterprise data assets.
PRIMARY DUTIES AND RESPONSIBILITIES:
- Works with other team members and business stakeholders on complex projects and tasks to drive development of business analytics requirements and synthesize these into data integration and enterprise data access requirements that communicate a coherent message.
- Works with data visualization specialists to facilitate technical design of complex data sourcing, transformation and aggregation logic ensuring business analytics requirements are met.
- Drives development and adoption of and adherence to data engineering standards using best practice methods and techniques.
- Provides support in execution and delivery of business reporting.
- Leads small project teams or work streams.
EXPERIENCE AND EDUCATIONAL REQUIREMENTS:
Requires Bachelor’s Degree in Computer Science, Business Administration or a related field; requires 5+ years of responsible experience in developing business solutions. The experience should be with requirements gathering, SQL, Data Integration tools such as Informatica PowerCenter, Microsoft SSIS, Azure ADF and Data Warehousing techniques.
MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:
- 5+ years of experience developing BI/DW solutions in Informatica PowerCenter or similar tools like IICS, Microsoft ADF, Apache Spark, Talend, but not limited to architecture design/development with the ability to resolve issues quickly and efficiently.
- 5+ years of using Structured Query Language (SQL).
- Knowledge and exposures to Azure SQL Data Warehouse, Databricks or other cloud or on premises MPP data warehousing systems (SAP HANA, Teradata, Snowflake).
- Experience with Data Lake implementations and design patterns.
- Experience in using and tuning relational databases (MS SQL Server, Oracle, MySQL).
- Experience with Lambda and Kappa architecture implementations is a plus.
- Knowledge of Test Driven Development, Continuous Integration, Agile/Scrum.
- Experience with code versioning tools such as GitHub, Jenkins, etc., and a command of configuration management concepts and tools.
- Demonstrated ability to quickly learn and adapt to new technologies and coding techniques.
- Experience designing, developing and testing applications using proven or emerging technologies, in a variety of technologies and environments.
- Knowledge in cloud resource provisioning and management on Azure and/or AWS is a plus.
- Familiar with Streaming and with streaming concepts and patterns is a plus.
- Scientific computing experience (R, MATLAB, Python, etc.) is a plus.
- Motivated quick learner presenting a positive energetic and professional image able to work in a fast-paced, collaborative, and project-oriented environment.
- Strong interpersonal and analytical skills including the ability to communicate effectively both verbally and in writing.
- Good knowledge of Microsoft Word, Excel, Power Point and Outlook.
- Some prior exposure to pharmaceutical distribution/health care services industry desired.
- Ability to lead other Data Engineers on small projects initiatives.
- Ensures that data is clean, consistent, and synchronized across platforms as needed.
- Oversees the design and implementation of data cleansing procedures.
- Leads the identification of areas affecting data integrity and coordinates corrective actions.
- Develops solutions and recommendations for improving data integrity issues.
- Analyzes data issues and works with development teams for problem resolutions.
- Ensures that physical models align with the logical data model.
- Reviews and approves logical data models.