Icon hamburger
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply on company site

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.

Data Warehouse Developer II

Broadbean Technology 19800 MacArthur blvd, Irvine, CA 92612 Full-Time
Apply on company site

The BIDW Developer II is knowledgeable in one or more specific areas of development in Data Warehousing, Business Intelligence (BI) Team Services, and Data Analysis. This position focuses research, development and delivery of business intelligent and analytical solutions including: dashboards, reports, user interfaces, associated data structures and analytical data models using various DB tools including: AWS Glue, Athena, MySQL, Pentaho, PostgreSQL, Google BigQuery, and Tableau. The BIDW Developer II interfaces with business users to understand their needs and then translates them into solutions which deliver business value. A BIDW Developer II posseses the necessary skills to produce quality scalable solutions but still requires some oversight.

Job Duties and Responsibilities
* Develop data movement processes utilizing Extract, Transform, and Load tools and methodologies
* Analyze source data structures in order to design ETL processes and data warehouse data structures
* Use standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work
* Work cooperatively with others to resolve data and process issues
* Work with non-technical subject matter experts to understand underlying data behavior and characteristics
* Develop complex queries to solve data mining problems
* Write reliable and efficient programs scaled for large datasets
* Create and maintain thorough documentation for data dictionaries & formulas
* Design analytical reports in Tableau to present KPI's to business leadership
* Work closely with data modelers, business data analysts, and BI developers to understand requirements, develop ETL processes, validate results, and deliver to production
* Analyze and improve efficiency, scalability, and stability of data collection, extraction, and storage processes

* Bachelor's Degree in Computer Science or related field
* 2-5 years ETL development/data warehouse experience
* High level of proficiency in SQL, python, data warehousing, and database optimization
* Familiarity with developing ETL processes using AWS Glue, Athena, Lambda, and S3
* Experience developing in Apache Spark utilizing python pyspark
* Experience with ETL tools and logging ETL metrics in a framework. Kettle/PDI, the Pentaho ETL product preferred
* Must understand the full concept of Extract, Transform and Load (ETL) development, dimensional data modeling, database stored procedures, data analysis, and database development experience. Must also have experience writing complex stored procedures and scheduling batch jobs
* Experience working in an Unix/Linux operating system
* Familiarity with business intelligence tools such as with Tableau, Qlik, Business Objects, SSRS or Cognos is highly desirable
* Clear understanding of RDBMS fundamentals
* Understands data profiling and data analytics
* Very detail oriented and quality focused. Able to follow clear methodologies for troubleshooting and development

Essential Functions
* Requires the ability to communicate precisely and effectively, both orally and in writing
* Requires problem resolution and critical thinking skills
* Requires the ability to view and read from computer screens for an extended period of time and interpret complex text and/or data files
* Requires the ability to understand and interpret data, reports, etc
* Requires reasoning, negotiating, instructing, persuading, or speaking with others and the ability respond appropriately to constructive feedback from executive management
* Requires the ability to relate to others beyond giving and receiving instructions; must partner with colleagues without exhibiting behavioral extremes

Apply to this job.
Think you're the perfect candidate?
Apply on company site

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

Job ID: 1480/12708


For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

We’re a mid-sized company and renowned leaders in our space. We’re over 12 years old yet still get a massive kick out of creating award winning products and improving recruitment processes. With a reputation for being passionate about our business while delivering results, we work hard to maintain our excellent relationships with technology vendors, the major recruitment channels and, of course, our clients - wherever they are in the world.

We’re incredibly proud of our software, but we’re even more proud of our staff. That’s because our success has been built on technical innovation, great customer service and listening to clients. These three qualities have allowed us to continually grow our revenue, invest in our team and develop products that far surpass others in the market.

View the full profile