Developing and maintaining data pipelines that ingest and post-process video streams, sensor data logs, and related metadata to be stored and used for ML model training, regression testing, and analysis. Collaborate with data platform developers to p Data Engineer, Engineer, Technology, Construction, Data, AWS

Role : Data Engineer(Only w2)Visa Types : USC AND GC ONLYLocation : Urbandale, IA(Hybrid)Minimum 8-10+ Years of Experience required. Qualifications:<ul><li>Proficiency in Azure cloud technologies, with expertise in Synapse, Azure Data Factory (ADF), Delta Lake, and Databricks, or equivalent experience with AWS, Snowflake, and/or GCP.</li><li>Deep understanding of data architecture principles, including Data Quality, Metadata Management, and Master Data Management (MDM).</li><li>Experience with dimensional data modeling and design, including developing Star Schemas and implementing data population techniques for target structures.</li><li>Advanced skills in PySpark and SQL for building robust, production-grade data pipelines and tools.</li><li>Familiarity with navigating modern data ecosystems, including hybrid environments integrating on-premises and cloud technologies.</li><li>Strong knowledge of CI/CD methodologies and best practices for seamless deployment and operation.</li><li>Proven experience working within Product Scrum Agile teams, ensuring alignment with agile principles and delivery practices.</li></ul> If I missed your call ! Please drop me a mail. Thank you,HarishTalent Acquisition Astir IT Solutions, Inc - An E-Verified CompanyEmail:harishj@astirit.comDirect : 7326946000*78850 Cragwood Rd. Suite # 219, South Plainfield, NJ 07080<a>www.astirit.com</a>

Company Details

Company URL: https://www.berkleytechnologyservices.com/

Berkley Technology Services (BTS) is the dynamic technology solution for W. R. Berkley Corporation, a Fortune 500 Commercial Lines Insurance Company. With key locations in Urbandale, IA and Wilmington, DE, BTS provides innovative and customer-focused IT solutions to the majority of WRBC’s 60+ operating units across the globe. BTS’s wide reach ensures that ideas and opinions are considered at every level of the organization to guarantee we find the best solutions possible.

Driven by a commitment to collaboration, BTS acts as consultants to our customers and Operating Units by providing comprehensive solutions that not only address the challenge at hand, but proactively plan for the “ What’s Next ” in our industry and beyond.

With a culture centered on innovation and entrepreneurial spirit, BTS stands as a community of technology leaders with eyes toward the future -- leaders who truly care about growing not only their team members, but themselves, and take pride in their employees who shine. BTS offers endless ways to get involved and have the chance to grow your career into a wide range of roles you'd never known existed. Come join us as we push forward into the future of industry leading technological solutions.

Berkley Technology Services: Right Team, Right Technology, Simple and Secure.

Responsibilities
Join Our Innovative Insurance Data Team!

We’re looking for a  Senior Data Engineer  with a deep understanding of insurance reporting and company operations. If you have a knack for mastering business data processes, system interfaces, and data structures, this is the role for you!

In this position, you’ll be tackling advanced tasks like ETL, cube creation, ad-hoc and management reporting, and crafting eye-catching dashboards and data extracts. You’ll be part of a vibrant team that supports multiple companies, providing top-notch data resources and development.

Your mission includes analyzing, designing, and coding innovative solutions for fast-growing companies in the Property & Casualty insurance industry. Get ready to make a big impact and have some fun along the way!

Design & Implement:  Create and manage ETL processes, data structures, and both analytical and operational reporting environments.

Innovate:  Develop new system functionalities with a focus on performance, stability, and supportability.

Lead by Example:  Apply industry best practices in modeling, workflow, and presentation.

Extract & Integrate:  Design and implement data extracts for both internal and external sources.

Organize & Communicate:  Utilize your strong organizational and communication skills to keep everything running smoothly.

Solve Problems:  Tackle challenges across application, middleware, and infrastructure levels with thorough impact analysis.

Set Standards:  Help define standards and design patterns for data processes and structures within the team.

Guide & Mentor:  Provide guidance on development standards and quality expectations, and mentor new team members.

Collaborate:  Communicate effectively with employees at all levels, both within the company and with clients.

Influence:  Develop a sphere of influence with other teams and foster a collaborative environment.

Be On Call:  Participate in on-call rotations to ensure smooth operations.

Travel:  Enjoy occasional travel, up to 20%.

Qualifications

SQL Maestro  :  7+ years of experience with SQL and ETL processes, including crafting queries, stored procedures, jobs, functions, synonyms, and aliases.  Experience with SQL Environments and variables, version control, and execution plans. Extensive experience with ETL tools (SSIS or similar) and optimizing performance.

Proven Performer:  Demonstrated ability to meet key accountabilities or the drive to learn and excel in them.

Passionate Go-Getter:  A self-motivated individual with an unyielding passion for success.

Impact Analyst:  Skilled at understanding how changes affect customers and other systems.

Communication Pro:  Excellent communication and organizational skills to keep everything on track.

Team Player and Mentor:  Thrives in a fast-paced team environment and loves to train and mentor junior staff on best practices and enhancing solution designs.

Tech Enthusiast:  Quick to adapt and eager to learn new technologies.

Independent Worker:  Capable of working independently with minimal supervision.

Customer Champion:  Strong focus on customer and business needs.

Behavioral Core Competencies

Technically Astute

Managing Information

Customer Service Oriented

Business Knowledge

Influential

Conceptual Thinking

The Company is an equal employment opportunity employer.

Job Description

This is a multi-level posting. Candidates may be considered for any of the posted levels, depending on their level of experience and depth of expertise.

Responsible for the design, implementation, maintenance and monitoring of database technologies and related software. Conducts analysis, creates system specifications, develops, tests and implements engineering, scientific and business applications, operating systems, and file/database servers. Utilizes existing or new technology in the automation of processes. Evaluates software packages and provides recommendations to management. Provides actionable recommendations for improvements in application performance after analyzing underlying database-related infrastructure components.

Responsibilities of this position include the following:

Designs, codes, tests documents, implements and maintains database utilities. (25%) Performs top expert-level database analysis and design reviews. (20%) Research and fact-finding to develop or modify database structures. (10%) Works with vendors to review quality, adaptability and compatibility of their products. (10%) Provides support for vendor-developed database implementation and periodic maintenance releases as required. (10%) Provides technical input to assist in development of project planning. (10%) Performs additional responsibilities as requested or assigned. (5%) Maintains RDBMS software at appropriate vendor-supported levels. (10%)

Responsibilities

Designs, codes, tests documents, implements and maintains database utilities.

Performs top expert-level database analysis and design reviews.

Research and fact-finding to develop or modify database structures.

Works with vendors to review quality, adaptability and compatibility of their products.

Provides support for vendor-developed database implementation and periodic maintenance releases as required.

Provides technical input to assist in development of project planning.

Performs additional responsibilities as requested or assigned.

Maintains RDBMS software at appropriate vendor-supported levels.

A strong understanding of database fundamentals.

Experience on Maximum Availability Architecture components like Oracle RAC, Oracle ASM, Oracle Grid Control, Oracle Data Guard & Oracle Goldengate.

Hand on experience with Database Upgrade/Migration

Preferred experience with CDB/PDB multitenant architecture (create, cloning, dropping, CDBs and PDBs).

Preferred experience with Database migration from conventional database to CDB/PDB multitenant architecture.

Preferred experience multiple Unix Flavors like AIX/SOLARIS/LINUX.

A knowledge of RMAN backup and recovery processes.

Qualifications

Bachelor's degree in information systems, computer science or related technical field or equivalent work experience. (Typically, four years of additional related, progressive work experience would be needed for candidates applying for this position who do not possess a bachelor's degree.) A minimum of two years additional direct related technical experience is required.

A minimum of two years related technical experience is required for the data engineer 2 level.

A minimum of four or more years related technical experience is required for the data engineer 3 level.

Seven or more years IT operation experience with strong understanding of database structures, theories, principles, and practices is required for the Sr data engineer level.

A strong understanding of database fundamentals

Experience on Maximum Availability Architecture components like Oracle RAC, Oracle ASM, Oracle Grid Control, Oracle Data Guard & Oracle Goldengate

Hand on experience with Database Upgrade/Migration

Preferred hands-on experience with CDB/PDB multitenant architecture (create, cloning, dropping, CDBs and PDBs),

Preferred hands-on experience with Database migration from conventional database to CDB/PDB multitenant architecture

Preferred Experience multiple Unix Flavors like AIX/SOLARIS/LINUX

A knowledge of RMAN backup and recovery processes

Proficiency in using SRVCTL and CRSCTL for listeners, adding databases, shutdown/startus

Experience using Oracle Enterprise Manager

Oracle Fleet Maintenance experience a plus

Experience on Exadata a plus

Position requires 24/7 production on call in a group rotation.

Night /weekend work required periodically for patching activities or similar.

Employees must be able to perform the essential functions of the position, with or without an accommodation.

We celebrate diversity, equity and inclusion, and we are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.

About Us

MidAmerican Energy Company, a Midwest utility, provides regulated electric and natural gas service to more than 1.6 million customers in Illinois, Iowa, Nebraska and South Dakota. The company owns and operates a portfolio of power-generating assets, approximately 61% of which is wind generation.

About the Team

At MidAmerican Energy Company, we celebrate diversity, equity and inclusion. MidAmerican Energy Company is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.

Data Engineer Jobs in Urbandale, IA

Data Engineer
December 17, 2024

Data Engineeronly W2
December 1, 2024

Senior Data Engineer
December 1, 2024

Data Engineer Database Administrator 2 3 Or Sr
November 23, 2024

Quick filters

Top companies

Data Engineer Jobs in Urbandale, IA

Data EngineerDecember 17, 2024

Data Engineeronly W2December 1, 2024

Senior Data EngineerDecember 1, 2024