Data Warehouse Manager at Excyl, Inc.
Washington, DC 20001
About the Job
Data Warehouse Manager
Washington, DC
Long Term
Remote
About the job
- As the hands-on Data Warehouse Manager for BCBS, you will play a crucial role in leading our data warehouse team and driving the design and development of our enterprise data warehouse architecture. You will be responsible for designing, implementing, and maintaining our Enterprise data warehouse and Data Pipelines, overseeing the entire end-to-end data warehouse process. This includes data acquisition, transformation, creation of scalable data models, and the development of analytics solutions.
- Your role goes beyond technical expertise – you will also be responsible for strategically utilizing data to optimize business operations and enable informed decision-making across the organization. By taking a proactive approach and being directly involved, you will ensure the reliability, scalability, and performance of BCBS data warehouse.
Responsibilities and Duties:
- Lead the designing, developing, implementing, and sustaining the Enterprise Data Warehouse architecture with main focus on achieving scalability, optimizing performance, and ensuring impeccable data integrity across all of our Snowflake environments.
- Take a hands-on approach in designing, developing, and supporting low-latency data pipelines, prioritizing data quality, accuracy, reliability, and efficiency
- Lead a dynamic team of highly skilled data engineers, serving as a mentor and setting the stage for a collaborative and high-performing culture of innovation and continuous improvement.
- Oversee the Operations Support for our Data Warehouse and ETL Processes, ensuring smooth functioning and continuous optimization by enhancing SQL Queries, fine-tuning the design structure of the Data Warehouse, and elevating overall performance and query efficiency
- Collaborate closely with cross-functional teams including, Enterprise Architects, Business Analysts, Product Owners, Solution Architects actively engaging in gathering comprehensive business requirements and translate these requirements into scalable data cloud and Enterprise Data Warehouse (EDW) solutions that precisely align with organizational needs
- Play a hands-on role in conducting data modeling, ETL (Extract, Transform, Load) development, and data integration processes.
Skills Required:
- Familiarity with big data, data warehouse architecture and design principles
- Strong understanding of database management systems, data modeling techniques, data profiling and data cleansing techniques
- Knowledge of Snowflake's data sharing and replication features.
- Proficiency in SQL for data querying, manipulation, and analysis.
- Experience with ETL (Extract, Transform, Load) tools and processes.
- Ability to translate business requirements into scalable EDW solutions.
- Streaming Technologies like AWS Kinesis
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- 12+ years of hands-on experience in data warehousing, ETL development, and data modelling, with a strong track record of designing and implementing scalable Enterprise Data Warehouse (EDW) solutions.
- Proficiency in SQL and deep knowledge of various database management systems (e.g., Snowflake, Azure, Redshift, Teradata, Oracle, SQL Server).
- Experience utilizing ETL tools and technologies such as Abinitio, SSIS, Informatica
- Expertise in data modeling techniques, with a focus on dimensional modeling and star schema design.
- Familiarity with data governance principles and adeptness in implementing security best practices.
- Excellent problem-solving and troubleshooting abilities, coupled with a proven track record of diagnosing and resolving complex database issues.
- Demonstrated leadership and team management skills, with the ability to lead by example and inspire others to strive for excellence.
- Experience in the Healthcare industry with Member Enrollment will be a significant advantage.