Development

Big Data Architect (Viewership)

Contract-to-Hire

Brooksource

Apply Now

<< Return to Search Results

Sr. Data Warehousing Architect

Brooksource is searching for a Sr. Data Warehousing Architect to join their Fortune 70 Telecommunications Client in the St. Louis, MO or Charlotte, NC area. This position will join the Business Intelligence group and be assigned as the primary architect to support their Viewership Vertical to support and make decisions around viewer interactions. This person will have a main focus in big data and support their data lake platform. This position is responsible for understanding stakeholder needs and creating solutions from a technical perspective as well as high-level design and implementation strategies and logical and physical data models for end-to-end business intelligence and data warehousing solutions. This is a great opportunity for someone looking to grow long term in their career and make a difference in a dynamic, rapidly growing environment.

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 need

·      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

·      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

REQUIRED QUALIFICATIONS

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

·      Expertise with Big Data technologies such as Hadoop and Spark

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

·      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

·      Strong SQL skills

 

PREFERRED QUALIFICATIONS

·      Certification on Teradata and/or MicroStrategy is a plus

·      Familiarity with predictive modeling tools like SAS and/or R

·      Experience in cable or another telecommunications service provider is a plus

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

Related Work Experience

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

numerous data sources 8+

·      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+

EDUCATION

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

Master’s degree preferred

WORKING CONDITIONS

Office environment – 100% on site

Travel – 10%

 

 

Eight Eleven Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws

Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.

JO-2209-128620

Apply Now