CNA is looking to design, develop, and integrate strategic, high-priority data applications across the entire software development lifecycle (Agile) to optimize data pipeline performance and deliver value to the CNA brand, customers, and key internal stakeholders.
Requirements
- Strong knowledge of relational database concepts, ETL/ELT, star schema, data modeling.
- Strong data integration design and development, ensuring accuracy and ease of consumption. Strong troubleshooting and problem solving skills.
- Proficient in Python or advanced SQL in a business environment with large-scale, complex datasets.
- Preferred experience in building data analytics solutions using On-premise Oracle EXADATA, Google Cloud Platform services such as Google BigQuery, Cloud Storage, Dataflow, DataProc, Pub/Sub, Cloud Composer, or DataPrep.
- Working knowledge of Data Analytics, Business Intelligence tools like Power BI preferred.
- 2+ years of coding proficiency in at least one programming language Python Unix Shell Script Preferred, Unix Shell Script, SQL, PLSQL Required.
- Informatica Power Center / IDMC Required
Responsibilities
- Participates in the building of large-scale data processing systems (On-premise and Cloud), optimize data pipeline performance as needed to meet the data loads SLA’s. Applies technical knowledge on data modeling and best engineering practices.
- May lead or sub-lead the design, implementation and automation of data pipelines sourcing data from internal and external systems, transforming the data for the optimal needs of various systems and business requirements.
- May lead or sub-lead robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
- May lead or sub-lead the design of complex physical data models, projects (On-premise and Cloud) including SQL database systems. May lead or sub-lead the creation of integrated data views based on business or analytics requirements.
- Researches, identifies and implements process improvements that address complex technology gaps. Builds strong knowledge of technology enablers.
- May lead or sub-lead the design and building of data solutions and applications that enable reporting, analytics, data science, and data management.
- Need to play a SME role in resolving high priority data quality issues & production incidents and getting them addressed as per defined SLA’s.
Other
- An individual contributor role that provides a high level of expertise.
- Works with external (and offshore) resources as required.
- Actively adheres to established quality and reliability standards, and ensures team adheres to the same quality and standards working in an Agile development environment.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies. Drives the evolution of CNA application development processes and standards.
- Strong communication and interpersonal skills and the ability to work effectively with peers and team members in a highly matrixed environment.
