Data Integration Engineer

7 days ago

Costa Mesa, United States orangepeople Full time

We are looking for our next extraordinary Data Engineer to level up the Enterprise Information Management Team. The Data Engineer is a hybrid business-technical role within the Enterprise Information Management organization responsible for partnering with business and technical stakeholders to plan the delivery of data solutions including design, development, enhancement to ELT/ETL processes and components of data pipelines to support analysis, reporting, analytics, and data science. The role will focus on having a mindset of data quality, governance, and pipeline performance to ensure data integrity and information usability for internal decision-making.

If you’re a hands-on professional in data architecture, data engineering, traditional and/or modern data warehousing, ELT/ETL, and/or big data pipeline and processing, you’re exactly who we’re seeking. Technical capabilities aside, if you’re a self-starter with excellent problem-solving skills, enjoy developing creative solutions, thrive in a fast-paced environment, and deliver work effectively both independently and as part of a team, you’re a perfect fit for our team.

Requirements:

  • Partner with appropriate stakeholders to consult and recommend requirements to design, develop, test, and update data integration (this includes but is not limited to ELT/ETL processes/pipelines, stored procedures, views, and functions), and data profiling processes.
  • Create, validate, and/or update source-to-target maps, assist with logical and physical model design, and update and maintain metadata repositories/dictionaries.
  • Plan and support identification of physical implementation requirements, including normalization/dimensional techniques and referential integrity.
  • Partner with stakeholders to lead code reviews, data model reviews, and testing.
  • Collaborate with IT partners to perform periodic system and database operational tests, audits, and tuning.
  • Lead the collaboration with analysts, data scientists, and business teams to recommend and improve data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision-making across the organization.
  • Proactively provide and contribute by leading the efforts to define areas of opportunities to catalog, maintain, and enforce data architecture, definitions, and standards.
  • Provide recommendations for data policy, standards, and procedure development processes.
  • Focus on data quality-detect data/analytics quality issues all the way down to the root cause, and implement fixes including data audits to prevent/capture such issues.
  • Ensure high data quality and availability by partnering with stakeholders from the infrastructure, network, database, application, and business intelligence teams to identify the lifecycle of data to consult/recommend process changes to implement.

Qualifications:

  • Bachelor's Degree or higher in Computer Science, Information Management, Engineering, or a related field.
  • 5+ years demonstrated strength in ELT/ETL, data services, data pipelines, data modeling (OLTP, 3/NF, dimensional), data lake, cloud warehouse technical architecture, infrastructure components, and reporting/analytic tools.
  • 5+ years development with ETL tools (AWS Glue, dbt Labs, Talend/Stitch, Informatica, Fivetran, Matillion, or similar) including distributed architectures (Microservices, SOA, and RESTful APIs).
  • 3+ years of development with scripting languages Python, R, C#.NET, Java, or JavaScript.
  • 3+ years of AWS services such as Redshift, Aurora, Dynamo, Glue, S3, EMR, Lambda, Kinesis, and SNS/SQS.
  • Experienced with development and modeling for columnar storage and massively parallel processing data warehouses (Hadoop, Snowflake, Redshift) with a keen sense to optimize for scalability, availability, security, cost, and performance.
  • Experienced with big data processing technologies (Spark, Storm, Kafka, Flume, Pig, Hive, Sqoop, Hadoop/MapReduce, etc.).
  • Experienced with automation frameworks/tools (Git/Bit, CI/CD, Jenkins, Ansible, and Terraform, etc.).
  • A product-focused mindset with the ability to understand business requirements to architect systems that will scale and extend to accommodate those needs.
  • Ability to work through a problem logically, identify root causes, and provide practical effective solutions while being detail and process-oriented.
  • Excellent written, visual, and oral communication skills, ability to communicate with key business and/or technical partners clearly and succinctly.
  • Proven ability to inspire confidence, create executive presentations, effectively present information, and guide strategic discussions.
  • A self-starter who can work without continuous supervision and is highly organized.

Benefits:

  • 401(k).
  • Dental Insurance.
  • Health insurance.
  • Vision insurance.
  • We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people.
  • The salary will be determined based on several factors including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.


Additional Responsibilities:

  • Participate in OrangePeople monthly team meetings, and participate in team-building efforts.
  • Contribute to OrangePeople technical discussions, peer reviews, etc.
  • Contribute content and collaborate via the OP-Wiki/Knowledge Base.
  • Provide status reports to OP Account Management as requested.


About us:

OrangePeople is an Enterprise Architecture and Project Management solutions company. Our most valuable asset is our people: dynamic, creative thinkers, who are passionate about doing quality work. As a member of the OrangePeople team, you will have access to industry-leading consulting practices, strategies & and technologies, innovative training & and education. An ideal Orange Person is a technology leader with a proven track record of technical achievements and a strong process/methodology orientation.

  • Data Integration Engineer

    2 weeks ago

    Costa Mesa, United States Orangepeople Full time

    Job DescriptionJob DescriptionWe are looking for our next extraordinary Data Engineer to level up the Enterprise Information Management Team. The Data Engineer is a hybrid business-technical role within the Enterprise Information Management organization responsible for partnering with business and technical stakeholders to plan the delivery of data solutions...

  • Data Integration Engineer

    2 weeks ago

    Costa Mesa, United States Orangepeople Full time

    Job DescriptionJob DescriptionWe are looking for our next extraordinary Data Engineer to level up the Enterprise Information Management Team. The Data Engineer is a hybrid business-technical role within the Enterprise Information Management organization responsible for partnering with business and technical stakeholders to plan the delivery of data solutions...

  • Data Integration Engineer

    1 week ago

    Costa Mesa, United States OrangePeople Full time

    We are looking for our next extraordinary Data Engineer to level up the Enterprise Information Management Team. The Data Engineer is a hybrid business-technical role within the Enterprise Information Management organization responsible for partnering with business and technical stakeholders to plan the delivery of data solutions including design,...

  • Data Integration Engineer

    2 weeks ago

    Costa Mesa, United States orangepeople Full time

    We are looking for our next extraordinary Data Engineer to level up the Enterprise Information Management Team. The Data Engineer is a hybrid business-technical role within the Enterprise Information Management organization responsible for partnering with business and technical stakeholders to plan the delivery of data solutions including design,...

  • Data Engineer IV

    3 weeks ago

    Costa Mesa, United States eTeam Inc Full time

    Duties: • Maintain and evolve our lake-house architecture, including refinement around scalability, optimizing ongoing data delivery around web/mobile customer experience, expectations, and ongoing growth of data sources • Build required infrastructure for ETL of data from various disparate sources using AWS and SQL technologies • Familiarity and...

  • Data Engineer IV

    2 months ago

    Costa Mesa, United States eTeam Inc Full time

    Duties: • Maintain and evolve our lake-house architecture, including refinement around scalability, optimizing ongoing data delivery around web/mobile customer experience, expectations, and ongoing growth of data sources • Build required infrastructure for ETL of data from various disparate sources using AWS and SQL technologies • Familiarity and...

  • Senior Cloud Data Platform Engineer

    1 week ago

    Costa Mesa, California, United States Mantek Solutions Full time

    Job DescriptionJob DescriptionSr Cloud Data Platform Engineer - Hybrid Remote, Costa Mesa, CAIf you are passionate about making an impact utilizing cutting-edge data technology and eager to learn and grow with talented data & analytics teams, we believe you would be a great fit and help in innovation and solving challenges. Responsibilities: Design, deploy,...

  • Associate Data Engineer

    2 weeks ago

    Costa Mesa, United States The Auto Club Group Full time

    Work on developing solutions to support our digital data technology challenges and needs. Our teams success isnt just implementing the code but seeing that the data solutions we develop enable stakeholders to gain insights and have the necessary to Data Engineer, Associate, Engineer, Business, Technology, Insurance, Data, Solutions

  • Senior Cloud Data Platform Engineer

    2 weeks ago

    Costa Mesa, United States Mantek Solutions Full time

    Job DescriptionJob DescriptionSr Cloud Data Platform Engineer - Hybrid Remote, Costa Mesa, CAIf you are passionate about making an impact utilizing cutting-edge data technology and eager to learn and grow with talented data & analytics teams, we believe you would be a great fit and help in innovation and solving challenges. Responsibilities: Design, deploy,...

  • Data Ops Engineer

    2 weeks ago

    Costa Mesa, United States orangepeople Full time

    Are you passionate about harnessing the power of data to drive strategic business decisions? Do you thrive on designing and implementing cutting-edge data solutions that transform raw information into actionable insights? If so, we have an exciting opportunity for you as a Data Ops/Solution Architect. If you are a forward-thinking individual who is...

  • Sr Data Engineer

    3 days ago

    Costa Mesa, United States TEKsystems Full time

    Description: Senior Data Engineer is responsible for design, develop and support ETL data pipelines solutions primary in AWS environment • Design, develop, and maintain scaled ETL process to deliver meaningful insights from large and complicated data sets. • Play key role in building out a semantic layer through development of ETLs and virtualized...

  • Data Center Technician L1

    1 week ago

    Mesa, United States NTT DATA Full time

    Job Description Want to be a part of our team?The Data Center Technician provides a working level of data center knowledge and is responsible for the operational integrity and regulatory compliance of the data center electrical, mechanical, and fire life safety systems. The Data Center Technician maintains and follows the processes that maximize customer...

  • Analyst II, Data Modeling

    2 weeks ago

    Costa Mesa, United States QSC Full time

    Analyst II, Data Modeling Job ID 2024-4359 Job Locations US-Remote Category Strategy Type Regular Full-Time Overview QSC is actively seeking a lead analytics engineer to enable the evolution and integration of our business data with strategic initiatives, overall enabling and accelerating...

  • Data Architect

    3 days ago

    Costa Mesa, United States Mint Mobile Full time

    **MINT MOBILE** **is seeking a talented **_Data Architect_** to join the **_Office of Enterprise Information Management_** **_Team_**! Individual reports to the **_Director, Data Architecture._** Role is **_remote;_**_ must reside in the United States._** **ABOUT THE ROLE** The Data Architect is a senior Subject Matter Expert (SME) role within our Data...

  • Data Center Technician L1

    1 month ago

    Mesa, United States NTT DATA Full time

    Job Description NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future.In today’s ‘iNTTerconnected’ world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our...

  • Data Center Technician L1

    3 weeks ago

    Mesa, United States NTT DATA Full time

    Job Description NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future.In today’s ‘iNTTerconnected’ world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our...

  • Data Center Technician L1

    2 weeks ago

    Mesa, United States NTT DATA Full time

    Job Description NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future.In today’s ‘iNTTerconnected’ world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our...

  • Data Center Technician L1

    3 weeks ago

    Mesa, United States NTT DATA Full time

    Job Description NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future.In today’s ‘iNTTerconnected’ world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our...

  • Data Center Technician L1

    5 days ago

    Mesa, United States NTT DATA Full time

    Job Description Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it’s a place where you can grow, belong and thrive.Your day at NTT...

  • Data Center Technician L1

    3 days ago

    Mesa, United States NTT DATA Full time

    Job Description Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it’s a place where you can grow, belong and thrive.Your day at NTT...