OFallonRecruiter Since 2001
the smart solution for O'Fallon jobs

BI Architect II (Data Integration/ETL)

Company: SPECTRUM
Location: O Fallon
Posted on: October 11, 2020

Job Description:

JOB SUMMARY

This position is responsible for creating solution blueprints, high-level design and implementation strategies, logical and physical data models for end-to-end business intelligence and data warehousing solutions.

MAJOR DUTIES AND RESPONSIBILITIES

Work in collaboration with BI delivery team leaders, business analysts and business leaders to understand business requirements and end user?s needs

Translate business requirements and end user?s needs into architecture blueprints that deliver cost effective & high performing, high quality BI solutions in compliance with Charter standards, policies and long-term technical strategies

Design, develop, manage and update logical and physical data models) for the BI data marts

Work with IT partners to review the upstream data warehouse data models and assess/mitigate the impact on BI side

Communicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers and BI developers

Work with DBAs to migrate schema changes between development, QA and production environments

Provide architectural expertise, thought leadership, direction, and assistance across entire BI organization

Design and build reusable utilities to aid data warehousing processes

Present proposed solution blueprints to the Architecture Review Board. Communicate solution blueprints to other project team members, business users and program sponsors

Participate in Architecture Review Board meetings. Review solutions presented by other BI architects and provide constructive feedback

Assist Project Managers and BI delivery team leaders in estimating effort and resources for new projects and enhancement requests

Engage with IT teams such as Data Management, DBAs, Security, Storage and Networking when their involvement is required to meet the project needs

Participate in capacity planning for all layers in the BI technology stack

Help solve complex production issues spanning multiple tiers in the BI/DW technology stack

Stay current in new BI /DW technologies, evaluate them and make adoption recommendations

Participate in developing and documenting technical standards and best practices for the BI organization

Perform other duties as requested

REQUIRED QUALIFICATIONS

Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)

Experience in logical and physical database design for data warehousing (3NF/Star Schemas) including SQL writing/tuning on MPP platforms such as Teradata and/or Netezza

Proven ability to quickly grasp business requirements and translate them into optimized solution blueprints

Strong problem solving, collaboration and communication skills Passion for leveraging data to improve business outcomes

Experience in developing roadmaps for BI Architecture discipline

Experience in developing and implementing complex data warehouse and BI solutions

UNIX Scripting and python development experience

Complete understanding of various data connectors for all major databases and ability to use them natively

PREFERRED QUALIFICATIONS

Experience working with AWS or other cloud platform big data tools such as Elastic Map Reduce (EMR), S3, Redshift, snowflake.

Experience working with bash scripting and the AWS CLI in Linux-based systems

Experience in Hadoop ecosystem including HDFS, HIVE, Sqoop, Spark, PySpark

Advanced data souring mechanism include CDC (IBM IDR) and Kafka

Certification on Teradata and/or MicroStrategy is a plus

Experience in cable or another telecommunications service provider is a plus

Familiarity with Agile development methodologies such as Scrum, Kanban and SAFe

Education

Bachelor?s degree or foreign equivalent in Economics, Mathematics, Computer Science; or equivalent training, education and experience

Master?s degree preferred

Related Work Experience Number of Years

Architect in large-scale, complex BI/DW environments, with

numerous data sources 5+

Erwin Data Modeler, ER/Studio or similar data modeling tools 3+

ELT/SQL Development on Teradata or similar MPP database platform 2+

ETL platforms such as Informatica, Ab-initio or Data Stage 2+

BI reporting/OLAP platforms such as

MicroStrategy (preferred), Cognos, Business Objects 2+

Cloud Data Architecture 1+

WORKING CONDITIONS

Office environment

Travel - 10%.

Keywords: SPECTRUM, O'Fallon , BI Architect II (Data Integration/ETL), Other , O Fallon, Missouri

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Warehouse Pro - FedEx Ground
Description: Auto req ID: 253207BRJob SummaryFedEx Ground is an essential business that needs people to help us support the economy, handling life-saving medications and other items that keep our communities as prepared (more...)
Company: FedEx Ground PH US
Location: Saint Peters
Posted on: 10/21/2020

Owner Operator, CDL-A Step Deck Driver: Same Day Pay
Description: CDL-A OTR Owner Operator Truck Driver Qualifications: 23 years of age 1 year of verifiable OTR/regional experience in the last 3 years Must have 6 months of open deck experience in the
Company: Bennett Motor Express
Location: Saint Peters
Posted on: 10/21/2020

Delivery Driver - Weekly Pay
Description: Deliver with Uber. Earn on your schedule. 10 Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekendsit 38 039 s up to you. 10 Earn Good Money. Youll earn by (more...)
Company: Uber Eats
Location: Saint Peters
Posted on: 10/21/2020


Earn more this Fall, deliver with Uber Eats
Description: Deliver with Uber. Earn on your schedule. 10 Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekendsit 38 039 s up to you. 10 Earn Good Money. Youll earn by (more...)
Company: Uber Eats
Location: Saint Peters
Posted on: 10/21/2020

CDL A TRUCK DRIVERS! Average $70,000 Annually! ONLINE AT-HOME ORIENTATION!
Description: CDL A TRUCK DRIVERS Average 70,000 Annually Kottke is family owned and operated by former truck drivers. Since 1938, Kottke has prided itself in knowing that there is nothing
Company: Kottke Trucking, Inc.
Location: Saint Peters
Posted on: 10/21/2020

Warehousing Worker
Description: Auto req ID: 253207BR Job Summary FedEx Ground is an essential business that needs people to help us support the economy, handling life-saving medications and other items that keep our communities as (more...)
Company: FedEx
Location: Saint Peters
Posted on: 10/21/2020

MERCHANDISING
Description: Job Description 10 Merchandising Execution Associates: All Merchandising Execution Associates MEAs perform in-store merchandising service activities such as merchandising projects, planogram maintenance, (more...)
Company: The Home Depot
Location: Saint Peters
Posted on: 10/21/2020

Med/Surg RN - Virtual Hiring Event
Description: BJC HealthCare is one of the largest nonprofit health care organizations in the United States, and is focused on delivering services to residents
Company: BJC HealthCare
Location: Saint Peters
Posted on: 10/21/2020

Registered Nurse, Cardiac Cath Lab
Description: Job Description: Additional Job Information 36 Hours per Week - Sign-On Bonus Eligible - Days - On Call - Job ID: 1206543 Employment Status: Full-Time More Information: Barnes-Jewish St. Peters (more...)
Company: BJC HealthCare
Location: Saint Peters
Posted on: 10/21/2020

Earn cash this Fall. Deliver with Uber!
Description: Deliver with Uber. Earn on your schedule. 10 Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekendsit 38 039 s up to you. 10 Earn Good Money. Youll earn by (more...)
Company: Uber Eats
Location: Saint Peters
Posted on: 10/21/2020

Log In or Create An Account

Get the latest Missouri jobs by following @recnetMO on Twitter!

O'Fallon RSS job feeds