What are the responsibilities and job description for the BI Architect position at BlueCross BlueShield of Illinois?
At HCSC, we consider our employees the cornerstone of our business and the foundation to our success. We enable employees to craft their career with curated development plans that set their learning path to a rewarding and fulfilling career.
Come join us and be part of a purpose driven company who is invested in your future!
Job Summary
An individual with the ability to design and develop data Integrations to deliver Enterprise BI Data Marts and BI Semantic Data layer(s). This role required strong technical skills in platforms such as RDMBS, MPP Platforms (Teradata), Hadoop Datalake and Azure cloud with ability to design and develop end to end data integration pipelines. As an Architect in the Enterprise Business Analytics & Business Intelligence team, this role is expected to manage multiple projects within the team and support others within the DAS organization. Many of these projects/initiatives are part of the HCSC & DAS initiatives to improve data processes, technology infrastructure and reporting/analytical services.
Responsibilities
Job Responsibilities: • Develop and maintain the overall data warehouse architecture: ETL (Extraction, Transformation, and Load) process, ODS (Operational Data Store), EDW (Enterprise Data Warehouse), Data Marts. • Develop ETL processes and Data Integration Pipelines, including data analysis and testing. • Establish interfaces with on-prem and cloud data sources • Participate in the configuration and auditing of the BI Data marts to ensure quality control of data. • Perform basic DBA functionality (Create tables, indexes, foreign key constraints, analyze performance statistics). • Analytical and quantitative problem-solving skills • Experience with Data Warehouse development and data consumption. • Participate in the design and development of the enterprise BI Data Marts • Involvement in the selection of technical solutions for business needs. • Knowledge of DevOps / continuous deployment / integration process • Monitor application data processing performance, implement changes to optimize performance. • Assist with development of cloud-based BI strategy, data pipelining, Data Lake and Lake House architectures.
Required Job Qualifications: * Bachelor's degree with 5 years experience or 9 years' equivalent experience with data integration platforms * Strong technical experience in Business Intelligence Architecture and technologies. * Experience working with a data architecture team to develop/manage a universal semantic model * Ability to work with business stakeholders to design, develop data products solution to enable insights. * Experience working with Hadoop tech stack like HDFS, Hive, HQL, Spark, Scala, Pyspark/python, Sqoop. * Experience working with MPP platforms like Teradata BTEQ, SQL etc * Experience working with Azure Cloud Analytics Services Synapse, ADLS, ADF, Azure SQL etc. * Knowledge of DevOps / continuous deployment / integration process and tools. * Knowledge of working with Enterprise grade scheduling tools like control M, Zena etc * Be an avid learner, gain a solid understanding of available data and promote innovative insights. * Strong analytical skills Written, communications and presentation skills, ability to source interpret and present analytics in a thoughtful and meaningful manner * Proactive self-starter, quick-learner, flexible team-player, ability to work both independently and as part of a team * Ability to multi-task, maintain strong attention to detail, and prioritize work within tight deadlines. Preferred Job Qualifications:
Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!
HCSC Employment Statement:
HCSC is committed to diversity in the workplace and to providing equal opportunity and affirmative action to employees and applicants. We are an Equal Opportunity Employment / Affirmative Action employer dedicated to workforce diversity and a drug-free and smoke-free workplace. Drug screening and background investigation are required, as allowed by law. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Come join us and be part of a purpose driven company who is invested in your future!
Job Summary
An individual with the ability to design and develop data Integrations to deliver Enterprise BI Data Marts and BI Semantic Data layer(s). This role required strong technical skills in platforms such as RDMBS, MPP Platforms (Teradata), Hadoop Datalake and Azure cloud with ability to design and develop end to end data integration pipelines. As an Architect in the Enterprise Business Analytics & Business Intelligence team, this role is expected to manage multiple projects within the team and support others within the DAS organization. Many of these projects/initiatives are part of the HCSC & DAS initiatives to improve data processes, technology infrastructure and reporting/analytical services.
Responsibilities
Job Responsibilities: • Develop and maintain the overall data warehouse architecture: ETL (Extraction, Transformation, and Load) process, ODS (Operational Data Store), EDW (Enterprise Data Warehouse), Data Marts. • Develop ETL processes and Data Integration Pipelines, including data analysis and testing. • Establish interfaces with on-prem and cloud data sources • Participate in the configuration and auditing of the BI Data marts to ensure quality control of data. • Perform basic DBA functionality (Create tables, indexes, foreign key constraints, analyze performance statistics). • Analytical and quantitative problem-solving skills • Experience with Data Warehouse development and data consumption. • Participate in the design and development of the enterprise BI Data Marts • Involvement in the selection of technical solutions for business needs. • Knowledge of DevOps / continuous deployment / integration process • Monitor application data processing performance, implement changes to optimize performance. • Assist with development of cloud-based BI strategy, data pipelining, Data Lake and Lake House architectures.
Required Job Qualifications: * Bachelor's degree with 5 years experience or 9 years' equivalent experience with data integration platforms * Strong technical experience in Business Intelligence Architecture and technologies. * Experience working with a data architecture team to develop/manage a universal semantic model * Ability to work with business stakeholders to design, develop data products solution to enable insights. * Experience working with Hadoop tech stack like HDFS, Hive, HQL, Spark, Scala, Pyspark/python, Sqoop. * Experience working with MPP platforms like Teradata BTEQ, SQL etc * Experience working with Azure Cloud Analytics Services Synapse, ADLS, ADF, Azure SQL etc. * Knowledge of DevOps / continuous deployment / integration process and tools. * Knowledge of working with Enterprise grade scheduling tools like control M, Zena etc * Be an avid learner, gain a solid understanding of available data and promote innovative insights. * Strong analytical skills Written, communications and presentation skills, ability to source interpret and present analytics in a thoughtful and meaningful manner * Proactive self-starter, quick-learner, flexible team-player, ability to work both independently and as part of a team * Ability to multi-task, maintain strong attention to detail, and prioritize work within tight deadlines. Preferred Job Qualifications:
Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!
HCSC Employment Statement:
HCSC is committed to diversity in the workplace and to providing equal opportunity and affirmative action to employees and applicants. We are an Equal Opportunity Employment / Affirmative Action employer dedicated to workforce diversity and a drug-free and smoke-free workplace. Drug screening and background investigation are required, as allowed by law. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Recommended Skills
- Activities Of Daily Living (Ad Ls)
- Apache Hadoop
- Apache Hive
- Apache Spark
- Architecture
- Attention To Detail
Salary : $63 - $73
BI Developer / Architect
w3r Consulting -
Chicago, IL
Sales - Business Development Director - Chicago
BI WORLDWIDE -
Brook, IL
Technical Specialist - Case Management
BI Incorporated -
Aurora, IL